Connect to web api authentication

[Anonymous]

Hello Everybody,

im trying to connect to the ixon api.

This works:

So when i try to authenticate via the build in power bi basci auth the querry will be:

In the Data Source Options I have set my EmailAdress and the Password in the Basic Authetification.

The Api doc is telling me:

The format of the basic authentication is “Basic authenticationstring”. The
authenticationstring is formed by encoding the string “email:one time
password:password” with base-64. The “one time password“ is only required when
Two-factor authentication is enabled and is otherwise empty.

I am leaving the one time password empty so i just added ":" after my email. Somehow it wont connect now.

This is the error im getting:

Expression.Error: The 'IXapi-Version' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer

What am I doing wrong?

Thank you.

Regards, Luis

[ImkeF]

Hi @Anonymous 

basic authentication isn't natively supported for Web.Contents. But there seems to be a workaround (see here: https://social.technet.microsoft.com/Forums/office/en-US/11d4347c-0332-4dea-b270-a2dcd911c8b0/passing-username-and-password-in-basic-authentication?forum=powerquery) although I've never tried it.