Hello there!
In my SmartSuite Table I'm trying to filter the records via API by the full datetime values.
I have a full date-time field, but I'm not able to prepare a filter query that works on that field.
I tried with:
{
"filter": {
"operator": "and",
"fields": [
{
"comparison": "is_on_or_after",
"field": "sc5ed86aaa",
"value": {
"date_mode": "exact_date",
"date_mode_value": "2024-09-23T09:00:00.00000Z"
}
}
]
}
}
But it results in response:
{
"sc5ed86aaa": "{'date_mode': 'exact_date', 'date_mode_value': '2024-09-23T09:00:00.00000Z'} is not allowed for the 'is_on_or_after' comparison"
}
Also I tried with formula:
{
"filter": {
"operator": "and",
"fields": [
{
"comparison": "formula",
"field": "sc5ed86aaa",
"value": "sc5ed86aaa >= '2024-09-23T09:00:00Z' AND sc5ed86aaa <= '2024-09-23T10:00:00Z'"
}
]
}
}
And response I receive is:
{
"sc5ed86aaa": "Not allowed comparison."
}
Unlucky, the documentation doesn't cover the full datetime comparisons (only date granularity comparisons).
Anyone has idea how to filter the records by the full timestamps? Hopefully maybe someone from the Smartsuite team itself?
Thanks in advance for the help!