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

TL;DR

Keep the filter on the server for large tables instead of pulling every row and filtering locally. When you filter Coda rows server-side, build the query as a quoted pair string, like "Status":"Overdue", and pass useColumnNames true alongside it.

Steps

1. 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.

When to use

You are seeing this: Without that flag the API expects column IDs, so name-based filters silently match nothing. Use this skill when you run into "Coda API listRows: the query filter uses a quoted Column Value string".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

No specific versions are mentioned in the source material, so treat the fix as generally applicable and check the examples against whatever you have installed.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

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