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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MovhHMH
Frequent Visitor

Looping problem with POST request to API using API key & request body

Sorry if there's bad formatting, this is my first time posting here.

I've been trying to wrap my head around this problem, and tried looking for a solution, but ultimately came up empty handed. Here is the scenario, I have an API I am trying to access. This is done through an API key and its value. I can connect to it no problem. The problem arises when I need to include the body (internal error 500 otherwise). I then include the body as content, but I now run into the issue that this is only supported when connecting anonimously. When I try this, I am then met with the following "A web API key is required when a web API key name is provided." Hence, it seems to me that fixing one causes the other, which is why I'm currently in a loop to try and figure out what to do. From what I've read, I understand that a POST request is only possible through the anonymous authentication method. But how can I resolve this issue then? Code below (replaced some values with placeholders).

 

 

let
     body = "{""query_filter"":""}",
     Source = Web.Contents(
          "link?key=value",
          [
          ApiKeyName = "key",
          Headers = [ #"Content-Type" = "application/json" ],
          Content = Json.FromValue(body)
          ]
     ),

     result = Json.Document(Source)
in
     result

 


For the anonymous web content access I use the same link:
link?key=value

1 ACCEPTED SOLUTION
MovhHMH
Frequent Visitor

Thanks for the response Ibendlin. I have figured out the issue. It seems unfortunately, it is not possible to utilize authorization while also trying to use the "Content" parameter, as it changes Power BI's GET request into a POST request, which can only be done on anonymous authorization.

 

The issue was resolved, however it was done by removing the requirement of the "content" parameter on the APIs end. 

View solution in original post

2 REPLIES 2
MovhHMH
Frequent Visitor

Thanks for the response Ibendlin. I have figured out the issue. It seems unfortunately, it is not possible to utilize authorization while also trying to use the "Content" parameter, as it changes Power BI's GET request into a POST request, which can only be done on anonymous authorization.

 

The issue was resolved, however it was done by removing the requirement of the "content" parameter on the APIs end. 

lbendlin
Super User
Super User

Please consult the documentation, look at the examples.

 

Web.Contents - PowerQuery M | Microsoft Learn

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors