Making an API's call

Question

Hi All,

I wanted to make API calls maybe twice a day or even if I wanted to make it every few minutes and put the API data (JSON) into ADLS and then into Azure SQL.

What is the best Azure Services I can use for both scenarios which is scalable? How would the Azure SQL deal with heavily nested JSON data?

Thank You.

Answer 1

Hello @Kman , you may consider Timer trigger in this case. You can use Httpclient to make an API call to the endpoints mentioned in the document. You may need to pass an authorization token for validation , for that please refer to this

You may also check logic app recurrence trigger : https://learn.microsoft.com/en-us/azure/logic-apps/tutorial-build-schedule-recurring-logic-app-workflow
or, scheduler : https://learn.microsoft.com/en-us/azure/logic-apps/concepts-schedule-automated-recurring-tasks-workflows
https://learn.microsoft.com/en-us/azure/connectors/connectors-native-recurrence

and, for the ADLS and Sql server :
https://learn.microsoft.com/en-us/connectors/azuredatalake/
https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure