Outreach

Tables in the Outreach connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	mailings	46	id	Full Refresh, Incremental	updatedAt
2	calls	33	id	Full Refresh, Incremental	updatedAt
3	prospects	246	id	Full Refresh, Incremental	updatedAt
4	stages	9	id	Full Refresh, Incremental	updatedAt
5	mailboxes	52	id	Full Refresh, Incremental	updatedAt
6	accounts	179	id	Full Refresh, Incremental	updatedAt
7	sequence_states	33	id	Full Refresh, Incremental	updatedAt
8	sequences	51	id	Full Refresh, Incremental	updatedAt
9	personas	6	id	Full Refresh, Incremental	updatedAt
10	opportunities	179	id	Full Refresh, Incremental	updatedAt

Table: mailings

No	Column Name	Type	Notes
1	repliedAt	VARCHAR
2	followUpSequence	VARCHAR
3	template	VARCHAR
4	followUpTaskType	VARCHAR
5	clickCount	INTEGER
6	retryAt	VARCHAR
7	references	VARCHAR
8	subject	VARCHAR
9	sequenceStep	VARCHAR
10	bouncedAt	VARCHAR
11	openedAt	VARCHAR
12	createdAt	VARCHAR
13	bodyText	VARCHAR
14	errorBacktrace	VARCHAR
15	errorReason	VARCHAR
16	bodyHtml	VARCHAR
17	id	INTEGER	Primary Key
18	state	VARCHAR
19	clickedAt	VARCHAR
20	mailingType	VARCHAR
21	tasks	VARCHAR
22	updatedAt	VARCHAR	Incremental sync key
23	trackOpens	BOOLEAN
24	notifyThreadCondition	VARCHAR
25	retryCount	INTEGER
26	messageId	VARCHAR
27	opportunity	VARCHAR
28	stateChangedAt	VARCHAR
29	followUpTaskScheduledAt	VARCHAR
30	deliveredAt	VARCHAR
31	overrideSafetySettings	BOOLEAN
32	prospect	VARCHAR
33	sequence	VARCHAR
34	sequenceState	VARCHAR
35	unsubscribedAt	VARCHAR
36	mailboxAddress	VARCHAR
37	mailbox	VARCHAR
38	task	VARCHAR
39	markedAsSpamAt	VARCHAR
40	notifyThreadScheduledAt	VARCHAR
41	recipients	VARCHAR
42	retryInterval	INTEGER
43	openCount	INTEGER
44	trackLinks	BOOLEAN
45	user	VARCHAR
46	scheduledAt	VARCHAR

Table: calls

No	Column Name	Type	Notes
1	note	VARCHAR
2	externalVendor	VARCHAR
3	answeredAt	VARCHAR
4	voicemailRecordingUrl	VARCHAR
5	sequenceStep	VARCHAR
6	uid	VARCHAR
7	createdAt	VARCHAR
8	userCallType	VARCHAR
9	callPurpose	VARCHAR
10	returnedAt	VARCHAR
11	from	VARCHAR
12	id	INTEGER	Primary Key
13	state	VARCHAR
14	outcome	VARCHAR
15	direction	VARCHAR
16	updatedAt	VARCHAR	Incremental sync key
17	completedAt	VARCHAR
18	dialedAt	VARCHAR
19	opportunity	VARCHAR
20	vendorCallId	VARCHAR
21	stateChangedAt	VARCHAR
22	tags	VARCHAR
23	prospect	VARCHAR
24	sequence	VARCHAR
25	sequenceState	VARCHAR
26	callDisposition	VARCHAR
27	phoneNumber	VARCHAR
28	task	VARCHAR
29	sequenceAction	VARCHAR
30	recordingUrl	VARCHAR
31	shouldRecordCall	BOOLEAN
32	to	VARCHAR
33	user	VARCHAR

Table: prospects

