BambooHR ETL Source

The BambooHR API is a RESTful Internet protocol built around making semantically meaningful HTTPS requests to access or modify a resource (usually done by an employee).

The API can be used to manipulate employee data and to generate reports in several formats.

Schema Type #

See the topic Provide Schema for ETL Source → to know how schema details can be provided for data sources.

After providing schema type details, the next step is to configure the data source.

Data Source Configuration #

Configure the data source parameters as explained below.

Connection Name #

Choose a connection name from the saved list of connections or create a new connection using the Add New Connection option.

Table Name #

Select the table from the provided list. All tables are listed from the configured connection.

Fields #

All the fields of the selected table are listed. Select the fields that are required to be read.

Additional Query Options #

Limit the maximum number of records to be fetched from the selected table using the additional query options.

Limit Set this option to limit the maximum number of records to be fetched. (range: 0-100)

After The count of initial records to be skipped while reading data from an BambooHR table should be provided. This endpoint is limited to 10000 total results to any given query.

Filter Groups #

Option to exclusively fetch schema results or read data from source as per the filter condition or query provided.

A maximum of 3 filter groups with up to three filters in each group can be applied.

Enable Parallel Read #

Enable parallel reads to BambooHR tables.

Max no. of Requests Per Sec #

Specify the maximum number of requests to BambooHR per second.