Outreach

Outreach is a sales engagement platform that accelerates revenue growth by optimizing every interaction throughout the customer lifecycle.

Outreach integration replicates data using the Outreach REST API.

See the Schema section for a list of objects available for replication.

Présentation générale de ce connecteur, y compris des liens utiles et les fonctions supportées.

Caractéristique/Fonctionnalité	Détails du support
Projets Qlik Talend Data Integration supportés	Projets de réplication uniquement. Les projets de pipeline de données ne sont pas supportés.
Méthodes de mise à jour de la cible	Tâches de réplication : Appliquer les modifications Stocker les modifications Tâches de dépôt temporaire de données dans un lac de données : Change Data Capture (CDC)
Gestion des métadonnées	La génération manuelle de métadonnées n'est pas nécessaire.
Évolution du schéma	Seule l'opération Modifier le type de données de la colonne est supportée.
Réplication de colonnes LOB (NCLOB, CLOB et BLOB)	Non supporté.
Opération CDC planifiée	Requis. C'est ainsi que la cible est mise à jour en fonction des modifications apportées à la source. Pour les tâches de réplication, consultez Planification de tâches . Pour les tâches de dépôt temporaire dans un lac, consultez Planification de CDC pour les tâches de dépôt temporaire dans un lac.
Notifications	Partiellement supporté Définition de notifications en cas de modifications du fonctionnement
Monitoring	CDC uniquement, car Chargement complet n'est pas pertinent pour ce connecteur. Surveillance d'une tâche de données individuelle
Désimbrication automatique des charges utiles des colonnes JSON	Non supporté. Les charges utiles des colonnes JSON des jeux de données sources ne sont pas automatiquement désimbriquées sur la cible.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Assurez-vous que le compte que vous utilisez dispose d'un accès en lecture sur les tables à récupérer.

To generate your OAuth Application ID and Application Secret:

Log into your Outreach Developers account.
Select the OAuth application you want to use, or create a new one.
In the left navigation bar, click Feature Selection to make sure the Outreach OAuth API feature is added.
In the left navigation bar, click API access (OAuth) to generate your OAuth Application ID.
Copy and save the Application Secret in a secured file. You will need it to connect to the application.
Enter https://connector.qlik.com/auth/oauth/v3.htm as your Callback URL.
Make sure the following scopes are selected in the configuration:
- callDispositions.read
- callPurposes.read
- duties.read
- events.read
- mailboxes.read
- stages.read
- users.read
- accounts.read
- calls.read
- personas.read
- prospects.read
- mailings.read
- opportunities.read
- tasks.read
- teams.read
- contentCategories.read
- sequences.read
- sequenceTemplates.read
- sequenceStates.read
- sequenceSteps.read

Creating the connection

For more information, see Connexion à des applications SaaS.

Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
Note ConseilYou may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting	Description
Data gateway	Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation. Note Informations Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud, car il ne supporte pas Passerelle de déplacement des données. Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données, sélectionnez Aucune. Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données.
Start Date	Saisissez la date, au format `MM/DD/YYYY`, à partir de laquelle les données doivent être répliquées de votre source vers votre cible.
Quota Limit	The percentage of the rate limit dedicated to the tap.
OAuth Application ID	OAuth Application ID.
Application Secret	Application secret.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

accounts

The accounts table contains information about prospective clients in Outreach.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join accounts with	on
opportunities	accounts.id = opportunities.id accounts.creatorId = opportunities.creatorId accounts.ownerId = opportunities.creatorId accounts.updaterId = opportunities.creatorId accounts.creatorId = opportunities.ownerId accounts.ownerId = opportunities.ownerId accounts.updaterId = opportunities.ownerId
prospects	accounts.id = prospects.id accounts.creatorId = prospects.creatorId accounts.ownerId = prospects.creatorId accounts.updaterId = prospects.creatorId accounts.creatorId = prospects.updaterId accounts.ownerId = prospects.updaterId accounts.updaterId = prospects.updaterId
sequence_states	accounts.id = sequence_states.id accounts.creatorId = sequence_states.creatorId accounts.ownerId = sequence_states.creatorId accounts.updaterId = sequence_states.creatorId
tasks	accounts.id = tasks.id accounts.creatorId = tasks.creatorId accounts.ownerId = tasks.creatorId accounts.updaterId = tasks.creatorId accounts.creatorId = tasks.completerId accounts.ownerId = tasks.completerId accounts.updaterId = tasks.completerId
call_dispositions	accounts.creatorId = call_dispositions.creatorId accounts.ownerId = call_dispositions.creatorId accounts.updaterId = call_dispositions.creatorId
call_purposes	accounts.creatorId = call_purposes.creatorId accounts.ownerId = call_purposes.creatorId accounts.updaterId = call_purposes.creatorId
calls	accounts.creatorId = calls.userId accounts.ownerId = calls.userId accounts.updaterId = calls.userId
content_categories	accounts.creatorId = content_categories.creatorId accounts.ownerId = content_categories.creatorId accounts.updaterId = content_categories.creatorId
mailboxes	accounts.creatorId = mailboxes.creatorId accounts.ownerId = mailboxes.creatorId accounts.updaterId = mailboxes.creatorId accounts.creatorId = mailboxes.updaterId accounts.ownerId = mailboxes.updaterId accounts.updaterId = mailboxes.updaterId accounts.creatorId = mailboxes.userId accounts.ownerId = mailboxes.userId accounts.updaterId = mailboxes.userId
sequence_steps	accounts.creatorId = sequence_steps.creatorId accounts.ownerId = sequence_steps.creatorId accounts.updaterId = sequence_steps.creatorId accounts.creatorId = sequence_steps.updaterId accounts.ownerId = sequence_steps.updaterId accounts.updaterId = sequence_steps.updaterId
sequence_templates	accounts.creatorId = sequence_templates.creatorId accounts.ownerId = sequence_templates.creatorId accounts.updaterId = sequence_templates.creatorId accounts.creatorId = sequence_templates.updaterId accounts.ownerId = sequence_templates.updaterId accounts.updaterId = sequence_templates.updaterId
sequences	accounts.creatorId = sequences.creatorId accounts.ownerId = sequences.creatorId accounts.updaterId = sequences.creatorId accounts.creatorId = sequences.ownerId accounts.ownerId = sequences.ownerId accounts.updaterId = sequences.ownerId accounts.creatorId = sequences.updaterId accounts.ownerId = sequences.updaterId accounts.updaterId = sequences.updaterId
stages	accounts.creatorId = stages.creatorId accounts.ownerId = stages.creatorId accounts.updaterId = stages.creatorId accounts.creatorId = stages.updaterId accounts.ownerId = stages.updaterId accounts.updaterId = stages.updaterId
users	accounts.creatorId = users.creatorId accounts.ownerId = users.creatorId accounts.updaterId = users.creatorId accounts.creatorId = users.id accounts.ownerId = users.id accounts.updaterId = users.id accounts.creatorId = users.updaterId accounts.ownerId = users.updaterId accounts.updaterId = users.updaterId

buyerIntentScore

NUMBER

companyType

STRING

createdAt

DATE-TIME

creatorId

INTEGER

custom1

STRING

custom10

STRING

custom100

STRING

custom101

STRING

custom102

STRING

custom103

STRING

custom104

STRING

custom105

STRING

custom106

STRING

custom107

STRING

custom108

STRING

custom109

STRING

custom11

STRING

custom110

STRING

custom111

STRING

custom112

STRING

custom113

STRING

custom114

STRING

custom115

STRING

custom116

STRING

custom117

STRING

custom118

STRING

custom119

STRING

custom12

STRING

custom120

STRING

custom121

STRING

custom122

STRING

custom123

STRING

custom124

STRING

custom125

STRING

custom126

STRING

custom127

STRING

custom128

STRING

custom129

STRING

custom13

STRING

custom130

STRING

custom131

STRING

custom132

STRING

custom133

STRING

custom134

STRING

custom135

STRING

custom136

STRING

custom137

STRING

custom138

STRING

custom139

STRING

custom14

STRING

custom140

STRING

custom141

STRING

custom142

STRING

custom143

STRING

custom144

STRING

custom145

STRING

custom146

STRING

custom147

STRING

custom148

STRING

custom149

STRING

custom15

STRING

custom150

STRING

custom16

STRING

custom17

STRING

custom18

STRING

custom19

STRING

custom2

STRING

custom20

STRING

custom21

STRING

custom22

STRING

custom23

STRING

custom24

STRING

custom25

STRING

custom26

STRING

custom27

STRING

custom28

STRING

custom29

STRING

custom3

STRING

custom30

STRING

custom31

STRING

custom32

STRING

custom33

STRING

custom34

STRING

custom35

STRING

custom36

STRING

custom37

STRING

custom38

STRING

custom39

STRING

custom4

STRING

custom40

STRING

custom41

STRING

custom42

STRING

custom43

STRING

custom44

STRING

custom45

STRING

custom46

STRING

custom47

STRING

custom48

STRING

custom49

STRING

custom5

STRING

custom50

STRING

custom51

STRING

custom52

STRING

custom53

STRING

custom54

STRING

custom55

STRING

custom56

STRING

custom57

STRING

custom58

STRING

custom59

STRING

custom6

STRING

custom60

STRING

custom61

STRING

custom62

STRING

custom63

