Excel Add-In for QuickBooks Time

Build 24.0.9062

ScheduleCalendars

Retrieves a list of schedule calendars associated with your employees or company.

Table Specific Information

Select

Query the ScheduleCalendars table. The add-in will use the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.

  • Id field supports the '=' and IN operators.
  • LastModified field supports the <=,<,>=,>,= operators.

For example, the following queries are processed server side:

SELECT * FROM ScheduleCalendars WHERE Id IN (72595, 72597)

SELECT * FROM ScheduleCalendars WHERE LastModified < '2019-01-01 18:30'

Columns

Name Type Description
Id [KEY] Integer Id of the schedule calendar.
Name String The name of the schedule calendar.
Created Datetime Date/time when this schedule calendar was created
LastModified Datetime Date/time when this schedule calendar was last modified.

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