Overview

This section shows the available API objects and provides more information on executing SQL to Xero WorkflowMax APIs.

Key Features

• The driver models Xero WorkflowMax entities like Clients, Suppliers, and Jobs as relational views, allowing you to write SQL to query Xero WorkflowMax data.
• Stored procedures allow you to execute operations to Xero WorkflowMax.
• Live connectivity to these objects means any changes to your Xero WorkflowMax account are immediately reflected when using the driver.

Custom Fields

The XeroWOrkflowMax driver supports custom fields. To be able to retrieve and update custom fields IncludeCustomFields must be set as a connection property. Remember that the driver will be slow when getting custom fields as it fetches them one by one. To improve performance try to specify the ID of the resource you are trying to query.