STRING

custom64

STRING

custom65

STRING

custom66

STRING

custom67

STRING

custom68

STRING

custom69

STRING

custom7

STRING

custom70

STRING

custom71

STRING

custom72

STRING

custom73

STRING

custom74

STRING

custom75

STRING

custom76

STRING

custom77

STRING

custom78

STRING

custom79

STRING

custom8

STRING

custom80

STRING

custom81

STRING

custom82

STRING

custom83

STRING

custom84

STRING

custom85

STRING

custom86

STRING

custom87

STRING

custom88

STRING

custom89

STRING

custom9

STRING

custom90

STRING

custom91

STRING

custom92

STRING

custom93

STRING

custom94

STRING

custom95

STRING

custom96

STRING

custom97

STRING

custom98

STRING

custom99

STRING

customId

STRING

description

STRING

domain

STRING

externalSource

STRING

followers

INTEGER

foundedAt

DATE-TIME

INTEGER

industry

STRING

linkedInEmployees

INTEGER

linkedInUrl

STRING

locality

STRING

name

STRING

named

BOOLEAN

naturalName

STRING

numberOfEmployees

INTEGER

ownerId

INTEGER

sharingTeamId

STRING

tags

ARRAY

This is a nested data structure.

touchedAt

DATE-TIME

updatedAt

DATE-TIME

updaterId

INTEGER

websiteUrl

STRING

call_dispositions

The call_dispositions table contains information about call dispositions from your call log in Outreach.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join call_dispositions with	on
calls	call_dispositions.id = calls.callDispositionId call_dispositions.creatorId = calls.userId
accounts	call_dispositions.creatorId = accounts.creatorId call_dispositions.creatorId = accounts.ownerId call_dispositions.creatorId = accounts.updaterId
call_purposes	call_dispositions.creatorId = call_purposes.creatorId
content_categories	call_dispositions.creatorId = content_categories.creatorId
mailboxes	call_dispositions.creatorId = mailboxes.creatorId call_dispositions.creatorId = mailboxes.updaterId call_dispositions.creatorId = mailboxes.userId
opportunities	call_dispositions.creatorId = opportunities.creatorId call_dispositions.creatorId = opportunities.ownerId
prospects	call_dispositions.creatorId = prospects.creatorId call_dispositions.creatorId = prospects.updaterId
sequence_states	call_dispositions.creatorId = sequence_states.creatorId
sequence_steps	call_dispositions.creatorId = sequence_steps.creatorId call_dispositions.creatorId = sequence_steps.updaterId
sequence_templates	call_dispositions.creatorId = sequence_templates.creatorId call_dispositions.creatorId = sequence_templates.updaterId
sequences	call_dispositions.creatorId = sequences.creatorId call_dispositions.creatorId = sequences.ownerId call_dispositions.creatorId = sequences.updaterId
stages	call_dispositions.creatorId = stages.creatorId call_dispositions.creatorId = stages.updaterId
tasks	call_dispositions.creatorId = tasks.creatorId call_dispositions.creatorId = tasks.completerId
users	call_dispositions.creatorId = users.creatorId call_dispositions.creatorId = users.id call_dispositions.creatorId = users.updaterId

createdAt

DATE-TIME

creatorId

INTEGER

name

STRING

order

INTEGER

outcome

STRING

updatedAt

DATE-TIME

call_purposes

The call_purposes table contains information about the purpose of calls in your Outreach call logs.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join call_purposes with	on
calls	call_purposes.id = calls.callPurposeId call_purposes.creatorId = calls.userId
accounts	call_purposes.creatorId = accounts.creatorId call_purposes.creatorId = accounts.ownerId call_purposes.creatorId = accounts.updaterId
call_dispositions	call_purposes.creatorId = call_dispositions.creatorId
content_categories	call_purposes.creatorId = content_categories.creatorId
mailboxes	call_purposes.creatorId = mailboxes.creatorId call_purposes.creatorId = mailboxes.updaterId call_purposes.creatorId = mailboxes.userId
opportunities	call_purposes.creatorId = opportunities.creatorId call_purposes.creatorId = opportunities.ownerId
prospects	call_purposes.creatorId = prospects.creatorId call_purposes.creatorId = prospects.updaterId
sequence_states	call_purposes.creatorId = sequence_states.creatorId
sequence_steps	call_purposes.creatorId = sequence_steps.creatorId call_purposes.creatorId = sequence_steps.updaterId
sequence_templates	call_purposes.creatorId = sequence_templates.creatorId call_purposes.creatorId = sequence_templates.updaterId
sequences	call_purposes.creatorId = sequences.creatorId call_purposes.creatorId = sequences.ownerId call_purposes.creatorId = sequences.updaterId
stages	call_purposes.creatorId = stages.creatorId call_purposes.creatorId = stages.updaterId
tasks	call_purposes.creatorId = tasks.creatorId call_purposes.creatorId = tasks.completerId
users	call_purposes.creatorId = users.creatorId call_purposes.creatorId = users.id call_purposes.creatorId = users.updaterId

createdAt

DATE-TIME

creatorId

INTEGER

name

STRING

order

INTEGER

updatedAt

DATE-TIME

calls

The calls table contains information about inbound and outbound calls in your Outreach call logs.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join calls with	on
call_dispositions	calls.callDispositionId = call_dispositions.id calls.userId = call_dispositions.creatorId
call_purposes	calls.callPurposeId = call_purposes.id calls.userId = call_purposes.creatorId
tasks	calls.id = tasks.callId calls.opportunityId = tasks.opportunityId calls.prospectId = tasks.prospectId calls.sequenceId = tasks.sequenceId calls.sequenceStateId = tasks.sequenceStateId calls.sequenceStepId = tasks.sequenceStepId calls.id = tasks.id calls.userId = tasks.creatorId calls.userId = tasks.completerId
mailings	calls.opportunityId = mailings.opportunityId calls.prospectId = mailings.prospectId calls.sequenceId = mailings.sequenceId calls.sequenceStateId = mailings.sequenceStateId calls.sequenceStepId = mailings.sequenceStepId calls.id = mailings.id
opportunities	calls.opportunityId = opportunities.id calls.userId = opportunities.creatorId calls.userId = opportunities.ownerId
events	calls.prospectId = events.prospectId
prospects	calls.prospectId = prospects.id calls.userId = prospects.creatorId calls.userId = prospects.updaterId
sequence_states	calls.prospectId = sequence_states.prospectId calls.sequenceId = sequence_states.sequenceId calls.sequenceStateId = sequence_states.id calls.userId = sequence_states.creatorId
sequence_steps	calls.sequenceId = sequence_steps.sequenceId calls.sequenceStepId = sequence_steps.id calls.userId = sequence_steps.creatorId calls.userId = sequence_steps.updaterId
accounts	calls.userId = accounts.creatorId calls.userId = accounts.ownerId calls.userId = accounts.updaterId
content_categories	calls.userId = content_categories.creatorId
mailboxes	calls.userId = mailboxes.creatorId calls.userId = mailboxes.updaterId calls.userId = mailboxes.userId
sequence_templates	calls.userId = sequence_templates.creatorId calls.userId = sequence_templates.updaterId
sequences	calls.userId = sequences.creatorId calls.userId = sequences.ownerId calls.userId = sequences.updaterId
stages	calls.userId = stages.creatorId calls.userId = stages.updaterId
users	calls.userId = users.creatorId calls.userId = users.id calls.userId = users.updaterId

answeredAt

DATE-TIME

callDispositionId

INTEGER

callPurposeId

INTEGER

completedAt

DATE-TIME

createdAt

DATE-TIME

dialedAt

DATE-TIME

direction

STRING

externalVendor

STRING

from

STRING

INTEGER

note

STRING

opportunityId

INTEGER

outcome

STRING

phoneNumberId

INTEGER

prospectId

INTEGER

recordingUrl

STRING

returnedAt

DATE-TIME

sequenceAction

STRING

sequenceId

INTEGER

sequenceStateId

INTEGER

sequenceStepId

INTEGER

shouldRecordCall

BOOLEAN

state

STRING

stateChangedAt

DATE-TIME

tags

ARRAY

This is a nested data structure.

taskId

INTEGER

STRING

uid

STRING

updatedAt

DATE-TIME

userCallType

STRING

userId

INTEGER

vendorCallId

STRING

voicemailRecordingUrl

STRING

content_categories

The content_categories table contains information about your content categories in Outreach.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join content_categories with	on
accounts	content_categories.creatorId = accounts.creatorId content_categories.creatorId = accounts.ownerId content_categories.creatorId = accounts.updaterId
call_dispositions	content_categories.creatorId = call_dispositions.creatorId
call_purposes	content_categories.creatorId = call_purposes.creatorId
calls	content_categories.creatorId = calls.userId
mailboxes	content_categories.creatorId = mailboxes.creatorId content_categories.creatorId = mailboxes.updaterId content_categories.creatorId = mailboxes.userId
opportunities	content_categories.creatorId = opportunities.creatorId content_categories.creatorId = opportunities.ownerId
prospects	content_categories.creatorId = prospects.creatorId content_categories.creatorId = prospects.updaterId
sequence_states	content_categories.creatorId = sequence_states.creatorId
sequence_steps	content_categories.creatorId = sequence_steps.creatorId content_categories.creatorId = sequence_steps.updaterId
sequence_templates	content_categories.creatorId = sequence_templates.creatorId content_categories.creatorId = sequence_templates.updaterId
sequences	content_categories.creatorId = sequences.creatorId content_categories.creatorId = sequences.ownerId content_categories.creatorId = sequences.updaterId
stages	content_categories.creatorId = stages.creatorId content_categories.creatorId = stages.updaterId
tasks	content_categories.creatorId = tasks.creatorId content_categories.creatorId = tasks.completerId
users	content_categories.creatorId = users.creatorId content_categories.creatorId = users.id content_categories.creatorId = users.updaterId

