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. |