BambooHR Incremental Configuration

Use this method to fetch only the new or modified records instead of an entire data load.

Define the conditions to control the incremental data load during application runtime.

Enable Incremental Read #

Option to enable or disable the incremental read. This is useful if the need is only to read the objects that have been updated in the source since the last execution of the application for the given configuration.

Column #

The columns with integer, long, date, timestamp and decimal data types will get listed. Select a column on which incremental read will work. It is recommended that this column should have seqential, unique, and sorted (in increasing order) values.

Offset #

Mention a value to be set as a base for the incremental read with reference to the selected column. Only the records with values greater than the specified values will be read. For a column with dates, the format to provide the start value is yyyy-mm-dd. For example: 2022-04-11 For a column with timestamps, the format to provide the start value is yyyy-mm-dd-THH:mm:ssZ. For example: 2022-04-11T13:06:00Z.

Read Control Type #

Option to control the incremental read of data from the data source using any of the below mentioned approaches:

None

Read the data without specifying any limit.

Limit by Count #

Only the mentioned number of records in the reference column with their values greater than the Start Value will be read.

No of Records #

Mention number of records to be read. This option appears when Read Control type is set to Limit by Count.

Limit by Value #

All the records in the reference column with

values greater than the Start Value but less than/equal to the Column Value that you set will be read (Column Value is inclusive).

Column Value #

Set an upper limit by specifying a value from the reference column to limit the reading of the data incrementally.