Vitally

Tables in the Vitally connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	notes	16		Full Refresh		API Reference
2	organizations	15
3	nps_responses	10		Full Refresh
4	accounts	25		Full Refresh		API Reference
5	conversations	5		Full Refresh		API Reference
6	admins	4		Full Refresh		API Reference
7	users	21		Full Refresh		API Reference
8	tasks	21		Full Refresh		API Reference

Table: notes

No	Column Name	Type	Notes
1	note	VARCHAR
2	traits	VARCHAR
3	author	VARCHAR
4	externalId	VARCHAR
5	authorId	VARCHAR
6	organizationId	VARCHAR
7	createdAt	VARCHAR
8	accountId	VARCHAR
9	noteDate	VARCHAR
10	organization	VARCHAR
11	id	VARCHAR
12	tag	VARCHAR
13	category	VARCHAR
14	categoryId	VARCHAR
15	account	VARCHAR
16	updatedAt	VARCHAR

Table: organizations

No	Column Name	Type	Notes
1	traits	VARCHAR
2	externalId	VARCHAR
3	usersCount	INTEGER
4	mrr	DOUBLE
5	accountOwnerId	VARCHAR
6	accountExecutiveId	VARCHAR
7	churnedAt	VARCHAR
8	csmId	VARCHAR
9	createdAt	VARCHAR
10	trialEndDate	VARCHAR
11	name	VARCHAR
12	nextRenewalDate	VARCHAR
13	id	VARCHAR
14	keyRoles	VARCHAR
15	updatedAt	VARCHAR

Table: nps_responses

No	Column Name	Type	Notes
1	feedback	VARCHAR
2	createdAt	VARCHAR
3	score	DOUBLE
4	externalId	VARCHAR
5	id	VARCHAR
6	respondedAt	VARCHAR
7	userId	VARCHAR
8	user	VARCHAR
9	dismissedAt	VARCHAR
10	updatedAt	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	traits	VARCHAR
2	npsPromoterCount	INTEGER
3	healthScore	DOUBLE
4	accountExecutiveId	VARCHAR
5	npsDetractorCount	INTEGER
6	segments	VARCHAR
7	organizationId	VARCHAR
8	csmId	VARCHAR
9	createdAt	VARCHAR
10	lastInboundMessageTimestamp	VARCHAR
11	lastOutboundMessageTimestamp	VARCHAR
12	npsScore	DOUBLE
13	nextRenewalDate	VARCHAR
14	id	VARCHAR
15	updatedAt	VARCHAR
16	externalId	VARCHAR
17	usersCount	INTEGER
18	mrr	DOUBLE
19	accountOwnerId	VARCHAR
20	firstSeenTimestamp	VARCHAR
21	churnedAt	VARCHAR
22	lastSeenTimestamp	VARCHAR
23	npsPassiveCount	INTEGER
24	trialEndDate	VARCHAR
25	name	VARCHAR

Table: conversations

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	subject	VARCHAR
3	externalId	VARCHAR
4	id	VARCHAR
5	updatedAt	VARCHAR

Table: admins

No	Column Name	Type	Notes
1	licenseStatus	VARCHAR
2	name	VARCHAR
3	id	VARCHAR
4	email	VARCHAR

Table: users

No	Column Name	Type	Notes
1	traits	VARCHAR
2	npsLastRespondedAt	VARCHAR
3	npsLastScore	DOUBLE
4	externalId	VARCHAR
5	unsubscribedFromConversations	BOOLEAN
6	avatar	VARCHAR
7	deactivatedAt	VARCHAR
8	npsLastFeedback	VARCHAR
9	segments	VARCHAR
10	createdAt	VARCHAR
11	lastSeenTimestamp	VARCHAR
12	joinDate	VARCHAR
13	lastInboundMessageTimestamp	VARCHAR
14	lastOutboundMessageTimestamp	VARCHAR
15	organizations	VARCHAR
16	name	VARCHAR
17	id	VARCHAR
18	accounts	VARCHAR
19	email	VARCHAR
20	firstKnown	VARCHAR
21	updatedAt	VARCHAR

Table: tasks

No	Column Name	Type	Notes
1	assignedToId	VARCHAR
2	completedAt	VARCHAR
3	projects	VARCHAR
4	traits	VARCHAR
5	dueDate	VARCHAR
6	externalId	VARCHAR
7	description	VARCHAR
8	completedById	VARCHAR
9	assignedTo	VARCHAR
10	organizationId	VARCHAR
11	createdAt	VARCHAR
12	accountId	VARCHAR
13	organization	VARCHAR
14	name	VARCHAR
15	id	VARCHAR
16	tag	VARCHAR
17	category	VARCHAR
18	account	VARCHAR
19	categoryId	VARCHAR
20	completedBy	VARCHAR
21	updatedAt	VARCHAR

External Resources

• Vitally Api
• Nps Responses
• Vitally Docs

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.