JDBC Driver for Xero WorkflowMax

Build 22.0.8462

Costs

Return a list of all costs

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:

  • UUID 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 Costs WHERE UUID = '9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'
SELECT * FROM Costs WHERE UUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26av43')

Insert

Description, UnitPrice, UnitCost are required to insert. The following query creates a new Cost:

INSERT INTO Costs (Description, UnitPrice, UnitCost) VALUES ('decr', 100, 200)

Update

You can update a Cost by specifying the Cost UUID:

UPDATE Costs SET UnitPrice='101' WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'

Delete

Delete a Cost by specifying the Cost UUID:

DELETE FROM Costs WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'

Columns

Name Type ReadOnly Description
UUID [KEY] String True

The Id of the Cost.

Description String False

The description related to the cost.

Code String False

The code of the unit.

Note String False

The note related to the cost.

UnitCost Float False

Cost per unit.

UnitPrice Float False

Price per unit.

SupplierUUID String False

Determines the supplier identifier.

SupplierName String True

Determines the supplier name.

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