Filter by date in API

Resolved

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?

1
5 replies