cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rdubs Frequent Visitor
Frequent Visitor

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 works fine on the desktop version but I have tried to set up a scheduled refresh and I am getting an authentication error. It seems as though it isn't pulling through the api key in the header:

 

error message.png

 

I feel as though M might be the answer but i have little (to no) experience with M so any help would be appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
blopez11 Established Member
Established Member

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

View solution in original post

6 REPLIES 6
blopez11 Established Member
Established Member

Re: API authentication error on scheduled refresh!

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

 

rdubs Frequent Visitor
Frequent Visitor

Re: API authentication error on scheduled refresh!

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
Source

 

 

Highlighted
blopez11 Established Member
Established Member

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

View solution in original post

rdubs Frequent Visitor
Frequent Visitor

Re: API authentication error on scheduled refresh!

Great, thanks @blopez11 

 

Worked a treat!

rdubs Frequent Visitor
Frequent Visitor

Re: API authentication error on scheduled refresh!

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:

 

Another error.png

 

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

blopez11 Established Member
Established Member

Re: API authentication error on scheduled refresh!

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

 

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,592 guests
Please welcome our newest community members: