Enterprise Service Bus Data Handler - QuickBooks Edit

The QuickBooks Edit data handler allows the builder to create an application that edits existing record in QuickBooks Online.

This feature will be available in Platform Version 10.14.1001

For the QuickBooks Edit data handler to work properly there needs to be several elements added to the application. A table will need to be created by the builder that the ESB will read from. The QuickBooks Edit Data Handler will read a variable amount of data depending on the type of QuickBooks Record. The ID and Sync Token are used to identify and sync a record with QuickBooks and is required for this data handler to work.

For an End User to connect to QuickBooks and use this ESB they will need to login to QuickBooks Online.

There is five configuration options in this data handler.

• OAuth Consumer Key - Intuit provides this key as a way to identify an application when requesting data from QuickBooks.
• OAuth Consumer Secret - Intuit provides this key as a way to secure the identity of the application. This value should not be public knowledge and protected like a password.
• OAuth Field - This query points to the record and Intuit OAuth field that is being used to identify which QuickBooks Online Account the ESB is communicating with.
• When WorkXpress and QuickBooks Data Conflicts which data should be used? - Because data can be entered into QuickBooks Manually it is possible for the version of the record in QuickBooks to be newer then the version stored in a WorkXpress application. If the ESB is configured to us QuickBooks data then the data from QuickBooks will be written to the WorkXpress record and the update will be aborted. If the WorkXpress data is used then the update will proceed and any edits that were done in QuickBooks will be lost.
• QuickBooks Table - This is the table that the ESB will add records to.

This Data Handler is triggered via an Enterprise Service Bus Action. To see which actions will trigger this Data Handler use the “Outgoing” tab on the Enterprise Service Bus page.

The field mapping interface will allow the builder to choose a field on the table selected in the options above or to use a query to find a field on related records to the record created by the data handler. The number of field mappings will change depending on what QuickBooks Table is selected above