Custom Connector Token Refresh?

[Bjorn]

I've created a cusom connector to Salesforce (the 'Premium' Flow connector doesn't support a couple API features I need). It works fine, but stops working after 4 hours, which is the session timeout setting for our Salesforce org. I need my connector to get a refresh token but I'm not sure how to do it. Has anyone gotten a Flow custom connector access token refresh from Salesforce working?

[manuelstgomes]

Hi @Bjorn 

I just stumbled on your request. You've been waiting a while for a reply.

Were you able to solve it? Can you post the solution so that we can all learn from it?

If you still need help, please let me know what changed.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[Bjorn · Accepted solution]

Hi @manuelstgomes,

I'll post this in case it helps anyone else. I finally gave up with my custom connector and just make direct HTTP requests. I post my client_id, client_secret, username, and password (for Salesforce, that's password+token) to their token endpoint. The return contains an access_token that I store in a variable and use in the header of my subsequent API requests. This avoids the token refresh issue I was having and is more flexible (I can make any number of different API calls via HTTP, whereas if I used a custom connector I would have had to define them each as unique actions).

[manuelstgomes]

Hi @Bjorn 

Thanks for posting the solution. Well done!

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[JacksonOng]

HI, I am trying to do the same thing, but using the http post is just too much work for multiple API calls. Did anyone find a better solution? 

[Aysan]

I am working on kind of the same solution, but I want to connect my powerapp to Netsuite, Not sure how to trigger the flow for each session and start the timer, 

[NagyRobert77]

so i turned my head around for 2 days to find a solution to use PowerAutomate with refreshed access tokens and i figured out a solution, but unfourtunetly without Custom Connector:

So my scenario is that i need to generate a new acces token with the refresh token that i generated at authorization. Each time i want to create a call i use the refresh token to get new access token, then i parse and use it in the next http call in powerautomate.

1. Authorize your API with any browser (chrome, edge...etc) (Read oauth2 Authorization documentation from your app)

2. Generate Access token and Refresh token using API Documentation and using Postman. (Read oauth2 Generate tokens documentation from your app) *this is your first token that expires in x minutes.

3. Create new flow in power automate starting with any trigger you like.

4. Add HTTP Step and select POST and paste in your URI that gives you the new access token. The refresh token generates the new access token. Refresh token you get from step 2 with Postman. (Read oauth2 Refreshing tokens documentation from your app)

5. Parse json response.

6. Add HTTP step and use new Acces Token from step.5

Each time you have a trigger all 3 steps are mandatory to receive fresh access token.

Done, you can call any API always having the refreshed access token.