...
Status writer is used to insert or update the table after an integration of a record. Status writer are to be enabled for each sequence under Rules section. The status message depends upon the success or error criteria as mentioned in the mapping
Following are the steps to add status writer
- 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
- Validate Row = "true"
- customer_id = VALUE("customer_id")
- qb_id = VALUE("newid")
- qb_status = "Synced"
- Save and Close the page
- Click "On Error" and following are the mapping for error criteria
- Validate Row = "true"
- customer_id = VALUE("customer_id")
- qb_status = "Not Synced"
- Save and Close the page
...