web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get data from Web API ...

Power Apps

Unanswered

Get data from Web API request with headers using Dataflow

(0) Share

Report

Report

Posted on by michaelshparber

111

I need to extract data from API call that requires Authorization="Bearer token" header.

I am able to do this without a problem in Power Query, but how do I do it with Dataflow?

I tried using Web API connection, but cannot find a way to add Headers...

Please help

Thank you

Michael

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

michaelshparber 111 on at

Like (0)

Report
OK here is an update:
I've just copy-pasted from Power Query (see below) and it is working in the Edit mode (!)...

But when trying to refresh - I see an error in connection:

This is an Anonymous connection because I provide Bearer Token...

I wish the UI would allow this, but maybe I am missing smth...
This code IS working inside Edit:

let Source = Json.Document(Web.Contents("https://api.XXX.com/", [RelativePath="v1/mycall", Headers=[#"Authorization"="Bearer XXXtokenXXX"]])) in Source

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @michaelshparber, Just checking, have you selected "Authentication kind" as Anonymous when creating the API connection? If not, I would try to create a brand new Web API connection with "Authentication kind" as Anonymous. And if that doesn't work try the "Blank query" data source type. Cheers

Was this reply helpful? Yes No
michaelshparber 111 on at

Like (0)

Report

Yes, I've selected "Anonymous".
And I have created the Dataflow with copy-paste from Power Query to a Dataflow Blank Query, because there was no place to add Headers in Dataflow.
Actually the refresh is succeeding somehow, but the connection still shows error...
I think this is some kind of a bug...
Nevermind, I discovered that Dataflow cannot upsert to SQL , so I need to find something else....
Thank you.

Was this reply helpful? Yes No

Join the conversation