MuleSoft Connector for TSheets

Build 20.0.7654

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

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654