Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi!
I have the following cURL request that works in POSTMAN that I can't figure out how to convert to M for the life of me.
curl --location 'https://thisisaURL.com' \
--header 'ASessionID: ThisisaSessionID' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--data-urlencode 'searchCriteria={"projectName": "HerecomestheProjectName","startDateTime": "01-Jan-2020 16:35","endDateTime": "01-May-2023 16:35"}'
According to the documentation the API wants the searchCriteria passed as JSON object and I've been fighting with Json.FromValue() and Record.ToBinary() without any luck. Any help would be greatly appreciated!
Solved! Go to Solution.
ChatGPT came to the rescue, this code works:
let
url = "https://thisisaURL.com",
headers = [
#"ASessionID" = "ThisisaSessionID",
#"Content-Type" = "application/x-www-form-urlencoded"
],
body = "searchCriteria={""projectName"":""ThisisaProjectName"",""startDateTime"":""01-Jan-2020 16:35"",""endDateTime"":""01-May-2023 16:35""}",
options = [
Headers = headers,
Content = Text.ToBinary(body),
ManualStatusHandling = {400, 404, 500, 502, 503, 504}
],
response = Web.Contents(url, options)
in
response
ChatGPT came to the rescue, this code works:
let
url = "https://thisisaURL.com",
headers = [
#"ASessionID" = "ThisisaSessionID",
#"Content-Type" = "application/x-www-form-urlencoded"
],
body = "searchCriteria={""projectName"":""ThisisaProjectName"",""startDateTime"":""01-Jan-2020 16:35"",""endDateTime"":""01-May-2023 16:35""}",
options = [
Headers = headers,
Content = Text.ToBinary(body),
ManualStatusHandling = {400, 404, 500, 502, 503, 504}
],
response = Web.Contents(url, options)
in
response
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |