1: Copy the Response of REST API with parameters to Azure SQL DB using Azure Data Factory

[@sachinkhairnar8583]

Thanks for creating this video example, it helped me

[@elsworthj]

Thank you, saved me hours of work

[@EduTechGyan2023]

Thank you so much :)

[@SuprajaBijjigiri-o4s]

Api link is not working how to rectify it

[@EduTechGyan2023]

Hi The API link still working the problem is SSL is not secure: dummyapis.com/dummy/employee

[@garywhittaker8832]

Cant get it to work with a variable parameter, for example my API requires.... ?incorporated_from=2024-04-23 but i need to inject todays date. like this ?incorporated_from=@utcNow('yyyy-MM-dd')

[@EduTechGyan2023]

Hi @garywhittaker8832, Please following the below steps and you will get the expected result: In Azure Data Factory (ADF), you can dynamically set a query parameter like incorporated_from to include today's date using the utcNow() function in a dataset parameter or pipeline parameter. Here's how you can achieve it: Step 1: Add a Query Parameter in the Dataset In the dataset you're using for the API call, go to the Parameters tab and add a parameter (e.g., IncorporatedFrom). Modify the dataset's URL to include this parameter dynamically: api.example.com/resource?incorporated_from=@{dataset().IncorporatedFrom} Step 2: Pass the Current Date to the Parameter In the pipeline, select the activity that uses the dataset (e.g., the HTTP activity). In the Settings tab, pass a value for the IncorporatedFrom parameter using the following dynamic expression: @utcNow('yyyy-MM-dd') Step 3: Test the API Call When you run the pipeline, the utcNow() function dynamically injects today's date in the correct format into the API URL. For example, if today's date is 2024-11-24, the API call will look like this: api.example.com/resource?incorporated_from=2024-11-24 Troubleshooting Ensure the query parameter format matches what the API expects. If you're building the URL entirely in the pipeline, you can directly use a dynamic content expression in the HTTP activity's URL field: api.example.com/resource?incorporated_from=@{utcNow('yyyy-MM-dd')} Let me know if you need further clarification!