web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Get data from Web API ...
Power Apps
Unanswered

Get data from Web API request with headers using Dataflow

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • michaelshparber Profile Picture
    111 on at

    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:

     
    Screenshot 2020-09-27 155743.png

     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

     

     

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    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

  • michaelshparber Profile Picture
    111 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard