I can query this api call (a dummy url): https://something.com/actions to produce the following records:
I can also query the API call: https://something.com/actions/{id}/analysis-code-values by dynamically passing each ActionID as part of the URL:
I can achieve this logic on Power BI, however I want to replicate it on Azure Data Factory using a copy data activity to take source data from Rest API and sink into an Azure SQL Database.
Here is what I have done so far:
Linked Service:
For each activity:
How would I use the above to replicate the logic I achieved on Power BI?