This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 47%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ9%3C/text%3E%3C/svg%3E)
Is it possible to GET data from external REST API server TO Azure SQL database?
An Azure relational database service.
Answer accepted by question author
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
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.