Profiles

Controls what you can see and do within Outreach.

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.
SpecialId supports the '=,IN' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
Name supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Profiles WHERE Id = 1

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

SELECT * FROM Profiles WHERE Id >= 1

SELECT * FROM Profiles WHERE Id <= 1

SELECT * FROM Profiles WHERE Id > 1

SELECT * FROM Profiles WHERE Id < 2

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

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

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

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

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

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

SELECT * FROM Profiles WHERE Name = 'Admin'

SELECT * FROM Profiles WHERE Name IN ('Admin', 'Default')

SELECT * FROM Profiles WHERE SpecialId IN ('Admin', 'Default')

Columns


Name	Type	Description
Id [KEY]	Integer	Id of profile.
CreatedAt	Datetime	The date and time the team was created.
IsAdmin	Boolean	Flag that indicates whether the profile provides admin access.
Name	String	The name of the profile.
SpecialId	String	The special Id flag assigned to the profile.
UpdatedAt	Datetime	The date and time the team was last updated.
LinksSelf	String	Links self.
Type	String	type.

SSIS Components for Outreach

Profiles

Select

Columns