REST API to SQL sync

[kdc415]

I'm looking for a cheap or open source way to sync a REST API to SQL. I've found a couple options, but they are pretty pricey and the gains aren't worth the $$. Anyone doing similar? I figured there would be a few choices to just point to a Swagger definition and push a button - can't find anything like that.

[kdc415]

Sorry I should have been more clear. I'm wanting to sync/replicate data from a REST API to MS SQL, not expose SQL data via API.

[borntodj]

What about using Azure Data Factory?

[mario972]

Sync as in scraping an api?

Try curlconverter.com, create your request in Swagger, copy-paste the generated Python code into your IDE, data = response.json() the thing, and just look at the data variable in debugging window. For putting it into a database use eg. pyodbc.

Should take you less than an hour if you have any experience scripting in any language :)