Multiple query parameters using the API's Search Sheet Method

Hello, I need to find out the ID of a line where the column "Column1" has X value and Column "Column2" has Y value, that is, my query has two parameters. (column:Column1 "X" column:Column2 "Y")

GET https://api.smartsheet.com/2.0/search/sheets/{sheetId}?query=column%3AColumn1%20%22X%22%20column%3AColumn2%20%22Y%22

I found some old posts that taught how to make a call using the Post method with a query of this style in the Body, however in the current API documentation it seems that this method does not exist.

Is there a possibility to use this method GET "Search Sheet"? What would be the query I need to use?

Find more posts tagged with

Accepted answers

All comments

Jeff Reisman

If you can use the Smartsheet Live Data Connector to run a SQL query against the sheet, this is easy.

A workaround for the API would be to create a filter on the sheet that only leaves rows with Column1 = X and Column2 = Y. Apply the filter on the sheet, then run a GET on the sheet, with a query parameter of include=filters. In the sheet information, under userSettings, you'll see "appliedSheetFilterId": - save that filterId.

Then run your GET again, with query parameters:

filterId={the filterId you saved}

exclude=filteredOutRows

You'll then only get the rows returned that fall under your filter.

Samuel Mueller

I'm don't believe you can do this with with a query.. You will likely need to loop through an array of rows and check whether both columns match your criteria's. are you using Bridge?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.