通过搜索列值获取智能表行 ID [英] get smartsheet row id by searching column values

问题描述

有没有办法使用 Smartsheet API 来搜索工作表并取回 A 列 = {something} 和 B 列 = {something else} 的行的 ID?

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}?

如果这是 SQL，它将是一个简单的 SELECT id FROM sheet WHERE A = 'something' and B = 'something else';

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

但是 Smartsheet API 的文档让您似乎只能在整个工作表中进行粗略的文本搜索.

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

推荐答案

遗憾的是，目前无法通过特定列值查询/过滤.这绝对是我们想要添加的内容，并且在路线图上.

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.

这篇关于通过搜索列值获取智能表行 ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！