通过搜索列值获取智能表行 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屋!