Is their any API to fetch sheets with exact name match and filter on basis of location ?
I wanted to get the list of the sheets with the exact name I provide. I have tried the Get / Search method to look for exact text by adding double quotes but it doesn't filter out special characters.
For eg. If I request
https://api.smartsheet.com/2.0/search?query="Report for Calendar App"
Response:
{ "results": [ { "text": "Report-for-Calendar-App", "objectType": "sheet", "objectId": xxx, "contextData": [ "Sheets > Testing" ] }, { "text": "Report for Calendar App", "objectType": "sheet", "objectId": xxx, "contextData": [ "Sheets > Testing" ] } ], "totalCount": 2 }
I want the exact string match.
Also, with location parameter provided under https://smartsheet-platform.github.io/api-docs/#search-everything I want response to be filtered out using "location" parameter provided in API. But I am unable to do it. It would be useful if some one could guide how to use this parameter.
I don't want to use contextData to filter out sheet location.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives