A Python CLI tool that reads structured data from files (CSV, JSON, Excel) and sends it to REST APIs or SQL databases via configurable templates. Ideal for ETL tasks, data migration, or batch input automation without writing boilerplate code.
Features
- Multi-format input — read CSV, JSON, or Excel files with automatic schema detection
- Configurable output — POST to REST APIs or insert into PostgreSQL, MySQL, SQLite via connection string
- Template-based mapping — define field mappings and transformations in a YAML config file
- Dry-run mode — preview all operations without executing, with detailed logs
- Batching & rate limiting — control request concurrency and delay to avoid API throttling
Usage
python extract_input.py --input data.csv --config mapping.yaml --output api --endpoint https://api.example.com/items
Requirements
Python 3.8+. Install dependencies:
pip install -r requirements.txt
Download
Buy once, download immediately. ZIP includes the full script, README, and usage examples.
License
Personal & Commercial Use. You may use this tool in your own personal and commercial projects. Redistribution or resale of the source code is not permitted.