Recruitee

Prerequisites

You can find your Company ID and find or create an API key within Recruitee.

Tables in the Recruitee connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	offers	43		Full Refresh		API Reference
2	candidates	30		Full Refresh		API Reference
3	departments	5		Full Refresh		API Reference

Table: offers

No	Column Name	Type	Notes
1	has_active_campaign	BOOLEAN
2	employment_type	VARCHAR
3	eeo_settings	VARCHAR
4	city	VARCHAR
5	created_at	VARCHAR
6	title	VARCHAR
7	adminapp_url	VARCHAR
8	example	BOOLEAN
9	mailbox_email	VARCHAR
10	pipeline_template	VARCHAR
11	careers_url	VARCHAR
12	disqualified_candidates_count	INTEGER
13	updated_at	VARCHAR
14	state_name	VARCHAR
15	street	VARCHAR
16	id	INTEGER
17	hiring_manager_id	INTEGER
18	department	VARCHAR
19	published_at	VARCHAR
20	slug	VARCHAR
21	closed_at	VARCHAR
22	department_id	INTEGER
23	qualified_candidates_count	INTEGER
24	kind	VARCHAR
25	recruiter_id	INTEGER
26	enabled_languages	VARCHAR
27	followed	BOOLEAN
28	url	VARCHAR
29	pipeline	BOOLEAN
30	country_code	VARCHAR
31	followers	VARCHAR
32	number_of_openings	INTEGER
33	candidates_count	INTEGER
34	hired_candidates_count	INTEGER
35	job_scheduler	VARCHAR
36	guid	VARCHAR
37	enabled_for_referrals	BOOLEAN
38	location	VARCHAR
39	position	INTEGER
40	postal_code	VARCHAR
41	state_code	VARCHAR
42	offer_tags	VARCHAR
43	status	VARCHAR

Table: candidates

No	Column Name	Type	Notes
1	rating	INTEGER
2	created_at	VARCHAR
3	phones	VARCHAR
4	placements	VARCHAR
5	source	VARCHAR
6	adminapp_url	VARCHAR
7	example	BOOLEAN
8	emails	VARCHAR
9	pending_result_request	BOOLEAN
10	has_avatar	BOOLEAN
11	updated_at	VARCHAR
12	ratings	VARCHAR
13	viewed	BOOLEAN
14	positive_ratings	INTEGER
15	id	INTEGER
16	ratings_count	INTEGER
17	tasks_count	INTEGER
18	upcoming_event	BOOLEAN
19	unread_notifications	BOOLEAN
20	photo_thumb_url	VARCHAR
21	initials	VARCHAR
22	followed	BOOLEAN
23	my_upcoming_event	BOOLEAN
24	referrer	VARCHAR
25	my_pending_result_request	BOOLEAN
26	admin_id	INTEGER
27	my_last_rating	VARCHAR
28	notes_count	INTEGER
29	name	VARCHAR
30	last_message_at	VARCHAR

Table: departments

No	Column Name	Type	Notes
1	name	VARCHAR
2	offers_count	INTEGER
3	grouped_translations	VARCHAR
4	id	INTEGER
5	status	VARCHAR

External Resources

• Recruitee
• 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.