CODEWITHSUNDEEP
azureazure-data-factory
Paul
Paul

Reputation: 3263

Add Parameter Values to Query String of get request in ADF

I have a Copy Data task which is obtaining data from an API

The API is a GET call to a method and requires 2 parameters

_token
Symbols

I have defined these as parameters

enter image description here

What is the syntax that allows me to use the values of my parameters as the values that are in the query string? So in the screenshot above Symbols is hard coded, but I want the value to be the value of the parameters

I need a screen solution rather than code please as I am not comfortable with ADF yet and I dont know how to get to the code/ARM views

Paul

Upvotes: 0

Views: 1563

Answers (1)

KarthikBhyresh-MT
KarthikBhyresh-MT

Reputation: 5034

Using a feature called string interpolation where expressions are wrapped in @{ ... }

enter image description here

Click on the Base URL field. Add Parameters. Using Concat expression function,

Example:

@{Concat('https://stackoverflow.com/questions/GetRealTimeRates?',linkedService().Symbols,'=',linkedService()._token)}

Add first parameter:

enter image description here

Add second parameter:

enter image description here

Test connection. If you see any error, it would provide a description as to debug further.

enter image description here

Upvotes: 1

Related Questions