TDA API Access Request OAuth 2.0 Excel Data Query

[victorF]

Hello,

Anyone knows how to perform the OAuth2.0 Authentication using the Power Query for TD Ameritrade.

I am able to make API call using the Power Query, but i need to manually enter the 30min access token.

Trrying to creat a power Query request to perfom the OAuth2.0. Once received the 30min Access token, use it as a function to perfom API requestes.

[victorF · Accepted solution]

Got the solution from this video:

https://www.youtube.com/watch?v=2RZkc_qrV1g&t=6s&ab_channel=BIElite

[v-yingjl]

Hi @victorF ,

If want to connect from Power BI to a REST API that uses OAuth2 authentication then you need to build a custom connector. You can find documentation on how to implement an OAuth2 flow in a custom connector here.

Refer this blog: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[victorF]

Hey @v-yingjl 

I have been trying to build the custom connector, its quite compluicated as i am not so familar with M code.
I have the cURL for the POST request. Sucessfully tested in Postman.

Postman alows to convert the cURL in many languages but not in to M code.

Are you aware of any tool to convert any code language in to M code?