Is their any API to fetch sheets with exact name match and filter on basis of location ?

10/27/21

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.

Sign In or Register to comment.