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.
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. |