cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bpie123
Helper I
Helper I

Web.Contents using Get method and passing RequestBody

I am trying to call 3rd party Web.Content Get method , it requires a json parameter.   

My code is:
header = [#"Content-Type"="application/json", #"Authorization"="Bearer " & #"GetAccessToken"()]
request = Web.Contents(url,[Headers=header,Query=[method="get", Content="application/json", body=query2, ParameterType="RequestBody"]])
 
Postman has C# RestSharp has 
request.AddParameter("application/json", body,  ParameterType.RequestBody);
 
Fiddler shows:   "errors":{"":["A non-empty request body is required."]}. 
 
Is there a way to set ParameterType as RequestBody and pass in Web.Contents call?     If not, any other suggestions?
3 REPLIES 3
v-kelly-msft
Community Support
Community Support

 Hi  @Bpie123 ,

 

Check below thread for help:

https://community.powerbi.com/t5/Desktop/add-json-parameters-in-advance-query-editor-Json-Document-W...

 

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!

Sorry, but no your response did not answer my question.  I am asking how to include json in a Request Body of GET api.   Other replies have stated this is not possible. 

Thanks

lbendlin
Super User
Super User

"I am trying to call 3rd party Web.Content Get method , it requires a json parameter.  "

 

That is not possible with a GET request. You need to use a POST request by encoding your JSON payload into the Content attribute of the request.

Web.Contents - PowerQuery M | Microsoft Docs

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors