DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 2

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version Current

changes.mady.by.user Munira Majumdar

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 from database External ID of Salesforce from a Database table.

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

Resolution 1 : Create a rule in a process which would sync Rule that will process data from Salesforce to Database along with Salesforce Id.In the next step add ID. Then, add one more rule Rule and use update Update operation to bring back the Salesforce Id from database to Salesforce, this way we can successful ID from the Database. By so doing, we can 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 External ID in order object of field on Order object in 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 as it does . A DBSync user would like to map it with SeqNo (auto generated primary key) field of a Database table. So, whenever a new order is inserted into a 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 Database, we advise that you do not map it with External ID of Salesforce. This is because, an auto generated ID can not hold the value we provide externally.  we You should only map the externalID ExternalID (Order_external_ID__c) to some other field in database, and then a Database. Then, after sync we , you can get this value and the field value that can be used to update back to Salesforce.

...