I can repost this to another forum if needed - there are so many I didn't know where to start. I had this question up on stackoverflow for 5 minutes before it got closed. One person recommended a C# application.

Original Question:

I need some direction on the best app/platform/process for developing a project that can both communicate with a Microsoft SQL server and also send/receive API calls.

I currently have a excel spreadsheet that is a bit of a Frankenstein's monster. One part of the spreadsheet can pull data in from a company Microsoft SQL server and the other part of the program can send/receive API calls/data to our Hubspot CRM platform. (cloud based) Both were miserable to get working but they function.

Excel seems the absolute WORST program to be the "interpreter" or "go between". I just needed the spreadsheet to populate with data from both sources.

I need to develop an app or program that sits and sniffs Hubspot via frequent API calls, then connects and retrieves information from the Microsoft SQL server/database and pushes it back to Hubspot. It'll just be something that is sitting/running all the time.

Any suggestions are welcome. I do have 2019 Visual Studio / Visual Studio Code / SQL Server Management Studio on my work laptop. I'm not free to download/install just anything. My connection to the companies server uses Microsoft Authentication (not username/password) so I won't be able to custom code Hubspot to make a direct connection. (nor do I want to risk the legal/security risks there or even believe I have the skills to do that)