allowSequences

BOOLEAN

allowSnippets

BOOLEAN

allowTemplates

BOOLEAN

color

STRING

createdAt

DATE-TIME

creatorId

INTEGER

name

STRING

updatedAt

DATE-TIME

duties

The duties table contains Outreach-suggested job roles for users.

Replication Method

Full Table

Primary Key

Useful links

Outreach API method

Join duties with	on
users	duties.id = users.duties.id

dutyType

STRING

INTEGER

symbolicName

STRING

events

The events table contains information about application events in your Outreach account.

Replication Method	CDC
Primary Key	id
Replication Key	eventAt
Useful links	Outreach API method

Join events with	on
mailings	events.mailingId = mailings.id events.prospectId = mailings.prospectId
tasks	events.mailingId = tasks.mailingId events.prospectId = tasks.prospectId
calls	events.prospectId = calls.prospectId
prospects	events.prospectId = prospects.id
sequence_states	events.prospectId = sequence_states.prospectId

accountId

INTEGER

body

STRING

callId

INTEGER

createdAt

DATE-TIME

eventAt

DATE-TIME

externalUrl

STRING

INTEGER

mailingId

INTEGER

name

STRING

opportunityId

INTEGER

payload

OBJECT

This is a nested data structure.

prospectId

INTEGER

requestCity

STRING

requestDevice

STRING

requestHost

STRING

requestProxied

BOOLEAN

requestRegion

BOOLEAN

taskId

INTEGER

userId

INTEGER

mailboxes

The mailboxes table contains information about your Outreach email mailbox.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join mailboxes with	on
mailings	mailboxes.id = mailings.mailboxId
users	mailboxes.id = users.mailboxId mailboxes.creatorId = users.creatorId mailboxes.updaterId = users.creatorId mailboxes.userId = users.creatorId mailboxes.creatorId = users.id mailboxes.updaterId = users.id mailboxes.userId = users.id mailboxes.creatorId = users.updaterId mailboxes.updaterId = users.updaterId mailboxes.userId = users.updaterId
accounts	mailboxes.creatorId = accounts.creatorId mailboxes.updaterId = accounts.creatorId mailboxes.userId = accounts.creatorId mailboxes.creatorId = accounts.ownerId mailboxes.updaterId = accounts.ownerId mailboxes.userId = accounts.ownerId mailboxes.creatorId = accounts.updaterId mailboxes.updaterId = accounts.updaterId mailboxes.userId = accounts.updaterId
call_dispositions	mailboxes.creatorId = call_dispositions.creatorId mailboxes.updaterId = call_dispositions.creatorId mailboxes.userId = call_dispositions.creatorId
call_purposes	mailboxes.creatorId = call_purposes.creatorId mailboxes.updaterId = call_purposes.creatorId mailboxes.userId = call_purposes.creatorId
calls	mailboxes.creatorId = calls.userId mailboxes.updaterId = calls.userId mailboxes.userId = calls.userId
content_categories	mailboxes.creatorId = content_categories.creatorId mailboxes.updaterId = content_categories.creatorId mailboxes.userId = content_categories.creatorId
opportunities	mailboxes.creatorId = opportunities.creatorId mailboxes.updaterId = opportunities.creatorId mailboxes.userId = opportunities.creatorId mailboxes.creatorId = opportunities.ownerId mailboxes.updaterId = opportunities.ownerId mailboxes.userId = opportunities.ownerId
prospects	mailboxes.creatorId = prospects.creatorId mailboxes.updaterId = prospects.creatorId mailboxes.userId = prospects.creatorId mailboxes.creatorId = prospects.updaterId mailboxes.updaterId = prospects.updaterId mailboxes.userId = prospects.updaterId
sequence_states	mailboxes.creatorId = sequence_states.creatorId mailboxes.updaterId = sequence_states.creatorId mailboxes.userId = sequence_states.creatorId
sequence_steps	mailboxes.creatorId = sequence_steps.creatorId mailboxes.updaterId = sequence_steps.creatorId mailboxes.userId = sequence_steps.creatorId mailboxes.creatorId = sequence_steps.updaterId mailboxes.updaterId = sequence_steps.updaterId mailboxes.userId = sequence_steps.updaterId
sequence_templates	mailboxes.creatorId = sequence_templates.creatorId mailboxes.updaterId = sequence_templates.creatorId mailboxes.userId = sequence_templates.creatorId mailboxes.creatorId = sequence_templates.updaterId mailboxes.updaterId = sequence_templates.updaterId mailboxes.userId = sequence_templates.updaterId
sequences	mailboxes.creatorId = sequences.creatorId mailboxes.updaterId = sequences.creatorId mailboxes.userId = sequences.creatorId mailboxes.creatorId = sequences.ownerId mailboxes.updaterId = sequences.ownerId mailboxes.userId = sequences.ownerId mailboxes.creatorId = sequences.updaterId mailboxes.updaterId = sequences.updaterId mailboxes.userId = sequences.updaterId
stages	mailboxes.creatorId = stages.creatorId mailboxes.updaterId = stages.creatorId mailboxes.userId = stages.creatorId mailboxes.creatorId = stages.updaterId mailboxes.updaterId = stages.updaterId mailboxes.userId = stages.updaterId
tasks	mailboxes.creatorId = tasks.creatorId mailboxes.updaterId = tasks.creatorId mailboxes.userId = tasks.creatorId mailboxes.creatorId = tasks.completerId mailboxes.updaterId = tasks.completerId mailboxes.userId = tasks.completerId

authId

INTEGER

createdAt

DATE-TIME

creatorId

INTEGER

editable

BOOLEAN

email

STRING

emailHash

STRING

emailProvider

STRING

emailSignature

STRING

ewsEndpoint

STRING

ewsSslVerifyMode

INTEGER

exchangeVersion

STRING

INTEGER

imapHost

STRING

imapPort

INTEGER

imapSsl

BOOLEAN

maxEmailsPerDay

INTEGER

maxMailingsPerDay

INTEGER

maxMailingsPerWeek

INTEGER

optOutMessage

STRING

optOutSignature

STRING

prospectEmailExclusions

STRING

providerId

INTEGER

providerType

STRING

sendDisabled

BOOLEAN

sendErroredAt

DATE-TIME

sendMaxRetries

INTEGER

sendMethod

STRING

sendPeriod

INTEGER

sendRequiresSync

BOOLEAN

sendSuccessAt

DATE-TIME

sendThreshold

INTEGER

sendgridWebhookUrl

STRING

smtpHost

STRING

smtpPort

INTEGER

smtpSsl

BOOLEAN

smtpUsername

STRING

syncActiveFrequency

INTEGER

syncDisabled

BOOLEAN

syncErroredAt

DATE-TIME

syncFinishedAt

DATE-TIME

syncMethod

STRING

syncOutreachFolder

BOOLEAN

syncPassiveFrequency

INTEGER

syncSuccessAt

DATE-TIME

updatedAt

DATE-TIME

updaterId

INTEGER

userId

INTEGER

username

STRING

mailings

The mailings table is a representation of a platform-related email.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join mailings with	on
mailboxes	mailings.mailboxId = mailboxes.id
users	mailings.mailboxId = users.mailboxId
events	mailings.id = events.mailingId mailings.prospectId = events.prospectId
tasks	mailings.id = tasks.mailingId mailings.opportunityId = tasks.opportunityId mailings.prospectId = tasks.prospectId mailings.sequenceId = tasks.sequenceId mailings.sequenceStateId = tasks.sequenceStateId mailings.sequenceStepId = tasks.sequenceStepId mailings.id = tasks.id
calls	mailings.opportunityId = calls.opportunityId mailings.prospectId = calls.prospectId mailings.sequenceId = calls.sequenceId mailings.sequenceStateId = calls.sequenceStateId mailings.sequenceStepId = calls.sequenceStepId mailings.id = calls.id
opportunities	mailings.opportunityId = opportunities.id
prospects	mailings.prospectId = prospects.id
sequence_states	mailings.prospectId = sequence_states.prospectId mailings.sequenceId = sequence_states.sequenceId mailings.sequenceStateId = sequence_states.id
sequence_steps	mailings.sequenceId = sequence_steps.sequenceId mailings.sequenceStepId = sequence_steps.id

bodyHtml

STRING

bodyText

STRING

bouncedAt

DATE-TIME

clickCount

INTEGER

clickedAt

DATE-TIME

createdAt

DATE-TIME

deliveredAt

DATE-TIME

errorBacktrace

STRING

errorReason

STRING

followUpSequenceId

INTEGER

followUpTaskScheduledAt

DATE-TIME

followUpTaskType

STRING

INTEGER

mailboxAddress

STRING

mailboxId

INTEGER

mailingType

STRING

