Get details of the individual that uses the application.

Select

The connector 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 connector.

• UsersId supports the '=,IN,>=,<=,>,<' operators.
• CurrentSignInAt supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Email supports the '=,IN' operators.
• FirstName supports the '=,IN' operators.
• LastName supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• UserName supports the '=,IN' operators.
• Locked supports the '=' operators.

For example, the following query is processed server side:

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

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

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

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

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

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

SELECT * FROM UsersDuties WHERE CurrentSignInAt = '2022-02-25 01:02:02.0'

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

SELECT * FROM UsersDuties WHERE Email = '[email protected]'

SELECT * FROM UsersDuties WHERE FirstName = 'test'

SELECT * FROM UsersDuties WHERE LasttName = 'test'

Columns

Name	Type	Description
Id [KEY]	Integer	Id.
Name	String	Duty name.
DutyType	String	Duty type.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
UsersId	Integer	Id of Users.
CreatedAt	Datetime	The date and time the user was created.
CurrentSignInAt	Datetime	The date and time the user most recently signed in.
Email	String	The email address of the user.
FirstName	String	The first name of the user.
LastName	String	The last name of the user.
Locked	Boolean	A boolean value indicating whether or not the user is locked out of the application.
UpdatedAt	Datetime	The globally unique ID GUID assigned to the user.
Username	String	A reader friendly unique identifier of the user.