Bamboo hr

Prerequisites

• BambooHr Account
• BambooHr Api key

Tables in the Bamboo hr connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	employees_directory_stream	19
2	custom_reports_stream	80		Full Refresh

Table: employees_directory_stream

No	Column Name	Type	Notes
1	lastName	VARCHAR
2	workEmail	VARCHAR
3	displayName	VARCHAR
4	jobTitle	VARCHAR
5	linkedIn	VARCHAR
6	canUploadPhoto	DOUBLE
7	division	VARCHAR
8	firstName	VARCHAR
9	photoUrl	VARCHAR
10	mobilePhone	VARCHAR
11	workPhone	VARCHAR
12	location	VARCHAR
13	pronouns	VARCHAR
14	id	VARCHAR
15	preferredName	VARCHAR
16	department	VARCHAR
17	workPhoneExtension	VARCHAR
18	supervisor	VARCHAR
19	photoUploaded	BOOLEAN

Table: custom_reports_stream

No	Column Name	Type	Notes
1	country	VARCHAR
2	payGroupId	VARCHAR
3	workEmail	VARCHAR
4	jobTitle	VARCHAR
5	paidPer	VARCHAR
6	supervisorEmail	VARCHAR
7	commissionComment	VARCHAR
8	supervisorEId	VARCHAR
9	bonusReason	VARCHAR
10	employeeNumber	VARCHAR
11	ssn	VARCHAR
12	division	VARCHAR
13	terminationDate	VARCHAR
14	nin	VARCHAR
15	payType	VARCHAR
16	bonusAmount	VARCHAR
17	commissionDate	VARCHAR
18	id	VARCHAR
19	preferredName	VARCHAR
20	state	VARCHAR
21	acaStatus	VARCHAR
22	acaStatusCategory	VARCHAR
23	fullName1	VARCHAR
24	paySchedule	VARCHAR
25	homePhone	VARCHAR
26	payRate	VARCHAR
27	fullName5	VARCHAR
28	fullName4	VARCHAR
29	fullName3	VARCHAR
30	fullName2	VARCHAR
31	flsaCode	VARCHAR
32	supervisorId	VARCHAR
33	zipcode	VARCHAR
34	firstName	VARCHAR
35	homeEmail	VARCHAR
36	bonusDate	VARCHAR
37	mobilePhone	VARCHAR
38	nationality	VARCHAR
39	standardHoursPerWeek	VARCHAR
40	stateCode	VARCHAR
41	payRateEffectiveDate	VARCHAR
42	includeInPayroll	VARCHAR
43	workPhoneExtension	VARCHAR
44	maritalStatus	VARCHAR
45	supervisor	VARCHAR
46	commissionAmount	VARCHAR
47	status	VARCHAR
48	birthday	VARCHAR
49	originalHireDate	VARCHAR
50	lastName	VARCHAR
51	payScheduleId	VARCHAR
52	ethnicity	VARCHAR
53	gender	VARCHAR
54	bonusComment	VARCHAR
55	city	VARCHAR
56	isPhotoUploaded	VARCHAR
57	displayName	VARCHAR
58	payFrequency	VARCHAR
59	eeo	VARCHAR
60	workPhonePlusExtension	VARCHAR
61	sin	VARCHAR
62	department	VARCHAR
63	createdByUserId	VARCHAR
64	hireDate	VARCHAR
65	address2	VARCHAR
66	address1	VARCHAR
67	lastChanged	VARCHAR
68	dateOfBirth	VARCHAR
69	payChangeReason	VARCHAR
70	payGroup	VARCHAR
71	nationalId	VARCHAR
72	commisionDate	VARCHAR
73	timeTrackingEnabled	VARCHAR
74	employmentHistoryStatus	VARCHAR
75	location	VARCHAR
76	middleName	VARCHAR
77	workPhone	VARCHAR
78	exempt	VARCHAR
79	age	VARCHAR
80	bestEmail	VARCHAR

External Resources

• Custom Reports
• Rate Limits
• Api Key

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.