Forum Discussion
API authentication error on scheduled refresh!
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
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?
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
blopez11 thanks a lot.