SSIS Components for Xero WorkflowMax

Build 21.0.8137

ClientDocuments

Return a list of all documents of the clients.

Select

The {i will use the your data source 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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137