No	Column Name	Type	Notes
1	custom80	VARCHAR
2	custom82	VARCHAR
3	custom81	VARCHAR
4	custom84	VARCHAR
5	custom83	VARCHAR
6	custom86	VARCHAR
7	custom85	VARCHAR
8	custom88	VARCHAR
9	custom87	VARCHAR
10	score	DOUBLE
11	specialties	VARCHAR
12	custom89	VARCHAR
13	activeSequenceStates	VARCHAR
14	persona	VARCHAR
15	timeZone	VARCHAR
16	custom71	VARCHAR
17	custom70	VARCHAR
18	custom73	VARCHAR
19	custom72	VARCHAR
20	custom75	VARCHAR
21	custom74	VARCHAR
22	tags	VARCHAR
23	custom77	VARCHAR
24	custom76	VARCHAR
25	custom79	VARCHAR
26	custom78	VARCHAR
27	clickCount	INTEGER
28	mobilePhones	VARCHAR
29	optedOut	BOOLEAN
30	nickname	VARCHAR
31	websiteUrl2	VARCHAR
32	mailings	VARCHAR
33	websiteUrl3	VARCHAR
34	websiteUrl1	VARCHAR
35	custom91	VARCHAR
36	custom90	VARCHAR
37	custom93	VARCHAR
38	custom92	VARCHAR
39	custom95	VARCHAR
40	custom94	VARCHAR
41	custom97	VARCHAR
42	custom96	VARCHAR
43	custom99	VARCHAR
44	custom98	VARCHAR
45	timeZoneIana	VARCHAR
46	stage	VARCHAR
47	calls	VARCHAR
48	openCount	INTEGER
49	angelListUrl	VARCHAR
50	voipPhones	VARCHAR
51	source	VARCHAR
52	stackOverflowUrl	VARCHAR
53	createdAt	VARCHAR
54	school	VARCHAR
55	preferredContact	VARCHAR
56	addressCity	VARCHAR
57	addressCountry	VARCHAR
58	stackOverflowId	VARCHAR
59	jobStartDate	VARCHAR
60	degree	VARCHAR
61	twitterUsername	VARCHAR
62	firstName	VARCHAR
63	name	VARCHAR
64	region	VARCHAR
65	sharingTeamId	VARCHAR
66	trashedAt	VARCHAR
67	addedAt	VARCHAR
68	callOptedOut	BOOLEAN
69	callsOptStatus	VARCHAR
70	title	VARCHAR
71	updater	VARCHAR
72	emails	VARCHAR
73	emailsOptedAt	VARCHAR
74	availableAt	VARCHAR
75	company	VARCHAR
76	linkedInId	VARCHAR
77	owner	VARCHAR
78	sequenceStates	VARCHAR
79	custom109	VARCHAR
80	custom108	VARCHAR
81	timeZoneInferred	VARCHAR
82	custom105	VARCHAR
83	custom104	VARCHAR
84	externalId	VARCHAR
85	custom107	VARCHAR
86	custom106	VARCHAR
87	custom101	VARCHAR
88	custom100	VARCHAR
89	custom103	VARCHAR
90	custom102	VARCHAR
91	githubUsername	VARCHAR
92	custom110	VARCHAR
93	addressStreet	VARCHAR
94	otherPhones	VARCHAR
95	middleName	VARCHAR
96	occupation	VARCHAR
97	custom119	VARCHAR
98	custom116	VARCHAR
99	custom115	VARCHAR
100	custom118	VARCHAR
101	custom117	VARCHAR
102	custom112	VARCHAR
103	custom111	VARCHAR
104	custom114	VARCHAR
105	custom113	VARCHAR
106	custom121	VARCHAR
107	custom120	VARCHAR
108	id	INTEGER	Primary Key
109	tasks	VARCHAR
110	custom127	VARCHAR
111	custom126	VARCHAR
112	custom129	VARCHAR
113	custom128	VARCHAR
114	custom123	VARCHAR
115	homePhones	VARCHAR
116	custom122	VARCHAR
117	custom125	VARCHAR
118	custom124	VARCHAR
119	custom130	VARCHAR
120	custom132	VARCHAR
121	custom131	VARCHAR
122	lastName	VARCHAR
123	gender	VARCHAR
124	touchedAt	VARCHAR
125	custom138	VARCHAR
126	custom137	VARCHAR
127	custom139	VARCHAR
128	custom134	VARCHAR
129	custom133	VARCHAR
130	externalOwner	VARCHAR
131	custom136	VARCHAR
132	custom20	VARCHAR
133	phoneNumbers	VARCHAR
134	custom135	VARCHAR
135	custom141	VARCHAR
136	custom22	VARCHAR
137	custom140	VARCHAR
138	custom21	VARCHAR
139	custom143	VARCHAR
140	custom24	VARCHAR
141	custom142	VARCHAR
142	custom23	VARCHAR
143	custom26	VARCHAR
144	custom25	VARCHAR
145	custom28	VARCHAR
146	custom27	VARCHAR
147	custom29	VARCHAR
148	creator	VARCHAR
149	addressZip	VARCHAR
150	custom149	VARCHAR
151	custom148	VARCHAR
152	dateOfBirth	VARCHAR
153	custom145	VARCHAR
154	custom144	VARCHAR
155	opportunities	VARCHAR
156	custom147	VARCHAR
157	custom146	VARCHAR
158	custom11	VARCHAR
159	custom10	VARCHAR
160	custom13	VARCHAR
161	custom12	VARCHAR
162	custom15	VARCHAR
163	optedOutAt	VARCHAR
164	custom14	VARCHAR
165	engagedAt	VARCHAR
166	custom150	VARCHAR
167	custom17	VARCHAR
168	custom16	VARCHAR
169	custom19	VARCHAR
170	custom18	VARCHAR
171	engagedScore	DOUBLE
172	twitterUrl	VARCHAR
173	custom40	VARCHAR
174	custom42	VARCHAR
175	custom41	VARCHAR
176	custom44	VARCHAR
177	custom43	VARCHAR
178	linkedInConnections	INTEGER
179	custom46	VARCHAR
180	custom45	VARCHAR
181	personalNote2	VARCHAR
182	emailAddresses	VARCHAR
183	custom48	VARCHAR
184	custom47	VARCHAR
185	custom49	VARCHAR
186	opportunityProspectRoles	VARCHAR
187	eventName	VARCHAR
188	addressStreet2	VARCHAR
189	linkedInSlug	VARCHAR
190	updatedAt	VARCHAR	Incremental sync key
191	contactHistogram	VARCHAR
192	linkedInUrl	VARCHAR
193	personalNote1	VARCHAR
194	custom31	VARCHAR
195	quoraUrl	VARCHAR
196	custom30	VARCHAR
197	custom33	VARCHAR
198	custom32	VARCHAR
199	custom35	VARCHAR
200	custom34	VARCHAR
201	custom37	VARCHAR
202	custom36	VARCHAR
203	custom39	VARCHAR
204	custom38	VARCHAR
205	favorites	VARCHAR
206	githubUrl	VARCHAR
207	callsOptedAt	VARCHAR
208	custom60	VARCHAR
209	custom62	VARCHAR
210	emailsOptStatus	VARCHAR
211	custom61	VARCHAR
212	custom64	VARCHAR
213	custom63	VARCHAR
214	custom66	VARCHAR
215	custom65	VARCHAR
216	custom68	VARCHAR
217	custom9	VARCHAR
218	facebookUrl	VARCHAR
219	custom67	VARCHAR
220	custom69	VARCHAR
221	custom3	VARCHAR
222	custom4	VARCHAR
223	custom1	VARCHAR
224	custom2	VARCHAR
225	custom7	VARCHAR
226	custom8	VARCHAR
227	custom6	VARCHAR
228	addressState	VARCHAR
229	custom51	VARCHAR
230	custom50	VARCHAR
231	custom53	VARCHAR
232	custom52	VARCHAR
233	externalSource	VARCHAR
234	custom55	VARCHAR
235	custom54	VARCHAR
236	custom57	VARCHAR
237	googlePlusUrl	VARCHAR
238	replyCount	INTEGER
239	custom56	VARCHAR
240	custom59	VARCHAR
241	graduationDate	VARCHAR
242	custom58	VARCHAR
243	workPhones	VARCHAR
244	emailOptedOut	BOOLEAN
245	campaignName	VARCHAR
246	account	VARCHAR

