We are exposing header to community/ideas via header endpoint which are on different UI frameworks -->

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!

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)
    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)
    response

@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

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

We are exposing header to community/ideas via header endpoint which are on different UI frameworks -->