Tableau Connector for QuickBooks Online

Build 23.0.8839


Create, update, delete, and query QuickBooks Departments.

Table Specific Information


All filterable columns support the following operators:

  • =
  • !=
  • >=
  • <=
  • >
  • <
  • IN
  • LIKE

The driver processes other filters client-side within the driver.


Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True True True

The Id of the department.

SyncToken String True False False

Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.

MetaData_CreateTime Datetime True True True

The time the record was created.

MetaData_LastUpdatedTime Datetime True True True

The time the record was last updated.

Name String False True True

The name of the department.

SubDepartment Boolean True False False

This field specifies whether the department is a subdepartment.

ParentRef String False


False False

The Id of the parent class entity.

ParentRef_Name String True


False False

The name of the parent class entity.

FullyQualifiedName String True False False

The fully qualified name of the department. The fully qualified name consists the topmost parent element followed by each subelement and separated by colons. For example: Parent:Account1:SubAccount1:SubAccount2.

Active Boolean False False False

This field indicates whether or not the department is active. Inactive records are hidden from most display purposes and financial transactions.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839