Get data from Web API request with headers using Dataflow

(0) Share

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 (3)

Answers (0)

michaelshparber 111 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

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