Answered

Trying to get data from REST API and Bearer Authentication

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I need to download data from an external API (I need to authenticate) and save to Sharepoint every month. I'm new to Power Flow and struggling to setup the data connection.

I can setup the API get in Postman and working, but I can't setup get the HTTP connection to authenticate when I execute the flow.

Postman example:

2020-04-09 20_19_43-Postman.png

Here is the Flow HTTP connector setup:

2020-04-09 20_31_05-Edit your flow _ Power Automate.png

The result from the flow:

2020-04-09 20_30_06-Run History _ Power Automate.png

I see in the HTTP setup there is the Advanced Options for authentication - but not the option for Bearer Tokens.

Can someone help and tell me what I'm doing wrong with the config.

Many thanks.

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Now that you can use this request in postman to get the message, it means that the token you got is valid.

I checked your configuration and it seems to be correct.

Please try to directly copy the key and value in Headers to HTTP action and see if a similar problem still exists.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I'm still getting the same error. I even tried to enter the value in text mode and it doesn't work. I even copied the token back into Postman and it worked ok. Not sure where to go with this. I may have to use a different technology.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Can you check and confirm that the Authentication type is selected as none in the Flow HTTP action under the Advanced settings?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I had tried a number of variations of adding Authorization at the bottom, but none worked.
The current version has 'none'.

You can see from the test run what results I'm getting. Still hitting authorization issues:

And, just to make sure... I can run the test in Postman with the same creds and works...

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

As I was typing up my response, I went through it character by character - it had to be something stupid I had done. And it was. I incorrectly added a : to Authorization in the header, so Authorization:

Once I removed that it is now working.

Thank you for reaching out and helping me through it - Typing up the response helped me resolve it.

Was this reply helpful? Yes No