markedAsSpamAt

DATE-TIME

messageId

STRING

notifyThreadCondition

STRING

notifyThreadScheduledAt

DATE-TIME

notifyThreadStatus

STRING

openCount

INTEGER

openedAt

DATE-TIME

opportunityId

INTEGER

overrideSafetySettings

BOOLEAN

prospectId

INTEGER

references

ARRAY

This is a nested data structure.

repliedAt

DATE-TIME

retryAt

DATE-TIME

retryCount

INTEGER

retryInterval

INTEGER

scheduledAt

DATE-TIME

sequenceId

INTEGER

sequenceStateId

INTEGER

sequenceStepId

INTEGER

state

STRING

stateChangedAt

DATE-TIME

subject

STRING

taskId

INTEGER

templateId

INTEGER

trackLinks

BOOLEAN

trackOpens

BOOLEAN

unsubscribedAt

DATE-TIME

updatedAt

DATE-TIME

userId

INTEGER

opportunities

The opportunities table contains information about your pending deals and sales in Outreach.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join opportunities with	on
accounts	opportunities.id = accounts.id opportunities.creatorId = accounts.creatorId opportunities.ownerId = accounts.creatorId opportunities.creatorId = accounts.ownerId opportunities.ownerId = accounts.ownerId opportunities.creatorId = accounts.updaterId opportunities.ownerId = accounts.updaterId
prospects	opportunities.id = prospects.id opportunities.opportunityStageId = prospects.stageId opportunities.creatorId = prospects.creatorId opportunities.ownerId = prospects.creatorId opportunities.creatorId = prospects.updaterId opportunities.ownerId = prospects.updaterId
sequence_states	opportunities.id = sequence_states.id opportunities.creatorId = sequence_states.creatorId opportunities.ownerId = sequence_states.creatorId
tasks	opportunities.id = tasks.id opportunities.id = tasks.opportunityId opportunities.creatorId = tasks.creatorId opportunities.ownerId = tasks.creatorId opportunities.creatorId = tasks.completerId opportunities.ownerId = tasks.completerId
calls	opportunities.id = calls.opportunityId opportunities.creatorId = calls.userId opportunities.ownerId = calls.userId
mailings	opportunities.id = mailings.opportunityId
stages	opportunities.opportunityStageId = stages.id opportunities.creatorId = stages.creatorId opportunities.ownerId = stages.creatorId opportunities.creatorId = stages.updaterId opportunities.ownerId = stages.updaterId
call_dispositions	opportunities.creatorId = call_dispositions.creatorId opportunities.ownerId = call_dispositions.creatorId
call_purposes	opportunities.creatorId = call_purposes.creatorId opportunities.ownerId = call_purposes.creatorId
content_categories	opportunities.creatorId = content_categories.creatorId opportunities.ownerId = content_categories.creatorId
mailboxes	opportunities.creatorId = mailboxes.creatorId opportunities.ownerId = mailboxes.creatorId opportunities.creatorId = mailboxes.updaterId opportunities.ownerId = mailboxes.updaterId opportunities.creatorId = mailboxes.userId opportunities.ownerId = mailboxes.userId
sequence_steps	opportunities.creatorId = sequence_steps.creatorId opportunities.ownerId = sequence_steps.creatorId opportunities.creatorId = sequence_steps.updaterId opportunities.ownerId = sequence_steps.updaterId
sequence_templates	opportunities.creatorId = sequence_templates.creatorId opportunities.ownerId = sequence_templates.creatorId opportunities.creatorId = sequence_templates.updaterId opportunities.ownerId = sequence_templates.updaterId
sequences	opportunities.creatorId = sequences.creatorId opportunities.ownerId = sequences.creatorId opportunities.creatorId = sequences.ownerId opportunities.ownerId = sequences.ownerId opportunities.creatorId = sequences.updaterId opportunities.ownerId = sequences.updaterId
users	opportunities.creatorId = users.creatorId opportunities.ownerId = users.creatorId opportunities.creatorId = users.id opportunities.ownerId = users.id opportunities.creatorId = users.updaterId opportunities.ownerId = users.updaterId

accountId

INTEGER

amount

INTEGER

closeDate

DATE-TIME

createdAt

DATE-TIME

creatorId

INTEGER

currencyType

STRING

custom1

STRING

custom10

STRING

custom100

STRING

custom101

STRING

custom102

STRING

custom103

STRING

custom104

STRING

custom105

STRING

custom106

STRING

custom107

STRING

custom108

STRING

custom109

STRING

custom11

STRING

custom110

STRING

custom111

STRING

custom112

STRING

custom113

STRING

custom114

STRING

custom115

STRING

custom116

STRING

custom117

STRING

custom118

STRING

custom119

STRING

custom12

STRING

custom120

STRING

custom121

STRING

custom122

STRING

custom123

STRING

custom124

STRING

custom125

STRING

custom126

STRING

custom127

STRING

custom128

STRING

custom129

STRING

custom13

STRING

custom130

STRING

custom131

STRING

custom132

STRING

custom133

STRING

custom134

STRING

custom135

STRING

custom136

STRING

custom137

STRING

custom138

STRING

custom139

STRING

custom14

STRING

custom140

STRING

custom141

STRING

custom142

STRING

custom143

STRING

custom144

STRING

custom145

STRING

custom146

STRING

custom147

STRING

custom148

STRING

custom149

STRING

custom15

STRING

custom150

STRING

custom16

STRING

custom17

STRING

custom18

STRING

custom19

STRING

custom2

STRING

custom20

STRING

custom21

STRING

custom22

STRING

custom23

STRING

custom24

STRING

custom25

STRING

custom26

STRING

custom27

STRING

custom28

STRING

custom29

STRING

custom3

STRING

custom30

STRING

custom31

STRING

custom32

STRING

custom33

STRING

custom34

STRING

custom35

STRING

custom36

STRING

custom37

STRING

custom38

STRING

custom39

STRING

custom4

STRING

custom40

STRING

custom41

STRING

custom42

STRING

custom43

STRING

custom44

STRING

custom45

STRING

custom46

STRING

custom47

STRING

custom48

STRING

custom49

STRING

custom5

STRING

custom50

STRING

custom51

STRING

custom52

STRING

custom53

STRING

custom54

STRING

custom55

STRING

custom56

STRING

custom57

STRING

custom58

STRING

custom59

STRING

custom6

STRING

custom60

STRING

custom61

STRING

custom62

STRING

custom63

STRING

custom64

STRING

custom65

STRING

custom66

STRING

custom67

STRING

custom68

STRING

custom69

STRING

custom7

STRING

custom70

STRING

custom71

STRING

custom72

STRING

custom73

STRING

custom74

STRING

custom75

STRING

custom76

STRING

custom77

STRING

custom78

STRING

custom79

STRING

custom8

STRING

custom80

STRING

custom81

STRING

custom82

STRING

custom83

STRING

custom84

STRING

custom85

STRING

custom86

STRING

custom87

STRING

custom88

STRING

custom89

STRING

custom9

STRING

custom90

STRING

custom91

STRING

custom92

STRING

custom93

STRING

custom94

STRING

custom95

STRING

custom96

STRING

custom97

STRING

custom98

STRING

custom99

STRING

description

STRING

externalCreatedAt

DATE-TIME

INTEGER

mapLink

STRING

mapNextSteps

STRING

mapStatus

STRING

name

STRING

nextStep

STRING

opportunityStageId

INTEGER

opportunityType

STRING

ownerId

INTEGER

probability

INTEGER

prospectingRepId

STRING

sharingTeamId

STRING

stageId

INTEGER

tags

ARRAY

This is a nested data structure.

touchedAt

DATE-TIME

updatedAt

DATE-TIME

updaterId

INTEGER

personas

The personas table contains information about descriptions and types of people in Outreach.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join personas with	on
prospects	personas.id = prospects.personaId

createdAt

DATE-TIME

description

STRING

INTEGER

name

STRING

updatedAt

DATE-TIME

prospects

