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. The server 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 server.
- Endpoint field support the '=' and IN operators.
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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Endpoints | String | Comma separated list of one or more endpoints. |