Power BI Connector 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 本製品 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 本製品.

  • 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