JDBC Driver for Xero WorkflowMax

Build 22.0.8462

ClientDocuments

Return a list of all documents of the clients.

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:

  • ClientUUID supports the '=' operator.
To execute a SELECT query to ClientDocuments you must provide the ClientUUID as a WHERE condition. Specifically, the following are processed server-side:
SELECT * FROM ClientDocuments WHERE ClientUUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'

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 ClientDocuments WHERE ClientUUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '446ddb14-4084-48fc-83bd-76b89125450a')

Columns

Name Type Description
ClientUUID [KEY] String The ID of the client which has the document.
Title String The title of the document.
Text String The note relating to the document.
Folder String The folder where the document is.
Date Datetime The date on which the document was created.
CreatedBy String The name of the staff who created the document.
URL String The URL used to direct download the document.

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