Advanced Search Query Support

Richard O'Dwyer

Advanced Search Queries

Up until now you could only query your API for exact spreadsheet row values. We're now happy to announce support for advanced queries, see examples below:

1) Wildcard search

Add a asterisk * anywhere in your search terms to enable wildcard search.

Example: https://sheet2api.com/v1/FgI6zV8qT121/characters/Looney%20Tunes?Name=Bugs*Bunny

2) Negative search

If you'd like to omit certain rows from the results, use an exclamation mark ! before the value.

For example, if you'd like get all rows except the one in which matches Name = Bugs Bunny, use this url: https://sheet2api.com/v1/FgI6zV8qT121/characters/Looney%20Tunes?Name=!Bugs%20Bunny

3) Relational operators

Use relational operators to match on numeric column values greater or less than a given number.

Simply start with <, >, <=, >= operator. Example URLs:

https://sheet2api.com/v1/CMMyLxNrQj_b/characters-with-ages?age<20

https://sheet2api.com/v1/CMMyLxNrQj_b/characters-with-ages?age>20

https://sheet2api.com/v1/CMMyLxNrQj_b/characters-with-ages?age>=20

https://sheet2api.com/v1/CMMyLxNrQj_b/characters-with-ages?age<=20

You can find documentation on these features on the "JSON API Docs" page for your Spreadsheet API.