SSIS Components for TSheets

Build 23.0.8839


Retrieves a list of all geofence configs.

Table Specific Information


Query the GeoLocations table. The 本製品 will use the TSheets 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, UserId and GroupId fields support the '=' and IN operators.
  • LastModified field supports the <=,<,>=,>,= operators.

For example, the following query is processed server side:

SELECT * FROM GeoLocations WHERE GroupId IN ('29474', '29474') AND LastModified <= '2020-01-01 00:00'


Insert can be executed by specifying the Created, UserId, Accuracy, Altitude, Latitude and Longitude columns. The columns that are not required can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Geolocations (Created, UserId, Accuracy, Altitude, Latitude, Longitude) VALUES ('2018-08-19T11:30:09-06:00', '1242515', '20.375', '0', '43.68662580', '-116.35166460')


Name Type ReadOnly Description
Id [KEY] Int True

Id of geolocation.

UserId Int False

User id for the user that this geolocation belongs to.

Accuracy Double False

Indicates the radius of accuracy around the geolocation in meters.

Altitude Double False

Indicates the altitude of the geolocation in meters.

Latitude Double False

Indicates the latitude of the geolocation in degrees.

Longitude Double False

Indicates the longitude of the geolocation in degrees.

Speed Double False

Indicates the speed of travel (meters per second) when the geolocation was recorded.

Source String False

Indicates how the GPS point was obtained. One of 'gps', 'wifi', or 'cell'.

DeviceIdentifier String False

Unique identifier (for the given client) for the device associated with this geolocation.

Created Datetime True

Date/time when this geolocation was created


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

Name Type Description
LastModified Datetime

Date/time when this geofence config was last modified.

GroupId String

A comma-separated list of group ids. Only geolocations linked to users from these groups will be returned.

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