JDBC Driver for Xero WorkflowMax

Build 22.0.8462

Tasks

Return a list of all tasks

Select

The driver will use the Xero WorkflowMax API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver. Specifically, the following are processed server-side:

  • UUID supports the '=' operator.

All filterable columns allow multiple values to be specified by using the IN operator. Response time from the server can be improved by identifying only the rows you want to retrieve.

SELECT * FROM Tasks WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'
SELECT * FROM Tasks WHERE UUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26a6g9')

Columns

Name Type Description
UUID [KEY] String Task identifier.
Name String The task name
Description String The task description.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462