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 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