The prospects table contains information about your prospects.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join prospects with	on
accounts	prospects.id = accounts.id prospects.creatorId = accounts.creatorId prospects.updaterId = accounts.creatorId prospects.creatorId = accounts.ownerId prospects.updaterId = accounts.ownerId prospects.creatorId = accounts.updaterId prospects.updaterId = accounts.updaterId
opportunities	prospects.id = opportunities.id prospects.stageId = opportunities.opportunityStageId prospects.creatorId = opportunities.creatorId prospects.updaterId = opportunities.creatorId prospects.creatorId = opportunities.ownerId prospects.updaterId = opportunities.ownerId
sequence_states	prospects.id = sequence_states.id prospects.id = sequence_states.prospectId prospects.creatorId = sequence_states.creatorId prospects.updaterId = sequence_states.creatorId
tasks	prospects.id = tasks.id prospects.id = tasks.prospectId prospects.creatorId = tasks.creatorId prospects.updaterId = tasks.creatorId prospects.creatorId = tasks.completerId prospects.updaterId = tasks.completerId
personas	prospects.personaId = personas.id
calls	prospects.id = calls.prospectId prospects.creatorId = calls.userId prospects.updaterId = calls.userId
events	prospects.id = events.prospectId
mailings	prospects.id = mailings.prospectId
stages	prospects.stageId = stages.id prospects.creatorId = stages.creatorId prospects.updaterId = stages.creatorId prospects.creatorId = stages.updaterId prospects.updaterId = stages.updaterId
call_dispositions	prospects.creatorId = call_dispositions.creatorId prospects.updaterId = call_dispositions.creatorId
call_purposes	prospects.creatorId = call_purposes.creatorId prospects.updaterId = call_purposes.creatorId
content_categories	prospects.creatorId = content_categories.creatorId prospects.updaterId = content_categories.creatorId
mailboxes	prospects.creatorId = mailboxes.creatorId prospects.updaterId = mailboxes.creatorId prospects.creatorId = mailboxes.updaterId prospects.updaterId = mailboxes.updaterId prospects.creatorId = mailboxes.userId prospects.updaterId = mailboxes.userId
sequence_steps	prospects.creatorId = sequence_steps.creatorId prospects.updaterId = sequence_steps.creatorId prospects.creatorId = sequence_steps.updaterId prospects.updaterId = sequence_steps.updaterId
sequence_templates	prospects.creatorId = sequence_templates.creatorId prospects.updaterId = sequence_templates.creatorId prospects.creatorId = sequence_templates.updaterId prospects.updaterId = sequence_templates.updaterId
sequences	prospects.creatorId = sequences.creatorId prospects.updaterId = sequences.creatorId prospects.creatorId = sequences.ownerId prospects.updaterId = sequences.ownerId prospects.creatorId = sequences.updaterId prospects.updaterId = sequences.updaterId
users	prospects.creatorId = users.creatorId prospects.updaterId = users.creatorId prospects.creatorId = users.id prospects.updaterId = users.id prospects.creatorId = users.updaterId prospects.updaterId = users.updaterId

accountId

INTEGER

addedAt

DATE-TIME

addressCity

STRING

addressCountry

STRING

addressState

STRING

addressStreet

STRING

addressStreet2

STRING

addressZip

STRING

angelListUrl

STRING

availableAt

DATE-TIME

callOptedOut

BOOLEAN

callsOptStatus

STRING

callsOptedAt

DATE-TIME

campaignName

STRING

clickCount

INTEGER

company

STRING

contactHistogram

ARRAY

This is a nested data structure.

createdAt

DATE-TIME

creatorId

INTEGER

custom1

STRING

custom10

STRING

custom100

STRING

custom101

STRING

custom102

STRING

custom103

STRING

custom104

STRING

custom105

STRING

custom106

STRING

custom107

STRING

custom108

STRING

custom109

STRING

custom11

STRING

custom110

STRING

custom111

STRING

custom112

STRING

custom113

STRING

custom114

STRING

custom115

STRING

custom116

STRING

custom117

STRING

custom118

STRING

custom119

STRING

custom12

STRING

custom120

STRING

custom121

STRING

custom122

STRING

custom123

STRING

custom124

STRING

custom125

STRING

custom126

STRING

custom127

STRING

custom128

STRING

custom129

STRING

custom13

STRING

custom130

STRING

custom131

STRING

custom132

STRING

custom133

STRING

custom134

STRING

custom135

STRING

custom136

STRING

custom137

STRING

custom138

STRING

custom139

STRING

custom14

STRING

custom140

STRING

custom141

STRING

custom142

STRING

custom143

STRING

custom144

STRING

custom145

STRING

custom146

STRING

custom147

STRING

custom148

STRING

custom149

STRING

custom15

STRING

custom150

STRING

custom16

STRING

custom17

STRING

custom18

STRING

custom19

STRING

custom2

STRING

custom20

STRING

custom21

STRING

custom22

STRING

custom23

STRING

custom24

STRING

custom25

STRING

custom26

STRING

custom27

STRING

custom28

STRING

custom29

STRING

custom3

STRING

custom30

STRING

custom31

STRING

custom32

STRING

custom33

STRING

custom34

STRING

custom35

STRING

custom36

STRING

custom37

STRING

custom38

STRING

custom39

STRING

custom4

STRING

custom40

STRING

custom41

STRING

custom42

STRING

custom43

STRING

custom44

STRING

custom45

STRING

custom46

STRING

custom47

STRING

custom48

STRING

custom49

STRING

custom5

STRING

custom50

STRING

custom51

STRING

custom52

STRING

custom53

STRING

custom54

STRING

custom55

STRING

custom56

STRING

custom57

STRING

custom58

STRING

custom59

STRING

custom6

STRING

custom60

STRING

custom61

STRING

custom62

STRING

custom63

STRING

custom64

STRING

custom65

STRING

custom66

STRING

custom67

STRING

custom68

STRING

custom69

STRING

custom7

STRING

custom70

STRING

custom71

STRING

custom72

STRING

custom73

STRING

custom74

STRING

custom75

STRING

custom76

STRING

custom77

STRING

custom78

STRING

custom79

STRING

custom8

STRING

custom80

STRING

custom81

STRING

custom82

STRING

custom83

STRING

custom84

STRING

custom85

STRING

custom86

STRING

custom87

STRING

custom88

STRING

custom89

STRING

custom9

STRING

custom90

STRING

custom91

STRING

custom92

STRING

custom93

STRING

custom94

STRING

custom95

STRING

custom96

STRING

custom97

STRING

custom98

STRING

custom99

STRING

dateOfBirth

DATE-TIME

degree

STRING

emailOptedOut

BOOLEAN

emails

ARRAY

This is a nested data structure.

emailsOptStatus

STRING

emailsOptedAt

DATE-TIME

engagedAt

DATE-TIME

engagedScore

NUMBER

eventName

STRING

externalId

STRING

externalOwner

STRING

externalSource

STRING

facebookUrl

STRING

firstName

STRING

gender

STRING

githubUrl

STRING

githubUsername

STRING

googlePlusUrl

STRING

graduationDate

DATE-TIME

homePhones

ARRAY

This is a nested data structure.

INTEGER

jobStartDate

DATE-TIME

lastName

STRING

linkedInConnections

INTEGER

linkedInId

STRING

linkedInSlug

STRING

linkedInUrl

STRING

middleName

STRING

mobilePhones

ARRAY

This is a nested data structure.

name

STRING

nickname

STRING

occupation

STRING

openCount

INTEGER

optedOut

BOOLEAN

optedOutAt

DATE-TIME

otherPhones

ARRAY

This is a nested data structure.

ownerId

INTEGER

personaId

INTEGER

personalNote1

STRING

personalNote2

STRING

preferredContact

STRING

quoraUrl

STRING

region

STRING

replyCount

INTEGER

school

STRING

score

NUMBER

sharingTeamId

STRING

source

STRING

specialties

STRING

stackOverflowId

STRING

stackOverflowUrl

STRING

stageId

INTEGER

tags

ARRAY

This is a nested data structure.

timeZone

STRING

timeZoneIana

STRING

timeZoneInferred

STRING

title

STRING

touchedAt

DATE-TIME

trashedAt

DATE-TIME

twitterUrl

STRING

twitterUsername

STRING

updatedAt

DATE-TIME

updaterId

INTEGER

voipPhones

ARRAY

This is a nested data structure.

websiteUrl1

STRING

websiteUrl2

STRING

websiteUrl3

STRING

workPhones

ARRAY

This is a nested data structure.

sequence_states

The sequence_states table contains info about currently sequenced prospects.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join sequence_states with	on
accounts	sequence_states.id = accounts.id sequence_states.creatorId = accounts.creatorId sequence_states.creatorId = accounts.ownerId sequence_states.creatorId = accounts.updaterId
opportunities	sequence_states.id = opportunities.id sequence_states.creatorId = opportunities.creatorId sequence_states.creatorId = opportunities.ownerId
prospects	sequence_states.id = prospects.id sequence_states.prospectId = prospects.id sequence_states.creatorId = prospects.creatorId sequence_states.creatorId = prospects.updaterId
tasks	sequence_states.id = tasks.id sequence_states.prospectId = tasks.prospectId sequence_states.sequenceId = tasks.sequenceId sequence_states.id = tasks.sequenceStateId sequence_states.creatorId = tasks.creatorId sequence_states.creatorId = tasks.completerId
calls	sequence_states.prospectId = calls.prospectId sequence_states.sequenceId = calls.sequenceId sequence_states.id = calls.sequenceStateId sequence_states.creatorId = calls.userId
events	sequence_states.prospectId = events.prospectId
mailings	sequence_states.prospectId = mailings.prospectId sequence_states.sequenceId = mailings.sequenceId sequence_states.id = mailings.sequenceStateId
sequence_steps	sequence_states.sequenceId = sequence_steps.sequenceId sequence_states.creatorId = sequence_steps.creatorId sequence_states.creatorId = sequence_steps.updaterId
call_dispositions	sequence_states.creatorId = call_dispositions.creatorId
call_purposes	sequence_states.creatorId = call_purposes.creatorId
content_categories	sequence_states.creatorId = content_categories.creatorId
mailboxes	sequence_states.creatorId = mailboxes.creatorId sequence_states.creatorId = mailboxes.updaterId sequence_states.creatorId = mailboxes.userId
sequence_templates	sequence_states.creatorId = sequence_templates.creatorId sequence_states.creatorId = sequence_templates.updaterId
sequences	sequence_states.creatorId = sequences.creatorId sequence_states.creatorId = sequences.ownerId sequence_states.creatorId = sequences.updaterId
stages	sequence_states.creatorId = stages.creatorId sequence_states.creatorId = stages.updaterId
users	sequence_states.creatorId = users.creatorId sequence_states.creatorId = users.id sequence_states.creatorId = users.updaterId

