Outreach integration summary

Stitch’s Outreach integration replicates data using the Outreach REST API. Refer to the Schema section for a list of objects available for replication.

Outreach feature snapshot

A high-level look at Stitch's Outreach (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Released on April 20, 2020

Supported by

Stitch

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-outreach

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Outreach

Step 1: Add Outreach as a Stitch data source

  1. In the Quota Limit field, define the percentage of your standard Outreach API quota Stitch is allowed to use. This is an optional field. Before you define the limit, refer to the Outreach API documentation to learn about your Outreach rate limit.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Outreach integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Outreach’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Outreach integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Set objects to replicate

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Outreach integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Outreach, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


Outreach table reference

accounts

The accounts table contains information about prospective clients in Outreach.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

accounts schema on GitHub

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

id

INTEGER

industry

STRING

linkedInEmployees

INTEGER

linkedInUrl

STRING

locality

STRING

name

STRING

named

BOOLEAN

naturalName

STRING

numberOfEmployees

INTEGER

ownerId

INTEGER

sharingTeamId

STRING

tags

ARRAY

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

call_dispositions schema on GitHub

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

id

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

call_purposes schema on GitHub

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

id

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

calls schema on GitHub

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

id

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

taskId

INTEGER

to

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

content_categories schema on GitHub

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

id

INTEGER

name

STRING

updatedAt

DATE-TIME

duties

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

Replication Method

Full Table

Primary Key

id

Useful links

duties schema on GitHub

Outreach API method

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

dutyType

STRING

id

INTEGER

symbolicName

STRING

events

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

eventAt

Useful links

events schema on GitHub

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

id

INTEGER

mailingId

INTEGER

name

STRING

opportunityId

INTEGER

payload

OBJECT

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

mailboxes schema on GitHub

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

id

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

mailings schema on GitHub

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

id

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

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

opportunities schema on GitHub

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

id

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

touchedAt

DATE-TIME

updatedAt

DATE-TIME

updaterId

INTEGER

personas

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

personas schema on GitHub

Outreach API method

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

createdAt

DATE-TIME

description

STRING

id

INTEGER

name

STRING

updatedAt

DATE-TIME

prospects

The prospects table contains information about your prospects.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

prospects schema on GitHub

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

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

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

id

INTEGER

jobStartDate

DATE-TIME

lastName

STRING

linkedInConnections

INTEGER

linkedInId

STRING

linkedInSlug

STRING

linkedInUrl

STRING

middleName

STRING

mobilePhones

ARRAY

name

STRING

nickname

STRING

occupation

STRING

openCount

INTEGER

optedOut

BOOLEAN

optedOutAt

DATE-TIME

otherPhones

ARRAY

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

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

websiteUrl1

STRING

websiteUrl2

STRING

websiteUrl3

STRING

workPhones

ARRAY

sequence_states

The sequence_states table contains info about currently sequenced prospects.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

sequence_states schema on GitHub

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

id

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

sequence_steps schema on GitHub

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

id

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

id

Useful links

sequence_templates schema on GitHub

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

id

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

sequences schema on GitHub

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

id

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

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

stages schema on GitHub

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

id

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

tasks schema on GitHub

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

id

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

teams schema on GitHub

Outreach API method

color

STRING

createdAt

DATE-TIME

creatorId

INTEGER

id

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

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

users schema on GitHub

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

duty_type

STRING

id

INTEGER

name

STRING

email

STRING

enableVoiceRecordings

BOOLEAN

engagementEmailsEnabled

BOOLEAN

firstName

STRING

id

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


Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.