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
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
Hi blopez11
thanks for the speedy response!
This is the M code:
let
Source = Json.Document(Web.Contents("https://api.projectmanager.com/api/v1/projects.json", [Headers=[apikey="this is where i put my key"]]))
in
SourceTry 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
