You’re offline. This is a read only version of the page.
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
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
