Discussions

In the v2 platform API, is there a way to retrieve a list of records last updated in a date/time range, or more simply, updated after a given date/time?

I'm building some data comparison tools in another system and would like to reduce the amount of data retrieved from RoseRocket by limiting the initial records after e.g., a "last comparison done" date.

After reading through the list records endpoint and inspecting the API calls the web console UI uses when setting a board filter on a Date field, I tried to filter on updatedAt as a DateField.

e.g., a request for all Customers updated from 01 to 14 Jan:

{
    "boardId": "<customer board ID>",
    "orderByPath": "updatedAt",
    "orderByDirection": "desc",
    "filters": [{
        "fieldType": "DateField",
        "filterKey": "updatedAt",
        "operator": "equals",
        "path": "updatedAt",
        "value": {
            "startAt": "2025-01-01T00:00:00",
            "endAt": "2025-01-14T00:00:00",
            "rangeType": "dateRange",
            "isUtcFilter": null
        }
    }],
    "offset": 0,
    "limit": 10
}

...but the response was HTTP 500 Internal Server error. Same HTTP 500 when trying to use a preset date range, as when filters.value.rangeType is "last7Days" (and startAt and endAt are null).

Is there a way to search objects on updatedAt like this? Ideally, this could apply to any record type that has an updatedAt or similar field.