Omnisend

Tables in the Omnisend connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	carts	10		Full Refresh
2	campaigns	19		Full Refresh
3	orders	33		Full Refresh
4	contacts	24		Full Refresh
5	products	14		Full Refresh

Table: carts

No	Column Name	Type	Notes
1	cartSum	INTEGER
2	createdAt	VARCHAR
3	contactID	VARCHAR
4	phone	VARCHAR
5	cartID	VARCHAR
6	currency	VARCHAR
7	cartRecoveryUrl	VARCHAR
8	email	VARCHAR
9	updatedAt	VARCHAR
10	products	VARCHAR

Table: campaigns

No	Column Name	Type	Notes
1	endDate	VARCHAR
2	campaignID	VARCHAR
3	subject	VARCHAR
4	complained	INTEGER
5	opened	INTEGER
6	type	VARCHAR
7	bounced	INTEGER
8	sent	INTEGER
9	clicked	INTEGER
10	url	VARCHAR
11	segments	VARCHAR
12	createdAt	VARCHAR
13	unsubscribed	INTEGER
14	allSubscribers	BOOLEAN
15	name	VARCHAR
16	fromName	VARCHAR
17	startDate	VARCHAR
18	status	VARCHAR
19	updatedAt	VARCHAR

Table: orders

No	Column Name	Type	Notes
1	lastName	VARCHAR
2	orderNumber	INTEGER
3	contactID	VARCHAR
4	customFields	VARCHAR
5	cartID	VARCHAR
6	source	VARCHAR
7	orderSum	INTEGER
8	discountSum	INTEGER
9	fulfillmentStatus	VARCHAR
10	products	VARCHAR
11	orderUrl	VARCHAR
12	createdAt	VARCHAR
13	courierTitle	VARCHAR
14	discountType	VARCHAR
15	currency	VARCHAR
16	email	VARCHAR
17	paymentStatus	VARCHAR
18	updatedAt	VARCHAR
19	contactNote	VARCHAR
20	taxSum	INTEGER
21	orderID	VARCHAR
22	shippingMethod	VARCHAR
23	trackingCode	VARCHAR
24	tags	VARCHAR
25	firstName	VARCHAR
26	shippingSum	INTEGER
27	discountCode	VARCHAR
28	courierUrl	VARCHAR
29	subTotalSum	INTEGER
30	paymentMethod	VARCHAR
31	shippingAddress	VARCHAR
32	billingAddress	VARCHAR
33	discountValue	INTEGER

Table: contacts

No	Column Name	Type	Notes
1	lastName	VARCHAR
2	country	VARCHAR
3	address	VARCHAR
4	birthdate	VARCHAR
5	gender	VARCHAR
6	contactID	VARCHAR
7	city	VARCHAR
8	identifiers	VARCHAR
9	postalCode	VARCHAR
10	opened	INTEGER
11	clicked	INTEGER
12	sent	INTEGER
13	tags	VARCHAR
14	segments	VARCHAR
15	createdAt	VARCHAR
16	firstName	VARCHAR
17	optIns	VARCHAR
18	phoneNumber	VARCHAR
19	phone	VARCHAR
20	countryCode	VARCHAR
21	statuses	VARCHAR
22	state	VARCHAR
23	email	VARCHAR
24	status	VARCHAR

Table: products

No	Column Name	Type	Notes
1	images	VARCHAR
2	productID	VARCHAR
3	description	VARCHAR
4	variants	VARCHAR
5	title	VARCHAR
6	type	VARCHAR
7	tags	VARCHAR
8	createdAt	VARCHAR
9	categoryIDs	VARCHAR
10	vendor	VARCHAR
11	currency	VARCHAR
12	productUrl	VARCHAR
13	status	VARCHAR
14	updatedAt	VARCHAR

External Resources

• Omnisend Api

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.