Hello,
I'm currently building a pipeline where I am calling a REST API using the web connector and then using the Copy Activity to save the data to a SQL DB. The API URL I want to use has the following structure:
https://api-url.api.com/param?start=0&limit=10&sort=[{"param1": "subparam1", "param2": "subparam2"}]
I can ping this endpoint fine in Python although having trouble building this in the Add Dynamic content section. I am currently trying:
@{concat(
'https://api-url.api.com/param?start',
variable1,
'&limit=',
variable2,
'&sort=[{"param1": "subparam1", "param2": "subparam2"}]'})
although this keeps erroring out. I've tried passing in the last part as follows:
@json(string(&sort=[{"param1": "subparam1", "param2": "subparam2"}])
string(&sort=[{"param1": "subparam1", "param2": "subparam2"}])
&sort=[[{<!-- -->{"param1": "subparam1", "param2": "subparam2"}}]]
&sort=[{""param1"": ""subparam1"", ""param2"": ""subparam2""}]
&sort=[{<!-- -->{"param1": "subparam1", "param2": "subparam2"}}]
&sort=[[{"param1": "subparam1", "param2": "subparam2"}]
However, I keep getting an error. I presume it's because of the way Data Factory is parsing this as a string.
Any explanation or help would be great.
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is