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

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

blopez11  thanks a lot.