DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 2

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version 3

changes.mady.by.user Anil Bhimineni

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Description: This happens when you try to integrate from Salesforce to Database, Lets say there is no external id of salesforce to Salesforce to map with primary key of a table in db then you will not the cannot update status back to Salesforce.

Resolution 1 : Create a rule in a process Rule which would sync process data from Salesforce to Database along with Salesforce Id.In the next step add , Then Add one more rule Rule and use update operation to bring back the Salesforce Id from database to Salesforce, By this way we can successful successfully update the status back to Salesforce.

Issue 2 : WCan we map the external ID of Salesforce with the primary key of a database table to update back the status of Salesforce. 

Description : Lets say we have an external ID in field of order object of Salesforce(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 which 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 a DBSync user would like to map with the SeqNo ( primary key and auto generated) field of a database table. So, whenever a new order in inserted into database DBSync gets SeqNo to update back to Salesforce on success map that in turn will not be visible in Salesforce.

Image Added


Resolution :  Since SeqNo field is an auto number in table of database so we advise not to advise to map with external id of Salesforce as it does not hold the value we provide externally.  we You should only map the externalID (Order_external_ID__c) to some other field in database , and then after sync we you can get this value and the field value that can be used to update back to Salesforce.

...