SSIS Components for TSheets

Build 23.0.8839


Retrieves a list of all locations associated with your company.

Table Specific Information


Query the Locations 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 and GeoCodingStatus fields support the '=' and IN operators.
  • ActiveStatus filter supports the '=' operator.
  • LastModified field supports the <=,<,>=,>,= operators.

For example, the following queries are processed server side:

SELECT * FROM Locations WHERE GeoCodingStatus IN ('in_progress', 'retry')

SELECT * FROM Locations WHERE ByJobcodeAssignment = true


Insert can be executed by specifying any columns. Following is an example of how to insert into this table

INSERT INTO Locations (Address1, City, State, Country) VALUES ('CData office', 'Bangalore', 'KA', 'IN')

INSERT INTO Locations (Address1, City, State, Country, Zip) VALUES ('CData office', 'Bangalore', 'KA', 'IN', '560100')


Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Locations SET Address1 = 'Microsoft' WHERE Id = '10055' 


Name Type ReadOnly Description
Id [KEY] String True

Id of location.

Address1 String False

The first line of the location's address.

Address2 String False

The second line of the location's address.

City String False

The city of the location's address.

State String False

The state of the location's address.

Zip String False

The postal code of the location's address.

Country String False

The country of the location's address.

FormattedAddress String True

Formatted address built from the objects addr1, addr2, city, state, and zip. If the location doesn't contain addr1, addr2, or city properties, the value will default what is set in the label property.

Active Boolean False

Whether this location is active. If false, this location is archived.

Latitude Double False

The latitude of the location (in signed degrees format).

Longitude Double False

The longitude of the location (in signed degrees format).

PlaceIdHash String False

The MD5 hash of the unique id for the location returned from the geocoding service.

Label String True

The formated name for the location. If the location was found using the geocode service the formated address will be saved in this field, otherwise it will be what the user has named the location.

Notes String False

Notes related to the location.

GeoCodingStatus String False

The geocoding status of this address. Will be one of: 'none', 'in_progress', 'retry', 'error', or 'complete'.

Created Datetime True

Date/time when this location was created

LastModified Datetime True

Date/time when this customfield was last modified.

LinkedObjects String False

A key/value map of all the objects linked to this location and the corresponding object ids.

GeofenceConfigId Int True

Id of the geofence_config associated with this location.


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

Name Type Description
ByJobcodeAssignment Boolean

If specified, only locations mapped to a jobcode the user is assigned to will be returned.

ActiveStatus String

Filter column for whether to fetch only active records, only archived records, or both. By default, only active records are fetched. Possible values are: yes, no, both

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