accountId

INTEGER

activeAt

DATE-TIME

bounceCount

INTEGER

callCompletedAt

DATE-TIME

clickCount

INTEGER

createdAt

DATE-TIME

creatorId

INTEGER

deliverCount

INTEGER

errorReason

STRING

failureCount

INTEGER

mailboxId

INTEGER

negativeReplyCount

INTEGER

neutralReplyCount

INTEGER

openCount

INTEGER

opportunityId

INTEGER

optOutCount

INTEGER

pauseReason

STRING

positiveReplyCount

INTEGER

prospectId

INTEGER

repliedAt

DATE-TIME

replyCount

INTEGER

scheduleCount

INTEGER

sequenceId

INTEGER

sequenceStepId

INTEGER

state

STRING

stateChangedAt

DATE-TIME

updatedAt

DATE-TIME

sequence_steps

The sequence_steps table contains info about individual steps within automated sequences.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join sequence_steps with	on
calls	sequence_steps.sequenceId = calls.sequenceId sequence_steps.id = calls.sequenceStepId sequence_steps.creatorId = calls.userId sequence_steps.updaterId = calls.userId
mailings	sequence_steps.sequenceId = mailings.sequenceId sequence_steps.id = mailings.sequenceStepId
sequence_states	sequence_steps.sequenceId = sequence_states.sequenceId sequence_steps.creatorId = sequence_states.creatorId sequence_steps.updaterId = sequence_states.creatorId
tasks	sequence_steps.sequenceId = tasks.sequenceId sequence_steps.id = tasks.sequenceStepId sequence_steps.creatorId = tasks.creatorId sequence_steps.updaterId = tasks.creatorId sequence_steps.creatorId = tasks.completerId sequence_steps.updaterId = tasks.completerId
accounts	sequence_steps.creatorId = accounts.creatorId sequence_steps.updaterId = accounts.creatorId sequence_steps.creatorId = accounts.ownerId sequence_steps.updaterId = accounts.ownerId sequence_steps.creatorId = accounts.updaterId sequence_steps.updaterId = accounts.updaterId
call_dispositions	sequence_steps.creatorId = call_dispositions.creatorId sequence_steps.updaterId = call_dispositions.creatorId
call_purposes	sequence_steps.creatorId = call_purposes.creatorId sequence_steps.updaterId = call_purposes.creatorId
content_categories	sequence_steps.creatorId = content_categories.creatorId sequence_steps.updaterId = content_categories.creatorId
mailboxes	sequence_steps.creatorId = mailboxes.creatorId sequence_steps.updaterId = mailboxes.creatorId sequence_steps.creatorId = mailboxes.updaterId sequence_steps.updaterId = mailboxes.updaterId sequence_steps.creatorId = mailboxes.userId sequence_steps.updaterId = mailboxes.userId
opportunities	sequence_steps.creatorId = opportunities.creatorId sequence_steps.updaterId = opportunities.creatorId sequence_steps.creatorId = opportunities.ownerId sequence_steps.updaterId = opportunities.ownerId
prospects	sequence_steps.creatorId = prospects.creatorId sequence_steps.updaterId = prospects.creatorId sequence_steps.creatorId = prospects.updaterId sequence_steps.updaterId = prospects.updaterId
sequence_templates	sequence_steps.creatorId = sequence_templates.creatorId sequence_steps.updaterId = sequence_templates.creatorId sequence_steps.creatorId = sequence_templates.updaterId sequence_steps.updaterId = sequence_templates.updaterId
sequences	sequence_steps.creatorId = sequences.creatorId sequence_steps.updaterId = sequences.creatorId sequence_steps.creatorId = sequences.ownerId sequence_steps.updaterId = sequences.ownerId sequence_steps.creatorId = sequences.updaterId sequence_steps.updaterId = sequences.updaterId
stages	sequence_steps.creatorId = stages.creatorId sequence_steps.updaterId = stages.creatorId sequence_steps.creatorId = stages.updaterId sequence_steps.updaterId = stages.updaterId
users	sequence_steps.creatorId = users.creatorId sequence_steps.updaterId = users.creatorId sequence_steps.creatorId = users.id sequence_steps.updaterId = users.id sequence_steps.creatorId = users.updaterId sequence_steps.updaterId = users.updaterId

bounceCount

INTEGER

callPurposeId

INTEGER

clickCount

INTEGER

createdAt

DATE-TIME

creatorId

INTEGER

date

DATE-TIME

deliverCount

INTEGER

displayName

STRING

failureCount

INTEGER

interval

INTEGER

negativeReplyCount

INTEGER

neutralReplyCount

INTEGER

openCount

INTEGER

optOutCount

INTEGER

order

INTEGER

positiveReplyCount

INTEGER

replyCount

INTEGER

scheduleCount

INTEGER

sequenceId

INTEGER

stepType

STRING

taskAutoskipDelay

INTEGER

taskNote

STRING

taskPriorityId

INTEGER

updatedAt

DATE-TIME

updaterId

INTEGER

sequence_templates

The sequence_templates table contains info about templates used by sequence steps.

Replication Method

Full Table

Primary Key

Useful links

Outreach API method

Join sequence_templates with	on
accounts	sequence_templates.creatorId = accounts.creatorId sequence_templates.updaterId = accounts.creatorId sequence_templates.creatorId = accounts.ownerId sequence_templates.updaterId = accounts.ownerId sequence_templates.creatorId = accounts.updaterId sequence_templates.updaterId = accounts.updaterId
call_dispositions	sequence_templates.creatorId = call_dispositions.creatorId sequence_templates.updaterId = call_dispositions.creatorId
call_purposes	sequence_templates.creatorId = call_purposes.creatorId sequence_templates.updaterId = call_purposes.creatorId
calls	sequence_templates.creatorId = calls.userId sequence_templates.updaterId = calls.userId
content_categories	sequence_templates.creatorId = content_categories.creatorId sequence_templates.updaterId = content_categories.creatorId
mailboxes	sequence_templates.creatorId = mailboxes.creatorId sequence_templates.updaterId = mailboxes.creatorId sequence_templates.creatorId = mailboxes.updaterId sequence_templates.updaterId = mailboxes.updaterId sequence_templates.creatorId = mailboxes.userId sequence_templates.updaterId = mailboxes.userId
opportunities	sequence_templates.creatorId = opportunities.creatorId sequence_templates.updaterId = opportunities.creatorId sequence_templates.creatorId = opportunities.ownerId sequence_templates.updaterId = opportunities.ownerId
prospects	sequence_templates.creatorId = prospects.creatorId sequence_templates.updaterId = prospects.creatorId sequence_templates.creatorId = prospects.updaterId sequence_templates.updaterId = prospects.updaterId
sequence_states	sequence_templates.creatorId = sequence_states.creatorId sequence_templates.updaterId = sequence_states.creatorId
sequence_steps	sequence_templates.creatorId = sequence_steps.creatorId sequence_templates.updaterId = sequence_steps.creatorId sequence_templates.creatorId = sequence_steps.updaterId sequence_templates.updaterId = sequence_steps.updaterId
sequences	sequence_templates.creatorId = sequences.creatorId sequence_templates.updaterId = sequences.creatorId sequence_templates.creatorId = sequences.ownerId sequence_templates.updaterId = sequences.ownerId sequence_templates.creatorId = sequences.updaterId sequence_templates.updaterId = sequences.updaterId
stages	sequence_templates.creatorId = stages.creatorId sequence_templates.updaterId = stages.creatorId sequence_templates.creatorId = stages.updaterId sequence_templates.updaterId = stages.updaterId
tasks	sequence_templates.creatorId = tasks.creatorId sequence_templates.updaterId = tasks.creatorId sequence_templates.creatorId = tasks.completerId sequence_templates.updaterId = tasks.completerId
users	sequence_templates.creatorId = users.creatorId sequence_templates.updaterId = users.creatorId sequence_templates.creatorId = users.id sequence_templates.updaterId = users.id sequence_templates.creatorId = users.updaterId sequence_templates.updaterId = users.updaterId

bounceCount

INTEGER

clickCount

INTEGER

createdAt

DATE-TIME

creatorId

INTEGER

deliverCount

INTEGER

enabled

BOOLEAN

enabledAt

DATE-TIME

failureCount

INTEGER

isReply

BOOLEAN

negaitveReplyCount

INTEGER

neutralReplyCount

INTEGER

openCount

INTEGER

optOutCount

INTEGER

positiveReplyCount

INTEGER

replyCount

INTEGER

scheduleCount

INTEGER

sequenceStepId

INTEGER

templateId

INTEGER

updatedAt

DATE-TIME

updaterId

INTEGER

sequences

