Quickbase Incremental Configuration

Advanced Configuration in Quickbase

Enable Incremental Read: Option to enable/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 sequential, unique, and sorted (in increasing order) values.

Start Value: Mention a value to be set as the base for the incremental read with reference to the selected column. Only the records with values greater than the specified value will be read.

For a column with dates, the format to provide the start value is: yyyy-MM-dd

For a column with timestamps, the format to provide the start value is: yyyy-MM-ddTHH:mm:ssZ

Read Control Type: You can control the incremental read of data from the data source by any of the below approaches.

Limit by Value: Specify the limit till the point where you want to read the data.

None: Read the data without specifying any limit.

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