Square

Tables in the Square connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	payments	23		Incremental, Full Refresh	created_at	API Reference
2	team_member_wages	4		Full Refresh	id
3	taxes	8		Incremental, Full Refresh	updated_at	API Reference
4	refunds	10		Incremental, Full Refresh	created_at	API Reference
5	discounts	8		Incremental, Full Refresh	updated_at	API Reference
6	modifier_list	7		Incremental, Full Refresh	updated_at
7	team_members	11		Full Refresh	id
8	shifts	13		Full Refresh	id	API Reference
9	locations	22		Full Refresh	id	API Reference
10	orders	23		Incremental, Full Refresh	updated_at	API Reference
11	categories	7		Incremental, Full Refresh	updated_at	API Reference
12	customers	17		Full Refresh	id	API Reference
13	items	10		Incremental, Full Refresh	updated_at	API Reference

Table: payments

No	Column Name	Type	Notes
1	card_details	VARCHAR
2	note	VARCHAR
3	delay_action	VARCHAR
4	created_at	VARCHAR	Incremental sync key
5	processing_fee	VARCHAR
6	amount_money	VARCHAR
7	source_type	VARCHAR
8	location_id	VARCHAR
9	delayed_until	VARCHAR
10	receipt_number	VARCHAR
11	receipt_url	VARCHAR
12	updated_at	VARCHAR
13	version_token	VARCHAR
14	employee_id	VARCHAR
15	refund_ids	VARCHAR
16	id	VARCHAR
17	total_money	VARCHAR
18	refunded_money	VARCHAR
19	delay_duration	VARCHAR
20	order_id	VARCHAR
21	approved_money	VARCHAR
22	status	VARCHAR
23	risk_evaluation	VARCHAR

Table: team_member_wages

No	Column Name	Type	Notes
1	hourly_rate	VARCHAR
2	id	VARCHAR	Incremental sync key
3	team_member_id	VARCHAR
4	title	VARCHAR

Table: taxes

No	Column Name	Type	Notes
1	present_at_all_locations	BOOLEAN
2	is_deleted	BOOLEAN
3	updated_at	VARCHAR	Incremental sync key
4	absent_at_location_ids	VARCHAR
5	id	VARCHAR
6	type	VARCHAR
7	version	INTEGER
8	tax_data	VARCHAR

Table: refunds

No	Column Name	Type	Notes
1	reason	VARCHAR
2	updated_at	VARCHAR
3	payment_id	VARCHAR
4	created_at	VARCHAR	Incremental sync key
5	processing_fee	VARCHAR
6	amount_money	VARCHAR
7	id	VARCHAR
8	order_id	VARCHAR
9	location_id	VARCHAR
10	status	VARCHAR

Table: discounts

No	Column Name	Type	Notes
1	present_at_all_locations	BOOLEAN
2	is_deleted	BOOLEAN
3	updated_at	VARCHAR	Incremental sync key
4	discount_data	VARCHAR
5	id	VARCHAR
6	type	VARCHAR
7	version	INTEGER
8	present_at_location_ids	VARCHAR

Table: modifier_list

No	Column Name	Type	Notes
1	present_at_all_locations	BOOLEAN
2	is_deleted	BOOLEAN
3	updated_at	VARCHAR	Incremental sync key
4	modifier_list_data	VARCHAR
5	id	VARCHAR
6	type	VARCHAR
7	version	INTEGER

Table: team_members

No	Column Name	Type	Notes
1	email_address	VARCHAR
2	updated_at	VARCHAR
3	reference_id	VARCHAR
4	is_owner	BOOLEAN
5	created_at	VARCHAR
6	assigned_locations	VARCHAR
7	phone_number	VARCHAR
8	id	VARCHAR	Incremental sync key
9	given_name	VARCHAR
10	family_name	VARCHAR
11	status	VARCHAR

Table: shifts

No	Column Name	Type	Notes
1	end_at	VARCHAR
2	breaks	VARCHAR
3	timezone	VARCHAR
4	created_at	VARCHAR
5	start_at	VARCHAR
6	version	INTEGER
7	location_id	VARCHAR
8	updated_at	VARCHAR
9	employee_id	VARCHAR
10	id	VARCHAR	Incremental sync key
11	team_member_id	VARCHAR
12	wage	VARCHAR
13	status	VARCHAR

Table: locations

No	Column Name	Type	Notes
1	business_hours	VARCHAR
2	country	VARCHAR
3	business_name	VARCHAR
4	facebook_url	VARCHAR
5	address	VARCHAR
6	capabilities	VARCHAR
7	timezone	VARCHAR
8	twitter_username	VARCHAR
9	created_at	VARCHAR
10	description	VARCHAR
11	merchant_id	VARCHAR
12	type	VARCHAR
13	mcc	VARCHAR
14	language_code	VARCHAR
15	website_url	VARCHAR
16	name	VARCHAR
17	business_email	VARCHAR
18	currency	VARCHAR
19	phone_number	VARCHAR
20	id	VARCHAR	Incremental sync key
21	instagram_username	VARCHAR
22	status	VARCHAR

Table: orders

No	Column Name	Type	Notes
1	total_tax_money	VARCHAR
2	closed_at	VARCHAR
3	total_service_charge_money	VARCHAR
4	total_tip_money	VARCHAR
5	service_charges	VARCHAR
6	created_at	VARCHAR
7	taxes	VARCHAR
8	line_items	VARCHAR
9	source	VARCHAR
10	version	INTEGER
11	location_id	VARCHAR
12	refunds	VARCHAR
13	fulfillments	VARCHAR
14	updated_at	VARCHAR	Incremental sync key
15	discounts	VARCHAR
16	tenders	VARCHAR
17	total_discount_money	VARCHAR
18	net_amounts	VARCHAR
19	return_amounts	VARCHAR
20	returns	VARCHAR
21	id	VARCHAR
22	state	VARCHAR
23	total_money	VARCHAR

Table: categories

No	Column Name	Type	Notes
1	present_at_all_locations	BOOLEAN
2	category_data	VARCHAR
3	is_deleted	BOOLEAN
4	updated_at	VARCHAR	Incremental sync key
5	id	VARCHAR
6	type	VARCHAR
7	version	INTEGER

Table: customers

No	Column Name	Type	Notes
1	birthday	VARCHAR
2	preferences	VARCHAR
3	cards	VARCHAR
4	address	VARCHAR
5	reference_id	VARCHAR
6	created_at	VARCHAR
7	given_name	VARCHAR
8	version	INTEGER
9	email_address	VARCHAR
10	updated_at	VARCHAR
11	segment_ids	VARCHAR
12	creation_source	VARCHAR
13	company_name	VARCHAR
14	group_ids	VARCHAR
15	phone_number	VARCHAR
16	id	VARCHAR	Incremental sync key
17	family_name	VARCHAR

Table: items

No	Column Name	Type	Notes
1	present_at_all_locations	BOOLEAN
2	custom_attribute_values	VARCHAR
3	is_deleted	BOOLEAN
4	updated_at	VARCHAR	Incremental sync key
5	id	VARCHAR
6	type	VARCHAR
7	image_id	VARCHAR
8	version	INTEGER
9	present_at_location_ids	VARCHAR
10	item_data	VARCHAR

External Resources

• Square Application
• Personal Token
• Oauth Access Token
• Modifierlists
• Team Members
• List Team Member Wages
• Square Api Explorer
• Square Api Docs
• Square Developer Dashboard
• This Information
• Backoff

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.