Copy data from an API to Azure SQL DB

Question

Hi All,

I need to copy data from an API: https://data.nj.gov/resource/pruu-wapw.json to Azure SQL database

How to proceed with this?

Answer 1

@Priya Jha Thanks for using Microsoft Q&A !!

You can use Copy Data activity with REST dataset to call the API to fetch and load the data in Azure SQL Server.

For the shared API endpoint I could see that it supports anonymous authentication as well, so you need to select authentication type as anonymous while creating the source linked service as shown below -

Please refer to the below gif which creates a new table at source and fetch the data from the above API. Hope this helps.

Refer to the Copy data from and to a REST endpoint by using Azure Data Factory for additional information about using REST endpoints in Azure Data Factory.

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Answer 2

Hello! Thanks for your answer! This is what I was looking for!
I have another questions

1. Is function "REST" free in free tier Azure account??? I think it is included in Azure Data Factory?
2. As we have https://data.nj.gov/resource/pruu-wapw.json API we can import data to one DB, but
   what if we have related API with several related tabs like...
   https://data.nj.gov/resource/**pruu-wapw1.json**
   https://data.nj.gov/resource/**pruu-wapw2.json**
   https://data.nj.gov/resource/**pruu-wapw3.json**
   can we use several URL to collect it in one DB (in REST operation)?
   or we must call these operations one after the other but with different URLs to one base?

Answer 3

Hi,
i copied data from REST API to azure SQL DB,
the job run whithout any error message but it return one empty row in my SQL table,
i did the same job but i replaced blob storage instead sql table and it work perfectly, but with sql table it doesnt return any data,
can you help me to fix that please ?
thank you