JDBC Driver for Xero WorkflowMax

Build 22.0.8462

Quotes

Return a list of all quotes

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:

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

All filterable columns except CreatedDate 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 Quotes WHERE ID='Q000001'
SELECT * FROM Quotes WHERE CreatedDate>='2000-12-12' AND CreatedDate<='2020-12-12'
SELECT * FROM Quotes WHERE CreatedDate='2000-12-12'
SELECT * FROM Quotes WHERE CreatedDate>='2000-12-12'
SELECT * FROM Quotes WHERE ID IN ('Q000001', 'Q000002')

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

Columns

Name Type Description
ID [KEY] String The quote identifier.
Type String The type of the quote.
State String The state of the quote.
CreatedDate Datetime The date when the quote was created.
ValidDate Datetime The date till the quote is valid.
Budget String The budget for the quote.
OptionExplanation String A description to explain the options related to the quote.
EstimatedCost Float Estimated cost amount.
EstimatedCostTax Float Estimated tax cost amount.
EstimatedCostIncludingTax Float Estimated total amount including tax.
AmountTax Float Amount to pay.
AmountIncludingTax Float Tax amount to pay.
Amount Float Total amount to pay including tax.
ClientUUID String The Client identifier which is related to the quote.
ClientName String The Client name which is related to the quote.
ContactUUID String The contact ID of the client which is related to the quote.
ContactName String The contact name of the client which is related to the quote.

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