Convert cURL POST request to M

[ExcelAthlete]

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!

[ExcelAthlete · Accepted 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

[amitchandak]

@ExcelAthlete , refer if this can help

https://www.reddit.com/r/PowerBI/comments/12ay6i4/how_to_use_a_curl_request_in_pq/

https://community.powerbi.com/t5/Desktop/Request-curl-API/td-p/1521152