smartsheet api exact match during searching -


i have node.js script uses smartsheet library function. search works except not returning exact match instead if search string has few characters match smartsheet, rows returned. how can search exact match ?

var options = {     sheetid: xxxxxxxxxxx,     queryparameters: {     query: <string search>     } };  // search sheet. smartsheet.search.searchsheet(options)     .then(function (data) {      console.log(data); } 

so if search 'test' search string returning results 1 or more characters in 'test' 'tes' match, returns rows..

by default, smartsheet accepts partial matches - both in ui via api. restrict exact match, enclose search term in double quotes (").

using rest api, can try: https://api.smartsheet.com/2.0/search/sheets/xxxxxxxxx?query=%22test%22

or in node:

var options = {     sheetid: xxxxxxxxxxxx,     queryparameters: {         query: '"test"'     } };  // search sheet. smartsheet.search.searchsheet(options)     .then(function (data) {     console.log(data); }); 

this mentioned in article https://help.smartsheet.com/articles/522231-searching-in-smartsheet#items


Comments

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

asp.net - Problems sending emails from forum -