API POST request with body containing text variable

[Richard_Halsall]

Hi

I am looking for help after forum research I am struggling to solve 

I have the following API call which works fine and returns the correct data in Postman

I have 2 versions of m code

Version 1

let

url = "https://gev.collabaro.com/tapi/v1/",

RelativePath="asset/list",

headers=[#"X-Auth-Token" ="XXXXXXX"],

body = "{""extended"" : ""True"",

    }",

source = Web.Contents(

url& RelativePath,

[Headers = headers,Content = Text.ToBinary(body)]

),

jsonresponse = Json.Document(source),

    #"Converted to Table" = Record.ToTable(jsonresponse),

    #"Removed Other Columns" = Table.SelectColumns(#"Converted to Table",{"Value"}),

    #"Expanded Value" = Table.ExpandListColumn(#"Removed Other Columns", "Value")

in

    #"Expanded Value"

Version 2

let

Json = Json.FromValue({[extended= true]}),

url = "https://gev.collabaro.com/tapi/v1/",
RelativePath="asset/list",
headers=[#"X-Auth-Token" ="XXXXXXX"],

source = Web.Contents(

url& RelativePath,
[Headers = headers,Content = Json]
),

jsonresponse = Json.Document(source),

#"Converted to Table" = Record.ToTable(jsonresponse),
#"Removed Other Columns" = Table.SelectColumns(#"Converted to Table",{"Value"}),
#"Expanded Value" = Table.ExpandListColumn(#"Removed Other Columns", "Value")
in
#"Expanded Value"

Both of which are not passing the body variable of extended. I have checked with the developer and extended is a data type of text

Can anybody help with a solution

Many thanks

[lbendlin]

When you look at the network trace do you see a POST request or a GET request being created?

[Richard_Halsall]

Hi, I see a POST request

[lbendlin · Accepted solution]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .