Table GET API filter

I am trying to get all records using date filter and tried using

api/v3/tables/cS6haxAhBPohncvhZ/records?filters=[{“field”:"_updatedAt",“arg”:“2021-03-08”,“functionType”:“startsWith”}]

its not working.

Is there a different way to do this?

hello @SuhasPai, it’s not currently possible to use the Metadata Fields in your filters for the Table API (there is already a feature request submitted to our product team for this).

one solution could be to add an additional Field on your Table named Updated At (or similar) that gets updated to Current Date and Time every time the Record is updated. you can then use that Field to filter the API request. would this work for your use case??

thanks for posting!!

Hi,

But your API documentation mentions Special Fields can be used. Is that in error?