Create and Integrate Third-Party API to MySQL

My Windows-based application already writes records into a local MySQL database and makes occasional calls with an existing Google API key. The next step is to let a separate third-party API push its own JSON payloads into that same MySQL instance. Here is what I need: • A small, reliable service (Windows service, lightweight REST endpoint, or similar) that receives JSON directly from the third-party API and inserts or updates the appropriate MySQL tables without interrupting what the current desktop program is doing. • Full handling of field mapping, basic validation, and any error logging so I can trace failures quickly. • Minimal configuration on my side—ideally just a single config file or environment variables for database credentials and the existing Google key. • Clear deployment steps so I can reproduce the setup on other PCs if needed, plus a short README explaining how the JSON schema is mapped. Acceptance criteria – A live test in which the third-party API posts sample JSON and I can see the data appear in MySQL in real time. – Source code delivered (Python, .NET, Node.js—your call as long as it runs on Windows) with concise comments. – A brief walkthrough so I understand how to restart or modify the service. If something here is unclear, let me know and we can adjust quickly.