Track new and changed data

Using the rowversion column in API is an effective way to track new and changed data in a table. The rowversion column automatically updates with a new unique binary value whenever a row is modified. Here’s how you can use it to retrieve new and changed data.

It is a data type that exposes automatically generated, unique binary numbers within a database. rowversion is generally used as a mechanism for version-stamping table rows. The storage size is 8 bytes. The API converts it to Long datatype. The rowversion data type is just an incrementing number and does not preserve a date or a time.

Use the maximum value og rowversion from the last query to get the new and changed rows using the [GT] filter.

                    {
                        "rowversion": {
                            "GT": [
                                "9535698"
                            ]
                        }
                    }
                

filter[Rowversion][GT]=9535698