Teams

Get details of a group of users.

Select

The component will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the component.

Id supports the '=,IN,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
Name supports the '=,IN' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM Teams WHERE Id = 1

SELECT * FROM Teams WHERE Id IN (1, 2)

SELECT * FROM Teams WHERE Id >= 1

SELECT * FROM Teams WHERE Id <= 1

SELECT * FROM Teams WHERE Id > 1

SELECT * FROM Teams WHERE Id < 2

SELECT * FROM Teams WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE Name = 'test'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of team.
Color	String	The color used to label and highlight the team.
CreatedAt	Datetime	The date and time the task was created.
Name	String	The name of the team.
ScimExternalId	String	The ID from the SCIM provisioning service used to create the team.
ScimSource	String	The name of the SCIM provisioning source used to create the team.
UpdatedAt	Datetime	The date and time the team was last updated.
LinksSelf	String	Link self.
ContentCategoriesId	Integer	The content categories that are assigned to the team.
ContentCategoriesLinks	String	The content categories links Id.
CreatorId	Integer	The creator Id.
CreatorType	String	Creator type.
UpdaterId	Integer	The most recent updater Id.
UpdaterType	String	The most recent updater type.
UsersId	Integer	User data.
UsersLinks	String	User links.
Type	String	Type.

SSIS Components for Outreach

Teams

Select

Columns