The sequences table contains info about sequences.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join sequences with	on
accounts	sequences.creatorId = accounts.creatorId sequences.ownerId = accounts.creatorId sequences.updaterId = accounts.creatorId sequences.creatorId = accounts.ownerId sequences.ownerId = accounts.ownerId sequences.updaterId = accounts.ownerId sequences.creatorId = accounts.updaterId sequences.ownerId = accounts.updaterId sequences.updaterId = accounts.updaterId
call_dispositions	sequences.creatorId = call_dispositions.creatorId sequences.ownerId = call_dispositions.creatorId sequences.updaterId = call_dispositions.creatorId
call_purposes	sequences.creatorId = call_purposes.creatorId sequences.ownerId = call_purposes.creatorId sequences.updaterId = call_purposes.creatorId
calls	sequences.creatorId = calls.userId sequences.ownerId = calls.userId sequences.updaterId = calls.userId
content_categories	sequences.creatorId = content_categories.creatorId sequences.ownerId = content_categories.creatorId sequences.updaterId = content_categories.creatorId
mailboxes	sequences.creatorId = mailboxes.creatorId sequences.ownerId = mailboxes.creatorId sequences.updaterId = mailboxes.creatorId sequences.creatorId = mailboxes.updaterId sequences.ownerId = mailboxes.updaterId sequences.updaterId = mailboxes.updaterId sequences.creatorId = mailboxes.userId sequences.ownerId = mailboxes.userId sequences.updaterId = mailboxes.userId
opportunities	sequences.creatorId = opportunities.creatorId sequences.ownerId = opportunities.creatorId sequences.updaterId = opportunities.creatorId sequences.creatorId = opportunities.ownerId sequences.ownerId = opportunities.ownerId sequences.updaterId = opportunities.ownerId
prospects	sequences.creatorId = prospects.creatorId sequences.ownerId = prospects.creatorId sequences.updaterId = prospects.creatorId sequences.creatorId = prospects.updaterId sequences.ownerId = prospects.updaterId sequences.updaterId = prospects.updaterId
sequence_states	sequences.creatorId = sequence_states.creatorId sequences.ownerId = sequence_states.creatorId sequences.updaterId = sequence_states.creatorId
sequence_steps	sequences.creatorId = sequence_steps.creatorId sequences.ownerId = sequence_steps.creatorId sequences.updaterId = sequence_steps.creatorId sequences.creatorId = sequence_steps.updaterId sequences.ownerId = sequence_steps.updaterId sequences.updaterId = sequence_steps.updaterId
sequence_templates	sequences.creatorId = sequence_templates.creatorId sequences.ownerId = sequence_templates.creatorId sequences.updaterId = sequence_templates.creatorId sequences.creatorId = sequence_templates.updaterId sequences.ownerId = sequence_templates.updaterId sequences.updaterId = sequence_templates.updaterId
stages	sequences.creatorId = stages.creatorId sequences.ownerId = stages.creatorId sequences.updaterId = stages.creatorId sequences.creatorId = stages.updaterId sequences.ownerId = stages.updaterId sequences.updaterId = stages.updaterId
tasks	sequences.creatorId = tasks.creatorId sequences.ownerId = tasks.creatorId sequences.updaterId = tasks.creatorId sequences.creatorId = tasks.completerId sequences.ownerId = tasks.completerId sequences.updaterId = tasks.completerId
users	sequences.creatorId = users.creatorId sequences.ownerId = users.creatorId sequences.updaterId = users.creatorId sequences.creatorId = users.id sequences.ownerId = users.id sequences.updaterId = users.id sequences.creatorId = users.updaterId sequences.ownerId = users.updaterId sequences.updaterId = users.updaterId

automationPercentage

NUMBER

bounceCount

INTEGER

clickCount

INTEGER

createdAt

DATE-TIME

creatorId

INTEGER

deliverCount

INTEGER

description

STRING

durationInDays

INTEGER

enabled

BOOLEAN

enabledAt

DATE-TIME

failureCount

INTEGER

finishOnReply

BOOLEAN

INTEGER

lastUsedAt

DATE-TIME

locked

BOOLEAN

lockedAt

DATE-TIME

maxActivations

INTEGER

name

STRING

negativeReplyCount

INTEGER

neutralReplyCount

INTEGER

numContactedProspects

INTEGER

numRepliedProspects

INTEGER

openCount

INTEGER

optOutCount

INTEGER

ownerId

INTEGER

positiveReplyCount

INTEGER

primaryReplyAction

STRING

primaryReplyPauseDuration

INTEGER

replyCount

INTEGER

rulesetId

INTEGER

scheduleCount

INTEGER

scheduleIntervalType

STRING

secondaryReplyAction

STRING

secondaryReplyPauseDuration

INTEGER

sequenceStepCount

INTEGER

sequenceType

STRING

shareType

STRING

tags

ARRAY

This is a nested data structure.

throttleCapacity

INTEGER

throttleMaxAddsPerDay

INTEGER

throttlePaused

BOOLEAN

throttlePausedAt

DATE-TIME

transactional

BOOLEAN

updatedAt

DATE-TIME

updaterId

INTEGER

stages

The stages table contains information about different stages in a deal process.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join stages with	on
opportunities	stages.id = opportunities.opportunityStageId stages.creatorId = opportunities.creatorId stages.updaterId = opportunities.creatorId stages.creatorId = opportunities.ownerId stages.updaterId = opportunities.ownerId
prospects	stages.id = prospects.stageId stages.creatorId = prospects.creatorId stages.updaterId = prospects.creatorId stages.creatorId = prospects.updaterId stages.updaterId = prospects.updaterId
accounts	stages.creatorId = accounts.creatorId stages.updaterId = accounts.creatorId stages.creatorId = accounts.ownerId stages.updaterId = accounts.ownerId stages.creatorId = accounts.updaterId stages.updaterId = accounts.updaterId
call_dispositions	stages.creatorId = call_dispositions.creatorId stages.updaterId = call_dispositions.creatorId
call_purposes	stages.creatorId = call_purposes.creatorId stages.updaterId = call_purposes.creatorId
calls	stages.creatorId = calls.userId stages.updaterId = calls.userId
content_categories	stages.creatorId = content_categories.creatorId stages.updaterId = content_categories.creatorId
mailboxes	stages.creatorId = mailboxes.creatorId stages.updaterId = mailboxes.creatorId stages.creatorId = mailboxes.updaterId stages.updaterId = mailboxes.updaterId stages.creatorId = mailboxes.userId stages.updaterId = mailboxes.userId
sequence_states	stages.creatorId = sequence_states.creatorId stages.updaterId = sequence_states.creatorId
sequence_steps	stages.creatorId = sequence_steps.creatorId stages.updaterId = sequence_steps.creatorId stages.creatorId = sequence_steps.updaterId stages.updaterId = sequence_steps.updaterId
sequence_templates	stages.creatorId = sequence_templates.creatorId stages.updaterId = sequence_templates.creatorId stages.creatorId = sequence_templates.updaterId stages.updaterId = sequence_templates.updaterId
sequences	stages.creatorId = sequences.creatorId stages.updaterId = sequences.creatorId stages.creatorId = sequences.ownerId stages.updaterId = sequences.ownerId stages.creatorId = sequences.updaterId stages.updaterId = sequences.updaterId
tasks	stages.creatorId = tasks.creatorId stages.updaterId = tasks.creatorId stages.creatorId = tasks.completerId stages.updaterId = tasks.completerId
users	stages.creatorId = users.creatorId stages.updaterId = users.creatorId stages.creatorId = users.id stages.updaterId = users.id stages.creatorId = users.updaterId stages.updaterId = users.updaterId

color

STRING

createdAt

DATE-TIME

creatorId

INTEGER

name

STRING

order

INTEGER

updatedAt

DATE-TIME

updaterId

INTEGER

tasks

The tasks table contains information about items that require action in Outreach.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join tasks with	on
accounts	tasks.id = accounts.id tasks.creatorId = accounts.creatorId tasks.completerId = accounts.creatorId tasks.creatorId = accounts.ownerId tasks.completerId = accounts.ownerId tasks.creatorId = accounts.updaterId tasks.completerId = accounts.updaterId
opportunities	tasks.id = opportunities.id tasks.opportunityId = opportunities.id tasks.creatorId = opportunities.creatorId tasks.completerId = opportunities.creatorId tasks.creatorId = opportunities.ownerId tasks.completerId = opportunities.ownerId
prospects	tasks.id = prospects.id tasks.prospectId = prospects.id tasks.creatorId = prospects.creatorId tasks.completerId = prospects.creatorId tasks.creatorId = prospects.updaterId tasks.completerId = prospects.updaterId
sequence_states	tasks.id = sequence_states.id tasks.prospectId = sequence_states.prospectId tasks.sequenceId = sequence_states.sequenceId tasks.sequenceStateId = sequence_states.id tasks.creatorId = sequence_states.creatorId tasks.completerId = sequence_states.creatorId
calls	tasks.callId = calls.id tasks.opportunityId = calls.opportunityId tasks.prospectId = calls.prospectId tasks.sequenceId = calls.sequenceId tasks.sequenceStateId = calls.sequenceStateId tasks.sequenceStepId = calls.sequenceStepId tasks.id = calls.id tasks.creatorId = calls.userId tasks.completerId = calls.userId
events	tasks.mailingId = events.mailingId tasks.prospectId = events.prospectId
mailings	tasks.mailingId = mailings.id tasks.opportunityId = mailings.opportunityId tasks.prospectId = mailings.prospectId tasks.sequenceId = mailings.sequenceId tasks.sequenceStateId = mailings.sequenceStateId tasks.sequenceStepId = mailings.sequenceStepId tasks.id = mailings.id
sequence_steps	tasks.sequenceId = sequence_steps.sequenceId tasks.sequenceStepId = sequence_steps.id tasks.creatorId = sequence_steps.creatorId tasks.completerId = sequence_steps.creatorId tasks.creatorId = sequence_steps.updaterId tasks.completerId = sequence_steps.updaterId
call_dispositions	tasks.creatorId = call_dispositions.creatorId tasks.completerId = call_dispositions.creatorId
call_purposes	tasks.creatorId = call_purposes.creatorId tasks.completerId = call_purposes.creatorId
content_categories	tasks.creatorId = content_categories.creatorId tasks.completerId = content_categories.creatorId
mailboxes	tasks.creatorId = mailboxes.creatorId tasks.completerId = mailboxes.creatorId tasks.creatorId = mailboxes.updaterId tasks.completerId = mailboxes.updaterId tasks.creatorId = mailboxes.userId tasks.completerId = mailboxes.userId
sequence_templates	tasks.creatorId = sequence_templates.creatorId tasks.completerId = sequence_templates.creatorId tasks.creatorId = sequence_templates.updaterId tasks.completerId = sequence_templates.updaterId
sequences	tasks.creatorId = sequences.creatorId tasks.completerId = sequences.creatorId tasks.creatorId = sequences.ownerId tasks.completerId = sequences.ownerId tasks.creatorId = sequences.updaterId tasks.completerId = sequences.updaterId
stages	tasks.creatorId = stages.creatorId tasks.completerId = stages.creatorId tasks.creatorId = stages.updaterId tasks.completerId = stages.updaterId
users	tasks.creatorId = users.creatorId tasks.completerId = users.creatorId tasks.creatorId = users.id tasks.completerId = users.id tasks.creatorId = users.updaterId tasks.completerId = users.updaterId

