Forum Discussion

Sam_Jain's avatar
Sam_Jain
Helper III
4 years ago
Solved

Web API connection

Hello Commnuity,   Firstly apologies for asking this question again, the first one got marked and accepted as solution by default (my fault here for not repsonding back on time) However, my issue s...
Need Help
  • ImkeF's avatar
    ImkeF
    4 years ago

    Hi Sam_Jain ,
    hard to tell, quickly went through all the other answers here without checking all the links and details.
    So I assume that you're using anonymus authentication with the key?
    If that's not working, I would recommend to compare the generated queries by Postman and PBI using Fiddler or any other tool.
    See where the queries differ and try to adjust accordingly.

     

Sam_Jain's avatar
Sam_Jain
Helper III
4 years ago

Hello parry2k 

While researching upon the topic i had come across this video. Sadly, i can't seem to take much out of it.

 

I tried the section where i include the API key name in the M code itslef and when asked for authentication i entered the key value, this time it let me through without the "an API key value needs to be specified error" which occurs when i use the direct web connector. However as soon as it said connecting to xyz.com i got a second error which reads "Expression error: access to the resource is forbidden" i have tried clearing the permissions and it still is on the same error.

 

The Mcode is as follows:

 

Source = Web.Contents("https://api.xyz.com/page-metrics/get",[ApiKeyName="x_api_key"])

 

Also, it is a static key that i have!

 

Any inputs to overcome this?

 

Thanks

 

parry2k's avatar
parry2k
Super User
4 years ago

Sam_Jain it is very hard to provide details without looking at the issue.

  • Sam_Jain's avatar
    Sam_Jain
    Helper III
    4 years ago

    Hello parry2k 

     

    Can you please tell what kind of details i can share here, while respecting the confidentiaity of the process.

     

    Thanks.