JDBC Driver for Xero WorkflowMax

Build 22.0.8462

JobCosts

Return a list of all costs of jobs.

Select

Note: Because of Xero WorkflowMax API restrictions the Job ID filters will not work properly while using custom Job numbers which have punctuation in them. This is a known issue that Xero refuses to fix. Please change the Job number so there is no punctuation and try again. In case you are using custom Job numbers with punctuation in them you may encounter 404 Not Found error in Jobs and JobCosts tables.

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 JobCosts WHERE JobID='J000002'
SELECT * FROM JobCosts WHERE JobID IN ('J000001', 'J000002')

Insert

JobID, Date, Description, Quantity, UnitCost, UnitPrice are required to insert. The following query creates a new JobCost:

INSERT INTO JobCosts (JobID, Date, Description, Quantity, UnitCost, UnitPrice) VALUES ('J000002', '2019-07-17T00:00:00', 'Maybach', '123', 30, 50)

Columns

Name Type ReadOnly Description
JobID String False

Job Identifier related to the cost.

UUID [KEY] String True

Cost identifier.

Date Datetime False

The date when the cost was created.

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.

Quantity Double False

Product quantity.

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.

Billable String True

Determines if the cost is billable or not true(default) | false.

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