BizTalk Adapter for TSheets

Build 20.0.7654

Notifications

Retrieves a list of notifications associated with your company.

Table Specific Information

Select

Query the Notifications table. The adapter 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 adapter.

  • 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'

Columns

Name Type Description
Id [KEY] Integer Id of the notification.
UserId Integer User id for the user that this notification will be sent to.
MessageTrackingId String A GUID string used for additional tracking.
Message String The message text of the notification. The maximum message length is 2000 characters.
Method String The transport method of the notification. We support 'push', 'email', and 'dashboard'.
Precheck String The precheck macro name. Supported macros are 'on_the_clock', 'off_the_clock', and 'none'.
Created Datetime Date/time when this notification was created
DeliveryTime Datetime Date/time when this notification will be delivered.

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