Hi @sam nick ,
Thanks for using Microsoft Q&A forum and posting your query.
From the question, I wasn't sure where (linked service or dataset or somewhere else) you are trying to parameterize this, but in general if you would like to form this URL using dynamic expression in pipeline level, then you can try as below to well form the URL.
@concat('https://endpoint.com/api/search/val?query=created_at:>', '''', '2022-01-01', '''', ' AND created_at:<', '''', '2022-02-01', '''')
This will result in below URL : https://endpoint.com/api/search/val?query=created_at:>'2022-01-01' AND created_at:<'2022-02-01`
Below is sample JSON payload which I used for testing.
{
"name": "pipeline13",
"properties": {
"activities": [
{
"name": "Set variable1",
"type": "SetVariable",
"dependsOn": [],
"userProperties": [],
"typeProperties": {
"variableName": "var",
"value": {
"value": "@concat('https://endpoint.com/api/search/val?query=created_at:>', '''', '2022-01-01', '''', ' AND created_at:<', '''', '2022-02-01', '''')",
"type": "Expression"
}
}
}
],
"variables": {
"var": {
"type": "String"
}
},
"annotations": []
}
}
Hope this info helps. In case if you requirement is different than my understanding, please share few additional details and we will assist accordingly.
Please don’t forget to Accept Answer
and Yes
for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.