Table: stages

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	creator	VARCHAR
3	color	VARCHAR
4	prospects	VARCHAR
5	name	VARCHAR
6	id	INTEGER	Primary Key
7	order	VARCHAR
8	updatedAt	VARCHAR	Incremental sync key
9	updater	VARCHAR

Table: mailboxes

No	Column Name	Type	Notes
1	smtpPort	INTEGER
2	ewsEndpoint	VARCHAR
3	sendRequiresSync	BOOLEAN
4	prospectEmailExclusions	VARCHAR
5	createdAt	VARCHAR
6	maxMailingsPerDay	INTEGER
7	syncFinishedAt	VARCHAR
8	exchangeVersion	VARCHAR
9	sendErroredAt	VARCHAR
10	syncMethod	VARCHAR
11	id	INTEGER	Primary Key
12	sendPeriod	INTEGER
13	syncActiveFrequency	INTEGER
14	updatedAt	VARCHAR	Incremental sync key
15	smtpUsername	VARCHAR
16	optOutMessage	VARCHAR
17	sendMaxRetries	INTEGER
18	emailSignature	VARCHAR
19	imapHost	VARCHAR
20	mailAliases	VARCHAR
21	imapSsl	BOOLEAN
22	maxEmailsPerDay	INTEGER
23	syncErroredAt	VARCHAR
24	optOutSignature	VARCHAR
25	sendgridWebhookUrl	VARCHAR
26	ewsSslVerifyMode	INTEGER
27	imapPort	INTEGER
28	sendPermanentErrorAt	VARCHAR
29	authId	INTEGER
30	providerType	VARCHAR
31	updater	VARCHAR
32	sendSuccessAt	VARCHAR
33	sendMethod	VARCHAR
34	emailProvider	VARCHAR
35	smtpSsl	BOOLEAN
36	providerId	INTEGER
37	syncPermanentErrorAt	VARCHAR
38	maxMailingsPerWeek	INTEGER
39	syncDisabled	BOOLEAN
40	email	VARCHAR
41	creator	VARCHAR
42	mailings	VARCHAR
43	editable	BOOLEAN
44	syncOutreachFolder	BOOLEAN
45	syncPassiveFrequency	INTEGER
46	syncSuccessAt	VARCHAR
47	userId	INTEGER
48	smtpHost	VARCHAR
49	sendDisabled	BOOLEAN
50	sendThreshold	INTEGER
51	user	VARCHAR
52	username	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	named	BOOLEAN
2	custom119	VARCHAR
3	linkedInEmployees	INTEGER
4	custom116	VARCHAR
5	custom80	VARCHAR
6	custom115	VARCHAR
7	custom118	VARCHAR
8	custom82	VARCHAR
9	custom117	VARCHAR
10	custom81	VARCHAR
11	custom112	VARCHAR
12	custom84	VARCHAR
13	custom111	VARCHAR
14	custom83	VARCHAR
15	custom114	VARCHAR
16	custom86	VARCHAR
17	custom113	VARCHAR
18	custom85	VARCHAR
19	custom88	VARCHAR
20	custom87	VARCHAR
21	custom121	VARCHAR
22	custom120	VARCHAR
23	custom89	VARCHAR
24	id	INTEGER	Primary Key
25	tasks	VARCHAR
26	custom127	VARCHAR
27	locality	VARCHAR
28	custom126	VARCHAR
29	custom129	VARCHAR
30	custom71	VARCHAR
31	custom128	VARCHAR
32	custom70	VARCHAR
33	custom123	VARCHAR
34	custom73	VARCHAR
35	custom122	VARCHAR
36	custom72	VARCHAR
37	custom125	VARCHAR
38	custom75	VARCHAR
39	custom124	VARCHAR
40	custom74	VARCHAR
41	numberOfEmployees	INTEGER
42	tags	VARCHAR
43	custom130	VARCHAR
44	custom77	VARCHAR
45	custom76	VARCHAR
46	foundedAt	VARCHAR
47	custom132	VARCHAR
48	custom79	VARCHAR
49	custom131	VARCHAR
50	custom78	VARCHAR
51	domain	VARCHAR
52	touchedAt	VARCHAR
53	custom138	VARCHAR
54	custom137	VARCHAR
55	industry	VARCHAR
56	custom139	VARCHAR
57	custom134	VARCHAR
58	custom133	VARCHAR
59	customId	VARCHAR
60	custom136	VARCHAR
61	custom20	VARCHAR
62	custom135	VARCHAR
63	custom141	VARCHAR
64	custom22	VARCHAR
65	custom140	VARCHAR
66	custom21	VARCHAR
67	custom143	VARCHAR
68	custom24	VARCHAR
69	custom142	VARCHAR
70	custom23	VARCHAR
71	custom26	VARCHAR
72	custom25	VARCHAR
73	websiteUrl	VARCHAR
74	custom28	VARCHAR
75	custom27	VARCHAR
76	custom29	VARCHAR
77	buyerIntentScore	DOUBLE
78	creator	VARCHAR
79	custom149	VARCHAR
80	custom91	VARCHAR
81	custom148	VARCHAR
82	custom90	VARCHAR
83	custom93	VARCHAR
84	custom92	VARCHAR
85	custom145	VARCHAR
86	custom95	VARCHAR
87	custom144	VARCHAR
88	custom94	VARCHAR
89	custom147	VARCHAR
90	custom97	VARCHAR
91	custom146	VARCHAR
92	custom96	VARCHAR
93	custom11	VARCHAR
94	custom99	VARCHAR
95	custom10	VARCHAR
96	custom98	VARCHAR
97	custom13	VARCHAR
98	custom12	VARCHAR
99	naturalName	VARCHAR
100	custom15	VARCHAR
101	custom14	VARCHAR
102	custom150	VARCHAR
103	custom17	VARCHAR
104	custom16	VARCHAR
105	custom19	VARCHAR
106	custom18	VARCHAR
107	custom40	VARCHAR
108	custom42	VARCHAR
109	custom41	VARCHAR
110	custom44	VARCHAR
111	createdAt	VARCHAR
112	custom43	VARCHAR
113	custom46	VARCHAR
114	custom45	VARCHAR
115	custom48	VARCHAR
116	custom47	VARCHAR
117	custom49	VARCHAR
118	updatedAt	VARCHAR	Incremental sync key
119	linkedInUrl	VARCHAR
120	custom31	VARCHAR
121	custom30	VARCHAR
122	custom33	VARCHAR
123	custom32	VARCHAR
124	custom35	VARCHAR
125	custom34	VARCHAR
126	followers	INTEGER
127	custom37	VARCHAR
128	custom36	VARCHAR
129	custom39	VARCHAR
130	custom38	VARCHAR
131	name	VARCHAR
132	sharingTeamId	VARCHAR
133	trashedAt	VARCHAR
134	prospects	VARCHAR
135	description	VARCHAR
136	custom60	VARCHAR
137	custom62	VARCHAR
138	custom61	VARCHAR
139	custom64	VARCHAR
140	custom63	VARCHAR
141	updater	VARCHAR
142	custom66	VARCHAR
143	custom65	VARCHAR
144	custom68	VARCHAR
145	custom9	VARCHAR
146	custom67	VARCHAR
147	custom69	VARCHAR
148	custom3	VARCHAR
149	custom4	VARCHAR
150	custom1	VARCHAR
151	custom2	VARCHAR
152	custom7	VARCHAR
153	custom8	VARCHAR
154	custom5	VARCHAR
155	custom6	VARCHAR
156	owner	VARCHAR
157	custom109	VARCHAR
158	companyType	VARCHAR
159	custom108	VARCHAR
160	custom105	VARCHAR
161	custom104	VARCHAR
162	custom107	VARCHAR
163	custom106	VARCHAR
164	custom101	VARCHAR
165	custom51	VARCHAR
166	custom100	VARCHAR
167	custom50	VARCHAR
168	custom103	VARCHAR
169	custom53	VARCHAR
170	custom102	VARCHAR
171	custom52	VARCHAR
172	externalSource	VARCHAR
173	custom55	VARCHAR
174	custom54	VARCHAR
175	custom110	VARCHAR
176	custom57	VARCHAR
177	custom56	VARCHAR
178	custom59	VARCHAR
179	custom58	VARCHAR

