-png.png?width=688&height=343&name=Screenshot%20(1213)-png.png)
Overview
DataBlend currently collects the following BambooHR data types:
- Employee Directory
- Employee Projects
- Hours
- Preconfigured Report
- Timesheet Entries
Note that Payroll data is not currently available via BambooHR's API. For payroll-related workflows, it is recommended that the user export the payroll data to a flat file and provide to DataBlend via SFTP.
Please note that if the Employee Directory configuration includes additional fields, then those fields will also be collected. Additionally, only active employees will be collected.
Employee Directory
The following fields at a minimum will be collected.
-
Display Name
-
First Name
-
Last Name
-
Preferred Name
-
Gender
-
Job Title
-
Employee Photo Exists
-
Employee Photo URL
-
Upload Photo
Configuration
|
Field |
Required/ Optional |
Comments |
|---|---|---|
|
Type |
Required |
BambooHR |
|
Name |
Required |
Descriptive free-text name for the collector |
|
Data Source |
Required |
Select a pre-configured data source from the drop down or click Create New to create a new data source. |
|
Schema Name |
Required |
Enter a name for the schema where the collected data will be stored. This can be a pre-configured schema or a new schema which will be created the first time the collector is run. |
|
Credential |
Required |
Select a pre-configured BambooHR credential from the drop-down. |
|
BambooHR Collector Type |
Required |
EmployeeDirectory |
The Preconfigured Report collector collects data from an existing BambooHR custom report.
Custom BambooHR reports are created from the Reports screen. Standard reports are not currently available via BambooHR's API.
Each custom report has a unique id number which can be identified from the report URL.
Configuration
|
Field |
Required/ Optional |
Comments |
|---|---|---|
|
Type |
Required |
BambooHR |
|
Name |
Required |
Descriptive free-text name for the collector. |
|
Data Source |
Required |
Select a pre-configured data source from the drop down or click Create New to create a new data source. |
|
Schema Name |
Required |
Enter a name for the schema where the collected data will be stored. This can be a pre-configured schema or a new schema which will be created the first time the collector is run. |
|
Credential |
Required |
Select a pre-configured BambooHR credential from the drop-down. |
|
BambooHR Collector Type |
Required |
PreconfiguredReport |
|
Report Id |
Required |
The Id from the BambooHR custom report. |
Get Employee