Hi,
The API documentation seems unclear when it comes to filtering objects by date.
The syntax for the date value object specified at https://developers.smartsuite.com/docs/solution-data/records/sort-filter#date-value-object has
"value": {
"date_mode": "exact_date",
"date_mode_value": "2023-02-01"
}
but "exact_date" is not listed as a date mode at https://developers.smartsuite.com/docs/solution-data/records/sort-filter#date-modes-and-values. The "Date Mode" column there seems to list what are actually comparisons to be used in the filter, not values of the "date_mode"
parameter.
In addition to this, when I use the example date value object provided in a filter i.e.
{
"filter":{
"operator":"and","fields":[
{"field":"s99be6c0bc","comparison":"is", "value": {
"date_mode": "exact_date", "date_mode_value": "2023-02-01"
}
}
]
}
}
I get the following error:
{'date_mode': 'exact_date', 'date_mode_value': '2023-02-01'} is not allowed for the 'is' comparison
How do I filter by date using the API?