Web API Connector

(0) Share

Report

Posted on by Samuel Boulanger

572

Hi,

I'm trying to use the Web API connector to import contact data from a marketing system. I was able to connect using Power BI but when it comes to CI it seems there are missing authentication options. The only options I currently see are "Anonymous" and "Organizational account", while I need to use either an API Key or basic authentication.

Am I missing something?

I currently use a trial environment, could it be related?

Regards

I have the same question (0)

All responses (4)

Answers (1)

Nya 29,060 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Would you please attach some screenshots to describe your problem more clearly?

Best Regards,

Nya

Was this reply helpful? Yes No
Verified answer

John Wiese Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, the Web API connector is slightly different in CI from the one in PowerBI. What you may be able to do is make the connection in PowerBI, then copy the query and use the Blank Connector in CI and simply paste in the query from the PowerBI connector.

Was this reply helpful? Yes No
Samuel Boulanger 572 on at

Like (0)

Report
Copy link

Link copied!

Hi John,

Thank you for your answer. Unfortunately, I'm still stuck with the same limitation regarding the authentication:

Was this reply helpful? Yes No
Suggested answer

Samuel Boulanger 572 on at

Like (1)

Report
Copy link

Link copied!

Never mind, I first tried with basic authentication and that's why it didn't work. By using your method and adding the api token in Power BI and then copy the query in the Blank connector it did works.

Thanks for the help.

Was this reply helpful? Yes No