accountId

INTEGER

action

STRING

autoskipAt

DATE-TIME

callId

INTEGER

compiledSequenceTemplateHtml

STRING

completed

BOOLEAN

completedAt

DATE-TIME

completerId

INTEGER

createdAt

DATE-TIME

creatorId

INTEGER

dueAt

DATE-TIME

INTEGER

mailingId

INTEGER

note

STRING

opportunityAssociation

STRING

opportunityId

INTEGER

ownerId

INTEGER

prospectId

INTEGER

scheduledAt

DATE-TIME

sequenceId

INTEGER

sequenceStateId

INTEGER

sequenceStepId

INTEGER

sequenceTemplateId

INTEGER

state

STRING

stateChangedAt

DATE-TIME

subjectId

INTEGER

taskPriorityId

INTEGER

taskThemeId

INTEGER

taskType

STRING

templateId

INTEGER

updatedAt

DATE-TIME

teams

The teams table contains information about groups of users in Outreach.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

color

STRING

createdAt

DATE-TIME

creatorId

INTEGER

name

STRING

scimExternalId

STRING

scimSource

STRING

updatedAt

DATE-TIME

updaterId

INTEGER

users

The users table contains information about individual users that use the Outreach app.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Outreach API method

Join users with	on
duties	users.duties.id = duties.id
mailboxes	users.mailboxId = mailboxes.id users.creatorId = mailboxes.creatorId users.id = mailboxes.creatorId users.updaterId = mailboxes.creatorId users.creatorId = mailboxes.updaterId users.id = mailboxes.updaterId users.updaterId = mailboxes.updaterId users.creatorId = mailboxes.userId users.id = mailboxes.userId users.updaterId = mailboxes.userId
mailings	users.mailboxId = mailings.mailboxId
accounts	users.creatorId = accounts.creatorId users.id = accounts.creatorId users.updaterId = accounts.creatorId users.creatorId = accounts.ownerId users.id = accounts.ownerId users.updaterId = accounts.ownerId users.creatorId = accounts.updaterId users.id = accounts.updaterId users.updaterId = accounts.updaterId
call_dispositions	users.creatorId = call_dispositions.creatorId users.id = call_dispositions.creatorId users.updaterId = call_dispositions.creatorId
call_purposes	users.creatorId = call_purposes.creatorId users.id = call_purposes.creatorId users.updaterId = call_purposes.creatorId
calls	users.creatorId = calls.userId users.id = calls.userId users.updaterId = calls.userId
content_categories	users.creatorId = content_categories.creatorId users.id = content_categories.creatorId users.updaterId = content_categories.creatorId
opportunities	users.creatorId = opportunities.creatorId users.id = opportunities.creatorId users.updaterId = opportunities.creatorId users.creatorId = opportunities.ownerId users.id = opportunities.ownerId users.updaterId = opportunities.ownerId
prospects	users.creatorId = prospects.creatorId users.id = prospects.creatorId users.updaterId = prospects.creatorId users.creatorId = prospects.updaterId users.id = prospects.updaterId users.updaterId = prospects.updaterId
sequence_states	users.creatorId = sequence_states.creatorId users.id = sequence_states.creatorId users.updaterId = sequence_states.creatorId
sequence_steps	users.creatorId = sequence_steps.creatorId users.id = sequence_steps.creatorId users.updaterId = sequence_steps.creatorId users.creatorId = sequence_steps.updaterId users.id = sequence_steps.updaterId users.updaterId = sequence_steps.updaterId
sequence_templates	users.creatorId = sequence_templates.creatorId users.id = sequence_templates.creatorId users.updaterId = sequence_templates.creatorId users.creatorId = sequence_templates.updaterId users.id = sequence_templates.updaterId users.updaterId = sequence_templates.updaterId
sequences	users.creatorId = sequences.creatorId users.id = sequences.creatorId users.updaterId = sequences.creatorId users.creatorId = sequences.ownerId users.id = sequences.ownerId users.updaterId = sequences.ownerId users.creatorId = sequences.updaterId users.id = sequences.updaterId users.updaterId = sequences.updaterId
stages	users.creatorId = stages.creatorId users.id = stages.creatorId users.updaterId = stages.creatorId users.creatorId = stages.updaterId users.id = stages.updaterId users.updaterId = stages.updaterId
tasks	users.creatorId = tasks.creatorId users.id = tasks.creatorId users.updaterId = tasks.creatorId users.creatorId = tasks.completerId users.id = tasks.completerId users.updaterId = tasks.completerId

accountsViewId

INTEGER

activityNotificationsDisabled

BOOLEAN

bounceWarningEmailEnabled

BOOLEAN

bridgePhone

STRING

bridgePhoneExtension

STRING

callsViewId

INTEGER

controlledTabDefault

STRING

createdAt

DATE-TIME

creatorId

INTEGER

currentSignInAt

DATE-TIME

custom1

STRING

custom2

STRING

custom3

STRING

custom4

STRING

custom5

STRING

dailyDigestEmailEnabled

BOOLEAN

duties

ARRAY

This is a nested data structure:

duty_type: STRING
id: INTEGER
name: STRING

email

STRING

enableVoiceRecordings

BOOLEAN

engagementEmailsEnabled

BOOLEAN

firstName

STRING

INTEGER

inboundBridgePhone

STRING

inboundBridgePhoneExtension

STRING

inboundCallBehavior

STRING

inboundPhoneType

STRING

inboundVoicemailCustomMessageText

STRING

inboundVoicemailMessageTextVoice

STRING

inboundVoicemailPromptType

STRING

kaiaRecordingsViewId

INTEGER

keepBridgePhoneConnected

BOOLEAN

lastName

STRING

lastSignInAt

DATE-TIME

locked

BOOLEAN

mailboxErrorEmailEnabled

BOOLEAN

mailboxId

INTEGER

meetingEngagementNotificationEnabled

BOOLEAN

name

STRING

notificationsEnabled

BOOLEAN

oceClickToDialEverywhere

BOOLEAN

oceGmailToolbar

BOOLEAN

oceGmailTrackingState

STRING

oceSalesforceEmailDecorating

BOOLEAN

oceSalesforcePhoneDecorating

BOOLEAN

oceUniversalTaskFlow

BOOLEAN

oceWindowMode

BOOLEAN

opportunitiesViewId

INTEGER

passwordExpiresAt

DATE-TIME

phoneCountryCode

STRING

phoneNumber

STRING

phoneType

STRING

pluginAlertNotificationEnabled

BOOLEAN

preferredVoiceRegion

STRING

prefersLocalPresence

BOOLEAN

primaryTimezone

STRING

profileId

INTEGER

prospectsViewId

INTEGER

reportsTeamPerfViewId

INTEGER

reportsViewId

INTEGER

roleId

INTEGER

scimExternalId

STRING

scimSource

STRING

secondaryTimezone

STRING

senderNotificationsExcluded

STRING

tasksViewId

INTEGER

teamsViewId

INTEGER

tertiaryTimezone

STRING

textingEmailNotifications

BOOLEAN

title

STRING

unknownReplyEmailEnabled

BOOLEAN

updatedAt

DATE-TIME

updaterId

INTEGER

userGuid

STRING

username

STRING

usersViewId

INTEGER

voicemailNotificationEnabled

BOOLEAN

weeklyDigestEmailEnabled

BOOLEAN

Cette page vous a-t-elle aidé ?

Si vous rencontrez des problèmes sur cette page ou dans son contenu – une faute de frappe, une étape manquante ou une erreur technique – faites-le-nous savoir.

Laissez vos commentaires ici