...
- In DBSync platform, under Customer Workflow, click the More option within Rule section.
- Enable Update Source
- Select Update Source as Database
- Select Operations as Upsert
- Select Target object as table name (Example: customer_status_dbsync)
- Click "On Success" and following are the mapping for success criteria
- the validate row should contain the condition as "true" so that the mapping for the sequence works
- Map customer id of QuickBooks with customer id field of database
- Map newid of QuickBooks with QuickBooks id field of database
- Write Write QuickBooks status field as "Synced"
- Save and Close the page
- Click "On Error" and following are the mapping for error criteria
- the validate row should contain the condition as "true" so that the mapping for the sequence works
- Map customer id of QuickBooks with customer id field of database
- Write QuickBooks status field as "Not Synced"
- Save and Close the page
- Click "Save Workflow" once the above changes are made
...
{"serverDuration": 74, "requestCorrelationId": "7950d9aa90c45b42"}