Export BC data through webservices + Power Automate OAuth

(0) Share

Report

Posted on by AntonisK

260

Dear all.

I am having big trouble trying to deal with OAuth authentication for http connector in Power Automate.

I am using the HTTP call to get some master data from Business Central and post them to a csv file.

I have managed to call the api through postman , following the guide that yzhums proposes ( https://yzhums.com/20690/ ) , but i haven't managed to call the api through Power Automate.

Can someone explain to me what do i need to insert on each and every one of the fields below?

Has anyone managed to use Power Automate to retrieve BC Data, by using OAuth instead of Basic Authentication?

Thank you in advance lads.

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

look my blog

danieleincalza.blogspot.com/.../oauth20-calling-custom-ws-business.html

check my answer if it helped you, thanks

DANiele

Was this reply helpful? Yes No
AntonisK 260 on at

Like (0)

Report

Since i need a Get request to retrieve data within BC , what must my first http call be?

As far as i remember, i cant use body scope in a get request.

https://prnt.sc/nOrtA4NwGe9j

Was this reply helpful? Yes No
Verified answer

DAnny3211 11,397 on at

Like (2)

Report

hi

make an initial call to retrieve the beare token

METHOD: POST

URI: login.microsoftonline.com/.../token

HEADERS: Content Type - > x-www-form-urlencoded

BODY : grant_type=client_Credential&client_id={myAppID}&client_Secret={MyCLientSecret}&scope=https://api.businesscentral.dynamics.com/.default

then makes the second call for WS BC

in my example I do a post, if you need to retrieve data from BC you do a GET

check my answer if it helped you, thanks

DANiele

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

you can check below link

www.navwithnav.com/.../

Was this reply helpful? Yes No
AntonisK 260 on at

Like (0)

Report

Verifying your answer.

Thank you , you saved my day!

Was this reply helpful? Yes No