Table: sequence_states

No	Column Name	Type	Notes
1	repliedAt	VARCHAR
2	clickCount	INTEGER
3	sequenceStep	VARCHAR
4	scheduleCount	INTEGER
5	createdAt	VARCHAR
6	activeAt	VARCHAR
7	neutralReplyCount	INTEGER
8	deliverCount	INTEGER
9	bounceCount	INTEGER
10	pauseReason	VARCHAR
11	errorReason	VARCHAR
12	id	INTEGER	Primary Key
13	state	VARCHAR
14	tasks	VARCHAR
15	updatedAt	VARCHAR	Incremental sync key
16	callCompletedAt	VARCHAR
17	creator	VARCHAR
18	mailings	VARCHAR
19	opportunity	VARCHAR
20	stateChangedAt	VARCHAR
21	optOutCount	INTEGER
22	negativeReplyCount	INTEGER
23	prospect	VARCHAR
24	sequence	VARCHAR
25	replyCount	INTEGER
26	mailbox	VARCHAR
27	calls	VARCHAR
28	openCount	INTEGER
29	positiveReplyCount	INTEGER
30	activeStepMailings	VARCHAR
31	failureCount	INTEGER
32	account	VARCHAR
33	activeStepTasks	VARCHAR

Table: sequences

No	Column Name	Type	Notes
1	primaryReplyPauseDuration	INTEGER
2	secondaryReplyPauseDuration	INTEGER
3	throttleMaxAddsPerDay	INTEGER
4	sequenceSteps	VARCHAR
5	automationPercentage	DOUBLE
6	lockedAt	VARCHAR
7	enabledAt	VARCHAR
8	shareType	VARCHAR
9	createdAt	VARCHAR
10	neutralReplyCount	INTEGER
11	finishOnReply	BOOLEAN
12	id	INTEGER	Primary Key
13	locked	BOOLEAN
14	tasks	VARCHAR
15	updatedAt	VARCHAR	Incremental sync key
16	durationInDays	INTEGER
17	ruleset	VARCHAR
18	tags	VARCHAR
19	negativeReplyCount	INTEGER
20	name	VARCHAR
21	numRepliedProspects	INTEGER
22	failureCount	INTEGER
23	throttleCapacity	INTEGER
24	transactional	BOOLEAN
25	sequenceType	VARCHAR
26	clickCount	INTEGER
27	description	VARCHAR
28	scheduleIntervalType	VARCHAR
29	scheduleCount	INTEGER
30	enabled	BOOLEAN
31	updater	VARCHAR
32	numContactedProspects	INTEGER
33	deliverCount	INTEGER
34	contentCategoryMemberships	VARCHAR
35	bounceCount	INTEGER
36	throttlePaused	BOOLEAN
37	owner	VARCHAR
38	creator	VARCHAR
39	sequenceStates	VARCHAR
40	mailings	VARCHAR
41	secondaryReplyAction	VARCHAR
42	optOutCount	INTEGER
43	maxActivations	INTEGER
44	replyCount	INTEGER
45	lastUsedAt	VARCHAR
46	calls	VARCHAR
47	sequenceStepCount	INTEGER
48	openCount	INTEGER
49	throttlePausedAt	VARCHAR
50	positiveReplyCount	INTEGER
51	primaryReplyAction	VARCHAR

