ODBC Driver for Outreach

Build 24.0.9062

Users

Get details of the individual that uses the application.

Select

The 本製品 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 本製品.

  • Id 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.
For example, the following query is 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 User.
AccountsViewId Integer The default smart view to load on the account index view.
ActivityNotificationsDisabled Boolean A boolean value indicating whether or not the user's activity notifications are disabled.
BounceWarningEmailEnabled Boolean A boolean value indicating whether or not 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 Integer 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 A boolean value indicating 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 duties were set.
Email String The email address of the user.
EnableVoiceRecordings Boolean A boolean value indicating whether or not the user has voice recordings enabled.
EngagementEmailsEnabled Boolean A boolean value indicating whether or not 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 Integer The default smart view to load on the kaia recordings view.
KeepBridgePhoneConnected Boolean Whether or not to keep the user's bridge phone connected in-between outbound calls.
LastName String The last name of the user.
LastSignInAt Datetime The date and time the user previously signed in.
Locked Boolean A boolean value indicating whether or not the user is locked out of the application.
MailboxErrorEmailEnabled Boolean A boolean value indicating whether or not the user's mailbox error emails are enabled.
MeetingEngagementNotificationEnabled Boolean A boolean value indicating whether or not the user's meeting engagement notifications are enabled.
Name String The full name of the user.
NotificationsEnabled Boolean A boolean value indicating whether or not or not the user's notifications are enabled.
OceClickToDialEverywhere Boolean A boolean value indicating whether or not phone calls will launch a call from Outreach.
OceGmailToolbar Boolean A boolean value indicating whether or not 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 or not emails are enabled in Outreach Everywhere with Salesforce.
OceSalesforcePhoneDecorating Boolean A boolean value indicating whether or not 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 Integer 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.

使用できる値は次のとおりです。bridge, voip

PluginAlertNotificationEnabled Boolean A boolean value indicating whether or not or not the user's plugin related error notifications are enabled.
PreferredVoiceRegion String A string that represents Twilio data center used to connect to Twilio.
PrefersLocalPresence Boolean A boolean value indicating whether or not 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 Integer The default smart view to load on the prospect index view.
ReportsTeamPerfViewId Integer The default smart view to load on the team performance reports view.
ReportsViewId Integer 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 A boolean value indicating whether or not the user's sender notifications are excluded.
TasksViewId Integer The default smart view to load on the tasks index view.
TeamsViewId Integer The default smart view to load on the teams index view.
TertiaryTimezone String The tertiary preferred timezone to use when scheduling meetings.
TextingEmailNotifications Boolean A boolean value indicating whether or not to send the user email notifications when a text message is missed.
Title String The user's job title.
UnknownReplyEmailEnabled Boolean A boolean value indicating whether or not 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 A reader friendly unique identifier of the user.
UsersViewId Integer The default smart view to load on the users index view.
VoicemailNotificationEnabled Boolean A boolean value indicating whether or not the user's voicemail notifications are enabled.
WeeklyDigestEmailEnabled Boolean A boolean value indicating whether or not the user's weekly digest email are enabled.
LinksSelf String Link self.
ContentCategoryMembershipsId Interger Content category memberships Id.
CreatorId Integer The creator Id of the template.
CreatorType String The creator type of the template.
MailboxId Integer Mailboxes Id associated with the user.
MailboxType String Mailboxes type associated with the user.
ProfileId Integer Profile Id associated with the user.
ProfileType String Profile type associated with the user.
RecipientsId Integer Recipients Id associated with the user.
RecipientsLinks Integer Recipients type associated with the user.
RoleId Integer Roles Id associated with the user.
RoleType String Roles type associated with the user.
TeamsId Integer Teams Id associated with the user.
UpdaterId Integer The Updater Id of the template.
UpdaterType String The Updater type of the template.
Type String type.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062