Tableau Connector for Xero WorkflowMax

Build 21.0.8137

StaffList

Return a list of all staff members

Select

The connector will use the your data source 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 StaffList WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'
SELECT * FROM StaffList WHERE UUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26a9f6')

Insert

Name is required to insert. The following query creates a new StaffList member:

INSERT INTO StaffList (Name) VALUES ('J000002')

Update

You can update a Staff member by specifying the Staff member UUID:

UPDATE StaffList SET Email='hey@gmail.com', Phone='23489235' WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'

Delete

Delete a Staff member by specifying the Staff member UUID:

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

Columns

Name Type ReadOnly Description
UUID [KEY] String True

The staff member identifier.

Name String False

The staff member name.

Email String False

The staff member email.

Phone String False

The staff member phone number.

Mobile String False

The staff member mobile number.

Address String False

The staff member address.

PayrollCode String False

Payroll code for the staff member.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137