JDBC Driver for QuickBooks Time

Build 24.0.9062

LastModifiedTimestamps

Retrieves a list of last_modified timestamps associated with each requested API endpoint.

Table Specific Information

Select

Query a list of last modified timestamps associated with each requested API endpoint.

For example, the following queries are processed server side:

SELECT * FROM LastModifiedTimestamps WHERE endpoints = 'timesheets,current_user,groups'

Columns

Name Type Description
CurrentUser Datetime Date/time when this current user was last modified.
CustomFields Datetime Date/time when this custom fields was last modified.
CustomFielditems Datetime Date/time when this custom field items was last modified.
CustomFieldItemFilters Datetime Date/time when this custom field item filters was last modified.
CustomFieldItemUserFilters Datetime Date/time when this custom field item user filters was last modified.
CustomFieldItemJobCodeFilters Datetime Date/time when this custom field item jobcode filters was last modified.
ContactInfo Datetime Date/time when this contact info was last modified.
EffectiveSettings Datetime Date/time when this effective settings was last modified.
GeoLocations Datetime Date/time when this geo locations was last modified.
GeofenceConfigs Datetime Date/time when this geofence configs was last modified.
GeofenceActiveHours Datetime Date/time when this geofence active hours was last modified.
Groups Datetime Date/time when this groups was last modified.
JobCodes Datetime Date/time when this job codes was last modified.
JobCodeAssignments Datetime Date/time when this job code assignments was last modified.
Locations Datetime Date/time when this locations deleted was last modified.
LocationsMap Datetime Date/time when this locations map was last modified.
Reminders Datetime Date/time when this reminders was last modified.
ScheduleCalendars Datetime Date/time when this schedule calendars was last modified.
ScheduleEvents Datetime Date/time when this schedule events was last modified.
TimeSheets Datetime Date/time when this timesheets was last modified.
TimeSheetsDeleted Datetime Date/time when this timesheets deleted was last modified.
TimeOffRequests Datetime Date/time when this time off requests was last modified.
TimeOffRequestEntries Datetime Date/time when this time off request entries was last modified.
Terms Datetime Date/time when this terms was last modified.
Users Datetime Date/time when this users was last modified.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Endpoints String Comma separated list of one or more endpoints.

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