How call api for json column... In paower bi

[Kiranbrahma]

 

• 

   

[lbendlin]

There are a lot of thing here that are not right. Starting with the payload - that is supposed to contain the POST parameters of the call. 

The way you call the function is also the other way round  from what it should be.

Can you successfully call your API with tools like Postman? 

[Kiranbrahma]

Hi Ibendlin, 

Thank you for reply, 

I test that API in fastAPI . 

 

[lbendlin]

all the items listed in -d  of your curl call need to go into the Web.Contents request body.

[Kiranbrahma]

How it will.... Can you please share sample query please

[lbendlin]

Please refer to example 2 

Web.Contents - PowerQuery M | Microsoft Learn