Roles

Gets details of where a user falls within the organization's structure.

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.


Column	Supported Operators
Id	=, IN, >=, <=, >, <
CreatedAt	=, >=, <=, >, <
Name	=, IN
UpdatedAt	=, >=, <=, >, <

For example, the following queries are processed server-side:

SELECT * FROM Roles WHERE Id = 1

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

SELECT * FROM Roles WHERE Id >= 1

SELECT * FROM Roles WHERE Id <= 1

SELECT * FROM Roles WHERE Id > 1

SELECT * FROM Roles WHERE Id < 2

SELECT * FROM Roles WHERE Name = 'test'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of roles.
CreatedAt	Datetime	The date and time the role was created.
Name	String	The name of the role.
UpdatedAt	Datetime	The date and time the role was last updated.
LinksSelf	String	Link self.
ParentRoleLinks	String	Parent role links.
Type	String	The type of the role.

SSIS Components for Outreach

Roles

Select

Columns