We are working on an automation wherein we are using Salesforce Connector to query and update the records in Salesforce.
Below are the steps we have implemented. Please let us know if its implemented as per best practices or it needs any modifications as per best practices or standards.
We have made 2 solutions
Within Salesforce Application Scope added a For loop to process records and at the end we have made connection.disconnect still we are seeing intermittently connection invalid issue after which we need to open the solution in studio on the VM and manually do the test connection for Salesforce application scope and save the solution without publishing and then run the process from Orchestrator it will work as expected for certain time period again it will run into same issue and need to follow the same step to manually test the connection.
For loop is outside and within the For loop added the Sales force application scope and after each record of for loop added to disconnect the connection but still it gives the same issue of session expired or connection invalid after sometime and need to test the connection manually and save the solution and again it will run for certain time.
Is there any configuration needs to be done at Salesforce end so the connection last for longer time period or are there any limitation for the no of API call can be make from UiPath to Salesforce.
As a best practice which solution is preferred from the above mention solutions (1 or 2). Also how to dispose the connection so next time when process is run or for next record it can reset the connection and do the required steps As-Is without manually Test the connection at regular interval.