Pull data from REST API with oAuth-Token in the Header requried

[fabianhenzler]

I need to pull data from a SugarCRM v10 REST API and they require a "OAuth-Token" in Header. How can I do this? Is there a M Script necessary? Any introduction or tutorial someone has to offer? 

[fabianhenzler · Accepted solution]

So in case of the SugarCRM REST API you can pass the OAuth-Token as URL parameter

bbhttps://company.sugaropencloud.eu/rest/v10/Accounts?OAuth-Token=4efff6d1-41b7-caa2-00c7-5751000905fb&offset=0

[cactus]

Hi @fabianhenzler, can you share how did you set up the token? I couldn't manage the connection to work..

[cactus]

Hi @fabianhenzler, did you manage to connect SugarCRM and PowerBI? Can you share how did you set up the token?

[Anonymous]

Any idea on how to refresh the token from within PowerBI? It expires after some time....