Bamboo HR Connector Reference

The Bamboo HR connector exposes 42 fields (1 metrics, 41 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Bamboo HR Fields

Bamboo HR employees_directory_stream fields

The employees_directory_stream report of the Bamboo HR connector includes 21 fields.

ID	Type	Name	Description
employees_directory_stream__canUploadPhoto	NUMERIC	employees_directory_stream.canUploadPhoto	Whether the employee can upload a photo
employees_directory_stream__department	TEXT	employees_directory_stream.department	Department of the employee
employees_directory_stream__displayName	TEXT	employees_directory_stream.displayName	Display name of the employee
employees_directory_stream__division	TEXT	employees_directory_stream.division	Division of the employee
employees_directory_stream__firstName	TEXT	employees_directory_stream.firstName	First name of the employee
employees_directory_stream__id	TEXT	employees_directory_stream.id	employees_directory_stream.id
employees_directory_stream__jobTitle	TEXT	employees_directory_stream.jobTitle	Job title of the employee
employees_directory_stream__lastName	TEXT	employees_directory_stream.lastName	Last name of the employee
employees_directory_stream__linkedIn	TEXT	employees_directory_stream.linkedIn	LinkedIn profile of the employee
employees_directory_stream__location	TEXT	employees_directory_stream.location	Location of the employee
employees_directory_stream__mobilePhone	TEXT	employees_directory_stream.mobilePhone	Mobile phone number of the employee
employees_directory_stream__name	TEXT	employees_directory_stream.name	employees_directory_stream.name
employees_directory_stream__photoUploaded	BOOLEAN	employees_directory_stream.photoUploaded	Whether the employee photo is uploaded
employees_directory_stream__photoUrl	IMAGE_URL	employees_directory_stream.photoUrl	Photo URL of the employee
employees_directory_stream__preferredName	TEXT	employees_directory_stream.preferredName	Preferred name of the employee
employees_directory_stream__pronouns	TEXT	employees_directory_stream.pronouns	Pronouns of the employee
employees_directory_stream__supervisor	TEXT	employees_directory_stream.supervisor	Supervisor of the employee
employees_directory_stream__type	TEXT	employees_directory_stream.type	employees_directory_stream.type
employees_directory_stream__workEmail	TEXT	employees_directory_stream.workEmail	Work email of the employee
employees_directory_stream__workPhone	TEXT	employees_directory_stream.workPhone	Work phone number of the employee
employees_directory_stream__workPhoneExtension	TEXT	employees_directory_stream.workPhoneExtension	Work phone extension of the employee

Bamboo HR meta_fields_stream fields

The meta_fields_stream report of the Bamboo HR connector includes 4 fields.

ID	Type	Name	Description
meta_fields_stream__alias	TEXT	meta_fields_stream.alias	meta_fields_stream.alias
meta_fields_stream__id	TEXT	meta_fields_stream.id	meta_fields_stream.id
meta_fields_stream__name	TEXT	meta_fields_stream.name	meta_fields_stream.name
meta_fields_stream__type	TEXT	meta_fields_stream.type	meta_fields_stream.type

Bamboo HR time_off_requests_stream fields

The time_off_requests_stream report of the Bamboo HR connector includes 12 fields.

ID	Type	Name	Description
time_off_requests_stream__actions	OBJECT	time_off_requests_stream.actions	time_off_requests_stream.actions
time_off_requests_stream__amount	OBJECT	time_off_requests_stream.amount	time_off_requests_stream.amount
time_off_requests_stream__created	TEXT	time_off_requests_stream.created	time_off_requests_stream.created
time_off_requests_stream__dates	TEXT	time_off_requests_stream.dates	time_off_requests_stream.dates
time_off_requests_stream__employeeid	TEXT	time_off_requests_stream.employeeId	time_off_requests_stream.employeeId
time_off_requests_stream__end	TEXT	time_off_requests_stream.end	time_off_requests_stream.end
time_off_requests_stream__id	TEXT	time_off_requests_stream.id	time_off_requests_stream.id
time_off_requests_stream__name	TEXT	time_off_requests_stream.name	time_off_requests_stream.name
time_off_requests_stream__notes	OBJECT	time_off_requests_stream.notes	time_off_requests_stream.notes
time_off_requests_stream__start	TEXT	time_off_requests_stream.start	time_off_requests_stream.start
time_off_requests_stream__status	OBJECT	time_off_requests_stream.status	time_off_requests_stream.status
time_off_requests_stream__type	OBJECT	time_off_requests_stream.type	time_off_requests_stream.type

Bamboo HR other fields

The Bamboo HR connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date