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
Post a Comment