JDBC Driver for Xero WorkflowMax

Build 22.0.8462

Invoices

Return a list of invoices

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:

  • CreatedDate supports the '<=,<,=,>,>=' operators.

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 Invoices WHERE CreatedDate >= '2019-08-07' AND CreatedDate <= '2019-08-07'
SELECT * FROM Invoices WHERE CreatedDate >= '2019-08-07'
SELECT * FROM Invoices WHERE CreatedDate = '2019-08-07'

Notes:
-When executing a simple SELECT * query the driver will retrieve only your current Invoices.
-When specifying CreatedFrom and CreatedTo the driver will retrieve the current and archived Invoices.

Columns

Name Type Description
ID [KEY] String The name of the category
Type String Determines the type of the invoice.
Status String Status of the invoice Approved, Paid, Draft, Cancelled
JobID String Id of the job associated with this Invoice.
CreatedDate Date Determines the date when the invoice was created.
DueDate Date Determines the due date for the invoice.
Amount Float The amount to pay.
AmountTax Float The tax amount to pay.
AmountIncludingTax Float The total amount to pay including tax.
AmountPaid Float Determine the amount which has already been paid.
AmountOutstanding Float Determines the amount thats left to pay.
ClientUUID String Client identifier related to the invoice.
ClientName String Client name related to teh invoice.
ContactUUID String Contact identifier of the client related to the invoice.
ContactName String Contact name of the client related to the invoice.

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