Zenefits

Prerequisites

• A Zenefits token

Tables in the Zenefits connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	custom_field_values	6		Full Refresh		API Reference
2	labor_groups	7		Full Refresh		API Reference
3	labor_group_types	6		Full Refresh		API Reference
4	custom_fields	19		Full Refresh		API Reference
5	locations	14		Full Refresh		API Reference
6	departments	7		Full Refresh		API Reference
7	employments	12		Full Refresh		API Reference
8	vacation_requests	14		Full Refresh		API Reference
9	time_durations	16		Full Refresh		API Reference
10	vacation_types	8		Full Refresh		API Reference
11	people	28		Full Refresh		API Reference

Table: custom_field_values

No	Column Name	Type	Notes
1	custom_field	VARCHAR
2	person	VARCHAR
3	id	VARCHAR
4	value	VARCHAR
5	url	VARCHAR
6	object	VARCHAR

Table: labor_groups

No	Column Name	Type	Notes
1	code	VARCHAR
2	labor_group_type	VARCHAR
3	name	VARCHAR
4	id	VARCHAR
5	url	VARCHAR
6	assigned_members	VARCHAR
7	object	VARCHAR

Table: labor_group_types

No	Column Name	Type	Notes
1	labor_groups	VARCHAR
2	name	VARCHAR
3	company	VARCHAR
4	id	VARCHAR
5	url	VARCHAR
6	object	VARCHAR

Table: custom_fields

No	Column Name	Type	Notes
1	help_url	VARCHAR
2	can_person_view_field	BOOLEAN
3	is_field_required	BOOLEAN
4	person_during_onboarding	BOOLEAN
5	url	VARCHAR
6	media_file_type	VARCHAR
7	custom_field_type	VARCHAR
8	help_url_media	VARCHAR
9	custom_field_values	VARCHAR
10	is_sensitive	BOOLEAN
11	can_manager_view_field	BOOLEAN
12	company_during_hiring	BOOLEAN
13	name	VARCHAR
14	can_person_edit_field	BOOLEAN
15	company	VARCHAR
16	id	VARCHAR
17	is_field_completer_person	BOOLEAN
18	object	VARCHAR
19	help_text	VARCHAR

Table: locations

No	Column Name	Type	Notes
1	zip	VARCHAR
2	country	VARCHAR
3	city	VARCHAR
4	people	VARCHAR
5	url	VARCHAR
6	phone	VARCHAR
7	labor_group	VARCHAR
8	name	VARCHAR
9	street1	VARCHAR
10	company	VARCHAR
11	id	VARCHAR
12	street2	VARCHAR
13	state	VARCHAR
14	object	VARCHAR

Table: departments

No	Column Name	Type	Notes
1	labor_group	VARCHAR
2	name	VARCHAR
3	company	VARCHAR
4	id	VARCHAR
5	people	VARCHAR
6	url	VARCHAR
7	object	VARCHAR

Table: employments

No	Column Name	Type	Notes
1	termination_type	VARCHAR
2	employment_type	VARCHAR
3	is_active	BOOLEAN
4	termination_date	VARCHAR
5	person	VARCHAR
6	working_hours_per_week	VARCHAR
7	employment_sub_type	VARCHAR
8	hire_date	VARCHAR
9	is_flsa_exempt	VARCHAR
10	id	VARCHAR
11	url	VARCHAR
12	object	VARCHAR

Table: vacation_requests

No	Column Name	Type	Notes
1	end_date	VARCHAR
2	reason	VARCHAR
3	creator	VARCHAR
4	hours	VARCHAR
5	approved_date	VARCHAR
6	vacation_type	VARCHAR
7	deny_reason	VARCHAR
8	url	VARCHAR
9	person	VARCHAR
10	created_date	VARCHAR
11	id	VARCHAR
12	status	VARCHAR
13	object	VARCHAR
14	start_date	VARCHAR

Table: time_durations

No	Column Name	Type	Notes
1	approver	VARCHAR
2	date	VARCHAR
3	is_overnight	BOOLEAN
4	hours	VARCHAR
5	activity	VARCHAR
6	start	VARCHAR
7	labor_group_ids	VARCHAR
8	url	VARCHAR
9	person	VARCHAR
10	is_approved	BOOLEAN
11	end	VARCHAR
12	state	VARCHAR
13	id	VARCHAR
14	object	VARCHAR
15	approved_datetime	VARCHAR
16	valid_status	VARCHAR

Table: vacation_types

No	Column Name	Type	Notes
1	count_as	VARCHAR
2	name	VARCHAR
3	company	VARCHAR
4	vacation_requests	VARCHAR
5	id	VARCHAR
6	url	VARCHAR
7	status	VARCHAR
8	object	VARCHAR

Table: people

No	Column Name	Type	Notes
1	country	VARCHAR
2	work_email	VARCHAR
3	city	VARCHAR
4	work_phone	VARCHAR
5	title	VARCHAR
6	type	VARCHAR
7	is_admin	BOOLEAN
8	labor_groups	VARCHAR
9	street1	VARCHAR
10	company	VARCHAR
11	state	VARCHAR
12	street2	VARCHAR
13	id	VARCHAR
14	department	VARCHAR
15	subordinates	VARCHAR
16	first_name	VARCHAR
17	manager	VARCHAR
18	last_name	VARCHAR
19	employments	VARCHAR
20	middle_name	VARCHAR
21	url	VARCHAR
22	custom_field_values	VARCHAR
23	employee_number	VARCHAR
24	location	VARCHAR
25	postal_code	VARCHAR
26	preferred_name	VARCHAR
27	object	VARCHAR
28	status	VARCHAR

External Resources

• Token
• Authentication

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.