Quotes
Return a list of all quotes
Select
The adapter 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 adapter will retrieve only your current Quotes.
-When specifying CreatedDate the adapter 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. |