JDBC Driver for Xero WorkflowMax

Build 22.0.8462

JobDocuments

Return a list of all documents of a job

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:

  • JobID 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 JobDocuments WHERE JobID='J000001'
SELECT * FROM JobDocuments WHERE JobID IN ('23423', '34534')

Columns

Name Type Description
JobID [KEY] String The ID of the job 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