JDBC Driver for Xero WorkflowMax

Build 22.0.8462

Tables

The driver models the data in Xero WorkflowMax into a list of tables that can be queried using standard SQL statements.

Generally, querying Xero WorkflowMax tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

CData JDBC Driver for Xero WorkflowMax Tables

Name Description
ClientContacts Return a list of all contacts of clients.
ClientGroups Return a list of all client groups
Clients Return a list of all clients.
Costs Return a list of all costs
JobCosts Return a list of all costs of jobs.
JobNotes Return a list of all notes of a job
Jobs Return a list of all jobs.
JobTasks Return a list of all tasks of jobs.
Leads Return a list of all leads.
PurchaseOrderDrafts Return a list of all draft purchase orders
PurchaseOrders Return a list of all purchase orders
StaffList Return a list of all staff members
SupplierContacts Return a list of all suppliers.
Suppliers Return a list of all suppliers.
Times Return a list of all time sheets.

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