SSIS Components for TSheets

Build 23.0.8839


Retrieves a list of notifications associated with your company.

Table Specific Information


Query the Notifications 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 field supports the '=' and IN operators.
  • MessageTrackingId and UserId fields support the '=' operator.
  • DeliveryTime field supports the <=,<,>=,>,= operators.

For example, the following queries are processed server side:

SELECT * FROM Notifications WHERE Id IN (94140223, 94140225) AND UserId = 37

SELECT * FROM Notifications WHERE MessageTrackingId = 'baabeb0ab03d62ce'

SELECT * FROM Notifications WHERE DeliveryTime = '2019-12-25 19:00'


Insert can be executed by specifying the Message column. The columns that are not required can be inserted optionally. Following is an example of how to insert into this table

INSERT INTO Notifications (Message) VALUES ('Please clock Out!')

INSERT INTO Notifications (Message, UserId) VALUES ('Please clock Out!', '56329')


Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Notifications WHERE Id = '41321421'

DELETE FROM Notifications WHERE Id IN ('41321421', '4132567')


Name Type ReadOnly Description
Id [KEY] Integer True

Id of the notification.

UserId Integer True

User id for the user that this notification will be sent to.

MessageTrackingId String True

A GUID string used for additional tracking.

Message String False

The message text of the notification. The maximum message length is 2000 characters.

Method String False

The transport method of the notification. We support 'push', 'email', and 'dashboard'.

Precheck String False

The precheck macro name. Supported macros are 'on_the_clock', 'off_the_clock', and 'none'.

Created Datetime True

Date/time when this notification was created

DeliveryTime Datetime False

Date/time when this notification will be delivered.

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