Table: personas

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	prospects	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	id	INTEGER	Primary Key
6	updatedAt	VARCHAR	Incremental sync key

Table: opportunities

No	Column Name	Type	Notes
1	currencyType	VARCHAR
2	custom119	VARCHAR
3	custom116	VARCHAR
4	custom80	VARCHAR
5	custom115	VARCHAR
6	custom118	VARCHAR
7	custom82	VARCHAR
8	custom117	VARCHAR
9	custom81	VARCHAR
10	custom112	VARCHAR
11	custom84	VARCHAR
12	custom111	VARCHAR
13	custom83	VARCHAR
14	custom114	VARCHAR
15	custom86	VARCHAR
16	custom113	VARCHAR
17	custom85	VARCHAR
18	externalCreatedAt	VARCHAR
19	mapStatus	VARCHAR
20	custom88	VARCHAR
21	custom87	VARCHAR
22	custom121	VARCHAR
23	custom120	VARCHAR
24	custom89	VARCHAR
25	id	INTEGER	Primary Key
26	probability	INTEGER
27	custom127	VARCHAR
28	custom126	VARCHAR
29	custom129	VARCHAR
30	custom71	VARCHAR
31	custom128	VARCHAR
32	custom70	VARCHAR
33	custom123	VARCHAR
34	custom73	VARCHAR
35	custom122	VARCHAR
36	custom72	VARCHAR
37	custom125	VARCHAR
38	custom75	VARCHAR
39	custom124	VARCHAR
40	custom74	VARCHAR
41	tags	VARCHAR
42	custom130	VARCHAR
43	custom77	VARCHAR
44	custom76	VARCHAR
45	custom132	VARCHAR
46	custom79	VARCHAR
47	custom131	VARCHAR
48	custom78	VARCHAR
49	mapNextSteps	VARCHAR
50	touchedAt	VARCHAR
51	custom138	VARCHAR
52	custom137	VARCHAR
53	custom139	VARCHAR
54	custom134	VARCHAR
55	custom133	VARCHAR
56	custom136	VARCHAR
57	custom20	VARCHAR
58	custom135	VARCHAR
59	custom141	VARCHAR
60	custom22	VARCHAR
61	opportunityStage	VARCHAR
62	custom140	VARCHAR
63	custom21	VARCHAR
64	custom143	VARCHAR
65	custom24	VARCHAR
66	custom142	VARCHAR
67	custom23	VARCHAR
68	custom26	VARCHAR
69	custom25	VARCHAR
70	custom28	VARCHAR
71	custom27	VARCHAR
72	custom29	VARCHAR
73	creator	VARCHAR
74	custom149	VARCHAR
75	custom91	VARCHAR
76	custom148	VARCHAR
77	custom90	VARCHAR
78	custom93	VARCHAR
79	custom92	VARCHAR
80	custom145	VARCHAR
81	custom95	VARCHAR
82	custom144	VARCHAR
83	custom94	VARCHAR
84	custom147	VARCHAR
85	custom97	VARCHAR
86	custom146	VARCHAR
87	custom96	VARCHAR
88	custom11	VARCHAR
89	custom99	VARCHAR
90	opportunityType	VARCHAR
91	custom10	VARCHAR
92	custom98	VARCHAR
93	custom13	VARCHAR
94	custom12	VARCHAR
95	custom15	VARCHAR
96	stage	VARCHAR
97	custom14	VARCHAR
98	custom150	VARCHAR
99	custom17	VARCHAR
100	custom16	VARCHAR
101	custom19	VARCHAR
102	custom18	VARCHAR
103	custom40	VARCHAR
104	custom42	VARCHAR
105	custom41	VARCHAR
106	custom44	VARCHAR
107	createdAt	VARCHAR
108	custom43	VARCHAR
109	custom46	VARCHAR
110	custom45	VARCHAR
111	custom48	VARCHAR
112	custom47	VARCHAR
113	custom49	VARCHAR
114	mapNumberOfOverdueTasks	VARCHAR
115	updatedAt	VARCHAR	Incremental sync key
116	mapLink	VARCHAR
117	custom31	VARCHAR
118	custom30	VARCHAR
119	custom33	VARCHAR
120	custom32	VARCHAR
121	custom35	VARCHAR
122	custom34	VARCHAR
123	custom37	VARCHAR
124	custom36	VARCHAR
125	custom39	VARCHAR
126	custom38	VARCHAR
127	name	VARCHAR
128	nextStep	VARCHAR
129	sharingTeamId	VARCHAR
130	prospectingRepId	VARCHAR
131	prospects	VARCHAR
132	description	VARCHAR
133	custom60	VARCHAR
134	custom62	VARCHAR
135	healthScore	INTEGER
136	custom61	VARCHAR
137	custom64	VARCHAR
138	custom63	VARCHAR
139	updater	VARCHAR
140	custom66	VARCHAR
141	custom65	VARCHAR
142	custom68	VARCHAR
143	custom9	VARCHAR
144	custom67	VARCHAR
145	custom69	VARCHAR
146	custom3	VARCHAR
147	custom4	VARCHAR
148	custom1	VARCHAR
149	custom2	VARCHAR
150	custom7	VARCHAR
151	custom8	VARCHAR
152	custom5	VARCHAR
153	custom6	VARCHAR
154	owner	VARCHAR
155	amount	INTEGER
156	custom109	VARCHAR
157	custom108	VARCHAR
158	custom105	VARCHAR
159	custom104	VARCHAR
160	custom107	VARCHAR
161	custom106	VARCHAR
162	custom101	VARCHAR
163	custom51	VARCHAR
164	custom100	VARCHAR
165	custom50	VARCHAR
166	custom103	VARCHAR
167	custom53	VARCHAR
168	custom102	VARCHAR
169	custom52	VARCHAR
170	closeDate	VARCHAR
171	custom55	VARCHAR
172	custom54	VARCHAR
173	custom110	VARCHAR
174	custom57	VARCHAR
175	healthCategory	VARCHAR
176	custom56	VARCHAR
177	custom59	VARCHAR
178	custom58	VARCHAR
179	account	VARCHAR

External Resources

• Here

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.