I need a clean, reliable pipeline that pulls everything EWorks Manager exposes—customer records, job details, plus all invoice and payment history—straight into my MySQL instance. The API endpoints are already active; what’s missing is the middleware that authenticates, paginates, transforms and inserts the data exactly the way my internal reporting tools expect it. You’ll receive a detailed relational schema showing tables, keys, and field formats, so you can map each API object without guessing. I’m happy for you to propose the best approach for scheduling (cron, queued worker, serverless function, etc.) as long as it keeps the database continuously in-sync and can be re-run without duplicating rows. Deliverables • A script or small service (Python, Node, or PHP—your choice) that fetches the three data groups and populates the MySQL tables according to the schema • Clear environment and setup instructions plus SQL migrations, so I can recreate everything on another server in one go • Basic logging and error handling: failed calls should be retried or clearly reported without crashing the whole import • A short README outlining how to extend the importer if EWorks adds new endpoints later Once it’s running smoothly in my test environment I’ll sign off, then we can schedule the production cut-over.