Salesforce connection fails after success

Question

We have logic apps that use a Salesforce API connector. The logic app runs good for a few times, but fails after a few runs with a 401 error. The logic app runs 2x per day. It seems to fail on the 3rd attempt.

This is the error:
{
"status": 401,
"message": "Salesforce failed to complete task: Message: This session is not valid for use with the REST API\r\nclientRequestId: d22d5dbe-ccfb-487b-8116-843f8e59db9e",
"error": null,
"source": "Salesforce.Common",
"errors": []
}

Run schedule:

Answer 1

Hello @Bishop, Mike S ,

One quick observation - The Logic App is failing after certain period of time for successive request - as per screen shot > 12 hours. I am assuming that you are signing in again in order to rectify the error.

Logic App getting INVALID_SESSION_ID from Salesforce - usually indicates on a token / session expiration that is set in the Salesforce environment. (Or IP Restriction in some cases - but may not be your case as it works for certain amount of time) . There are few configuration that can be set up at the Salesforce end which can expire the access token (as well as the refresh token).

I would recommend you to check for the session restrictions. Attaching image for your reference. Managed to get some screenshots from internet but may actually vary at your environment.

Answer 2

Hi!
I'm facing the same issue after IT set the 2h timeout for the salesforce tool. The configuration is not at user level so it would be really difficult to disable it back only because of few using the PowerAutomate.
Any way to get a workaround to solve this?
Thanks!