Is it possible to GET data from external REST API server TO Azure SQL database?

Question

Is it possible to GET data from external REST API server TO Azure SQL database?

Answer 1

You can use Azure Data Factory to copy data from a REST API data source to an Azure SQL database (destination/sink) as explaned in detail in this LinkedIn article.

Here you will find a YouTube video demonstrating the same.

Answer 2

Hi
Jocelyn Kwong •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to know if Is it possible to GET data from external REST API server TO Azure SQL database.

In addition to above answer,

Yes, we can copy the data from REST API to Azure SQL Database through Azure Data Factory or Azure Synapse Analytics pipelines using Copy Activity- REST Connector. Alternatively, Web activity could also be used.

Example of the scenario illustrated here in detailed video: How to Copy Data from Rest API to Azure SQL Database in ADF | Copy Activity, Rest Linked Service

Do checkout and let us know if the above two ways helped in you case. If not, please share more details about the source data etc. so that we can further assist you.

Hope this helps. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Thank you.