Forum Discussion

rdubs's avatar
rdubs
Frequent Visitor
7 years ago
Solved

API authentication error on scheduled refresh!

I have a couple of API feeds which I connected through the web connector. These require an api key for authentication, I added this in the header using the advanced section.   The data refresh work...
Need Help
  • blopez11's avatar
    blopez11
    7 years ago

    Try this, substituting in your api key, and see if you see the same error

     

    let
    vBaseUrl = "https://api.projectmanager.com",
    vPath = "api/v1/projects.json",
    vHeaders = [ #"apikey"="this is where i put my key" ],
    Source = Web.Contents ( vBaseUrl, [RelativePath=vPath, Headers=vHeaders] ),
    Json = Json.Document ( Source )
    in
    Json

blopez11's avatar
blopez11
Super User
7 years ago

For web service APIs, what works in the Desktop doesn't always work in the service

It is likely due to anonymous authentication not being supported for the URL in the error message

It would be helpful to see the M code used in your query, you can blur out the API key

 

  • blopez11's avatar
    blopez11
    Super User
    7 years ago

    Try this, substituting in your api key, and see if you see the same error

     

    let
    vBaseUrl = "https://api.projectmanager.com",
    vPath = "api/v1/projects.json",
    vHeaders = [ #"apikey"="this is where i put my key" ],
    Source = Web.Contents ( vBaseUrl, [RelativePath=vPath, Headers=vHeaders] ),
    Json = Json.Document ( Source )
    in
    Json

    • rdubs's avatar
      rdubs
      Frequent Visitor
      7 years ago

      Great, thanks blopez11 

       

      Worked a treat!

    • rdubs's avatar
      rdubs
      Frequent Visitor
      7 years ago

      It worked at first blopez11  and let me put details into the 'basic' authentication section, but when the scheduled refresh came through it showed me this:

       

       

      Is there a way of just including the api key into the URL itself?

      • blopez11's avatar
        blopez11
        Super User
        7 years ago

        Try using anonymous authentication, I thought that was the method you were using from the initial comment.

        If you need basic autentication, then that requires a username and password

        For basic, sometimes I see vendors have some kind of combo value for the password (i.e. api user password + key)

         

        I guess I am not sure of the authentication your API requires

         

    • opsus's avatar
      opsus
      Regular Visitor
      6 years ago

      I tried this exactly same approach and my datasets seems to be working correctly as webapis, but I still get the credential warnings on the powerbi service when I try to connect the gateway even using anonymous authentication.

      Any suggestions?