Update primary key from Database to Salesforce

Issue 1 : How to update Salesforce using status writer when there are no fields to map with the external Id from database table.

Description: Getting an “Application request abort” error message on QuickBooks web connector whenever you try to hit update select button from web connector.This usually happens whenever you enter an incorrect file path in the QuickBooks desktop connector in your project. This might also happen when you try to sync using web connector which is not configured with the opened file. 

Resolution 1: If there is no external Id field then we can just sync data from Salesforce to Database along with Salesforce Id, which is a normal process.

In the next step add one more workflow and use update operation to just bring back the Salesforce Id from database to Salesforce, this way we can successfully map the status.

Issue 2 : What if we have an external ID in order object (Order_external_ID__c) which should be the SeqNo that is being created in Database. So, when we create new order in Database, we get SeqNo which I need to update back Salesforce on success map. But that is not visible on success map.

Description : This issue occurs when an user try to hit the update select from the web-connector. The cause of this issue when an web connector is configured by an non - admin user of the QuickBooks but later the user is deleted from the QuickBooks. The error is as shown in the below image.

Resolution : SEQNO is a autonumber in Database and it should not be mapped at all as it does not hold the value we provide externally. we should map the externalID (Order_external_ID__c) to some other field in database, and then after sync we can get this value and update back to Salesforce.