GET API Request with JSON Body

[userabd1234]

I am trying to use a GET API that has a query parameter & json body content needed for the GET request. I am getting a 405 error. Any help is appreciated

let

url = "",

body = "",

response = Web.Contents(url,

[

Headers=[#"Content-Type"="application/json", #"Accept"="*/*"],
Content = Text.ToBinary(body),
Query = reportFormat = "csv"

]
),

Source = Csv.Document(response)
in

Source

[Anonymous]

Hi @userabd1234 ,

The 405 error generally occurs because the request method is not allowed. If content exists, change the request method to POST and pass JSON data in the request body. To use a GET request, attach the parameters to the end of the URL using the symbol ? to append the parameters to the end of the URL.

Here's the relevant link:  Web.Contents - PowerQuery M | Microsoft Learn

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[userabd1234]

Hi, @Anonymous 

I can't change the API to post, and the JSON body cannot live within the URL. Is there not a way to call a GET API that requires a JSON body within powerbi? I've read other situations where using web contents with content automatically turns the call into a POST. How do you get around this limitation if you have a GET API with a json body?