Answered

Connecting to Odata Feed With Basic Authentication

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to connect my app to an odata feed I have that requires basic authentication to sign in. Unfortunately, it seems as though the odata connector only supports Microsoft or anonymous authentication. I've never built a custom connector before, but I am open to learning how. Is this the route I should go down? If so does anyone have any tutorials?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please check on below blog to see if it could help:

https://www.cdata.com/kb/tech/odata-odata-powerapps.rst

Regards,

Mona

Was this reply helpful? Yes No
guido 18 on at

Like (0)

Report
Copy link

Link copied!
An alternative might be a query such as (please note that the password is stored in plain text):

let Bron = Web.Contents("https://bridge-online.cloud/invantive-activecampaign/odata4/ActiveCampaign.V3.Accounts@acn", [Headers=[#"Accept"="application/json",#"Authorization"= Text.Combine({"Basic", " ", Binary.ToText(Text.ToBinary("john.doe@acme.com:secret@"), BinaryEncoding.Base64)})]]), Rows = Table.FromList(Json.Document(Bron)[value], Splitter.SplitByNothing(), {"Columns"}, null, ExtraValues.Error), Accounts = Table.ExpandRecordColumn(Rows, "Columns", {"id", "name", "accountUrl", "createdTimestamp", "updatedTimestamp"}) in Accounts

Was this reply helpful? Yes No