BizTalk Adapter for TSheets

Build 20.0.7654


This table contains a list of all groups associated with your company.

Table Specific Information


Query the Groups 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 and Name fields support the '=' and IN operators.
  • Active field supports the '=' operator.
  • LastModified field supports the <=,<,>=,>,= operators.

For example, the following queries are processed server side:

SELECT * FROM Groups WHERE Name IN ('Group 1', 'Group 2') and LastModified > '2019-01-01 15:30'

SELECT * FROM Groups WHERE Active = true


Name Type Description
Id [KEY] String ID of this group.
Active Boolean If false, this group is considered archived.
Name String Name associated with this group
LastModified Datetime Date/time when this group was last modified
Created Datetime Date/time when this group was created
ManagerIds Int List of id's for the users allowed to manage this group.

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