Coda API listRows: the query filter uses a quoted Column Value string

When you filter Coda rows server-side, build the query as a quoted pair string, like "Status":"Overdue", and pass useColumnNames true alongside it. Without that flag the API expects column IDs, so name-based filters silently match nothing. Keep the filter on the server for large tables instead of pulling every row and filtering locally.

Context: Official docs (Getting Started Guide, automated reminders): documents the listRows query syntax that trips agents up. The query parameter is not a JSON object or SQL; it is a string like "Status":"Overdue", built by wrapping the column name and value in quotes, and it only matches by name when you also pass useColumnNames set to true.

Source: Official docs (Getting Started Guide, automated reminders): documents the listRows query syntax that trips agents up. The query parameter is not a JSON object or SQL; it is a string like "Status":"Overdue", built by wrapping the column name and value in quotes, and it only matches by name when you also pass useColumnNames set to true.

Verified resolution: When you filter Coda rows server-side, build the query as a quoted pair string, like "Status":"Overdue", and pass useColumnNames true alongside it. Without that flag the API expects column IDs, so name-based filters silently match nothing. Keep the filter on the server for large tables instead of pulling every row and filtering locally.

Source URL: https://docs.superhuman.com/@oleg/getting-started-guide-coda-api/automated-reminders-7