get smartsheet row id by searching column values

Question

Is there a way to use the Smartsheet API to search a sheet and get back the IDs of rows where column A = {something} and column B = {something else}?

If this were SQL, it'd be a simple SELECT id FROM sheet WHERE A = 'something' and B = 'something else';

But the documentation for the Smartsheet API makes it seem as if you can only do a blunt text search across the entire sheet.

Answer 1

Unfortunately, there is no way to query / filter by specific column values today. This is definitely something we want to add, and it's on the roadmap.

You have two alternatives. One is to do a "blunt text search", as you have discovered. Another is to retrieve the sheet, parse it and identify matches locally. Not as elegant, and more time and labor intensive, but is a viable option.