Users

Gets details of the individual who uses the application.

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, >=, <=, >, <
CurrentSignInAt	=, >=, <=, >, <
CreatedAt	=, >=, <=, >, <
Email	=, IN
FirstName	=, IN
LastName	=, IN
UpdatedAt	=, >=, <=, >, <
UserName	=, IN

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

SELECT * FROM Users WHERE Id = 1

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

SELECT * FROM Users WHERE Id >= 1

SELECT * FROM Users WHERE Id <= 1

SELECT * FROM Users WHERE Id > 1

SELECT * FROM Users WHERE Id < 2

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

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

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

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

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

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

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

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

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

SELECT * FROM Users WHERE FirstName = 'test'

SELECT * FROM Users WHERE LastName = 'test'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of users.
AccountsViewId	String	The default smart view to load on the account index view.
ActivityNotificationsDisabled	Boolean	Indicates whether the user's activity notifications are disabled.
BounceWarningEmailEnabled	Boolean	Indicates whether the user's bounce warning emails are enabled.
BridgePhone	String	The telephone number of the user's outbound bridge phone.
BridgePhoneExtension	String	The extension number of the user's outbound bridge phone.
CallsViewId	String	The default smart view to load on the calls view.
ControlledTabDefault	String	The user's preferred default tab to open when in task flow.
CreatedAt	Datetime	The date and time the user was created.
CurrentSignInAt	Datetime	The date and time the user most recently signed in.
DailyDigestEmailEnabled	Boolean	Indicates whether the user's daily digest emails are enabled.
DefaultRulesetId	Integer	The id of the default ruleset assigned to the user.
Duties	String	A collection of the user's work roles.
DutiesSetAt	Datetime	The date and time the user's duties were set.
Email	String	The email address of the user.
EnableVoiceRecordings	Boolean	Indicates whether the user has voice recordings enabled.
EngagementEmailsEnabled	Boolean	Indicates whether the user has engagement emails enabled.
FirstName	String	The first name of the user.
InboundBridgePhone	String	The telephone number of the user's inbound bridge phone.
InboundBridgePhoneExtension	String	The extension number of the user's inbound bridge phone.
InboundCallBehavior	String	The behavior of inbound calls.
InboundPhoneType	String	The user's type of telephone for inbound calls.
InboundVoicemailCustomMessageText	String	The message for inbound voicemails.
InboundVoicemailMessageTextVoice	String	The gender of the voice that reads the voicemail message.
InboundVoicemailPromptType	String	The type of inbound voicemail to use.
KaiaRecordingsViewId	String	The default smart view to load on the kaia recordings view.
KeepBridgePhoneConnected	Boolean	Indicates whether to keep the user's bridge phone connected between outbound calls.
LastName	String	The last name of the user.
LastSignInAt	Datetime	The date and time the user previously signed in.
Locked	Boolean	Indicates whether the user is locked out of the application.
MailboxErrorEmailEnabled	Boolean	Indicates whether the user's mailbox error emails are enabled.
MeetingEngagementNotificationEnabled	Boolean	Indicates whether the user's meeting engagement notifications are enabled.
Name	String	The full name of the user.
NotificationsEnabled	Boolean	Indicates whether the user's notifications are enabled.
OceClickToDialEverywhere	Boolean	A boolean value indicating whether phone calls will launch a call from Outreach.
OceGmailToolbar	Boolean	A boolean value indicating whether the Outreach Gmail toolbar is enabled.
OceGmailTrackingState	String	The user's current email tracking settings when using Outreach Everywhere with GMail.
OceSalesforceEmailDecorating	Boolean	A boolean value indicating whether emails are enabled in Outreach Everywhere with Salesforce.
OceSalesforcePhoneDecorating	Boolean	A boolean value indicating whether phone calls are enabled in Outreach Everywhere with Salesforce.
OceUniversalTaskFlow	Boolean	A boolean value indicating whether Outreach Everywhere universal task flow is enabled.
OceWindowMode	Boolean	A boolean value indicating whether Outreach Everywhere window mode is enabled.
OnboardedAt	Datetime	The date and time the user was onboarded.
OpportunitiesViewId	String	The default smart view to load on the opportunity index view.
PasswordExpiresAt	Datetime	The date and time the current password expires.
PhoneCountryCode	String	The country code of the user's phone.
PhoneNumber	String	The telephone number of the user's phone.
PhoneType	String	The user's type of telephone for outbound calls.
PluginAlertNotificationEnabled	Boolean	Indicates whether the user's plugin-related error notifications are enabled.
PreferredVoiceRegion	String	The Twilio data center used to connect to Twilio.
PrefersLocalPresence	Boolean	Indicates whether the user prefers that a voice call comes from a local phone number.
PrimaryTimezone	String	The primary preferred timezone to use when scheduling meetings.
ProspectsViewId	String	The default smart view to load on the prospect index view.
ReportsTeamPerfViewId	String	The default smart view to load on the team performance reports view.
ReportsViewId	String	The default smart view to load on the reports view.
ScimExternalId	String	The ID from the SCIM provisioning service used to create the user.
ScimSource	String	The name of the SCIM provisioning source used to create the user.
SecondaryTimezone	String	The secondary preferred timezone to use when scheduling meetings.
SenderNotificationsExcluded	Boolean	Indicates whether the user's sender notifications are excluded.
TasksViewId	String	The default smart view to load on the tasks index view.
TeamsViewId	String	The default smart view to load on the teams index view.
TertiaryTimezone	String	The tertiary preferred timezone to use when scheduling meetings.
TextingEmailNotifications	Boolean	Indicates whether the user receives email notifications when a text message is missed.
Title	String	The user's job title.
UnknownReplyEmailEnabled	Boolean	Indicates whether the user's unknown reply emails are enabled.
UpdatedAt	Datetime	The date and time the user was last updated.
UserGuid	String	The globally unique ID (GUID) assigned to the user.
Username	String	The username of the user.
UsersViewId	String	The default smart view to load on the users index view.
VoicemailNotificationEnabled	Boolean	Indicates whether the user's voicemail notifications are enabled.
WeeklyDigestEmailEnabled	Boolean	Indicates whether the user's weekly digest emails are enabled.
LinksSelf	String	Link self.
CreatorId	Integer	The Id of the creator.
CreatorType	String	The type of the creator.
MailboxId	Integer	Mailboxes Id associated with the users.
MailboxType	String	Mailboxes type associated with the users.
ProfileId	Integer	Profile Id associated with the users.
ProfileType	String	Profile type associated with the users.
RecipientsData	String	Recipients associated with the users.
RecipientsLinks	String	Recipients type associated with the users.
RoleId	Integer	Roles Id associated with the users.
RoleType	String	Roles type associated with the users.
TeamsData	String	Teams associated with the users.
UpdaterId	Integer	The Id of the updater.
UpdaterType	String	The type of the updater.
Type	String	The type of the user.

SSIS Components for Outreach

Users

Select

Columns