You’re offline. This is a read only version of the page.
Announcements
480
Hi Team,
I have a below HTTP GET link:
https://abc.xyz.io/api/sync/ems/powerbi?date_start="&startDateText&"&date_end="&endDateText, [Headers=[Token="7901d563-a86f-4031-8900-7e0378ae"]]))
where the startDate and the endDate need to be put dynamically in the HTTP card. Please help.
Hi @cyberco01
You can use the Uri.BuildQueryString function to dynamically construct the query string with the start and end date.
You can create two variables startDateText and endDateText and pass them in the function:
Copy code
let
startDateText = "2021-01-01",
endDateText = "2021-01-31",
url = "https://abc.xyz.io/api/sync/ems/powerbi?date_start=" & Uri.EscapeDataString(startDateText) & "&date_end=" & Uri.EscapeDataString(endDateText),
response = Json.Document(Web.Contents(url,[Headers=[Token="7901d563-a86f-4031-8900-7e0378ae"]]))
in
response
Share
Report
All responses (
Answers (
