JSON-to-Database RPA Automation
Budget: ₹1,500 – ₹12,500 INR
I need a reliable RPA workflow that takes incoming JSON files, parses their contents, and inserts or updates the records in our custom database with zero manual touch points. The core focus is data entry and ongoing data management, not invoicing or support, so accuracy and idempotent writes are critical.
You’ll receive sample JSON payloads and direct access to a staging clone of the database (PostgreSQL). From there, build a bot—UiPath, Automation Anywhere, Blue Prism or a well-documented Python-based alternative is fine—that watches a folder or API endpoint for new JSON, validates each file, maps fields to the corresponding tables, logs every transaction, and notifies me of any exceptions.
The solution is done when I can drop a fresh JSON file into the watch location and see the data reflected in the proper tables, complete with an audit trail and rollback option. Source code, configuration scripts, and brief runbook are expected so we can move the workflow to production after acceptance testing.
You’ll receive sample JSON payloads and direct access to a staging clone of the database (PostgreSQL). From there, build a bot—UiPath, Automation Anywhere, Blue Prism or a well-documented Python-based alternative is fine—that watches a folder or API endpoint for new JSON, validates each file, maps fields to the corresponding tables, logs every transaction, and notifies me of any exceptions.
The solution is done when I can drop a fresh JSON file into the watch location and see the data reflected in the proper tables, complete with an audit trail and rollback option. Source code, configuration scripts, and brief runbook are expected so we can move the workflow to production after acceptance testing.