JDBC Driver for Xero WorkflowMax

Build 22.0.8462

Times

Return a list of all time sheets.

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:

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.
  • JobID supports the '=' operator.
  • StaffID supports the '=' operator.
  • 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 Times WHERE JobID='J000001'
SELECT * FROM Times WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'
SELECT * FROM Times WHERE CreatedDate>='2018-12-12' AND CreatedDate<='2020-12-12'
SELECT * FROM Times WHERE StaffUUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2' AND CreatedDate>='2018-12-12' AND CreatedDate<='2020-12-12'
SELECT * FROM Times WHERE UUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26g3h2')
SELECT * FROM Times WHERE StaffUUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26g3h2')
SELECT * FROM Times WHERE JobID IN ('J000001', 'J000002')

Insert

JobID, TaskID, StaffID, Date, Minutes are required to insert. The following query creates a new Time entry:

INSERT INTO Times (JobID, TaskUUID, StaffUUID, Date, Minutes) VALUES ('J000001', '9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26a5e8', '2019-06-27T00:00:00', '240')

Update

You can update by specifying the UUID:

UPDATE Times SET Date='2019-06-27T00:00:00', Minutes='240' WHERE UUID='250193564'

Delete

Delete a Time entry by specifying the UUID:

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

Columns

Name Type ReadOnly Description
UUID [KEY] String False

The Id of the timesheet entry.

JobID String False

The Id of the job related to the timesheet entry.

JobName String True

The name of the job related to the timesheet entry.

TaskUUID String False

The Id of the task related to the timesheet entry.

TaskName String True

The name of the task related to the timesheet entry.

StaffUUID String False

The Id of the staff related to the timesheet entry.

StaffName String True

The name of the staff related to the timesheet entry.

CreatedDate Datetime False

The date of the timesheet entry .

Minutes Int False

The minutes of how much the timesheet entry will last.

Note String False

The note related to the timesheet entry.

Billable Boolean False

Boolean indicating if this time is billable or not.

Start Time False

The start time of the timesheet entry.

End Time False

The time when the timesheet entry ended.

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