Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
Anonymous
Not applicable

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  @Anonymous ,

 

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!

Anonymous
Not applicable

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
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.