Learn how to filter data in Sheets with FFQL.
field name
is optional and excluding a field name will search across all fields. For example: eq "Planet Express"
will search across all fields for that value.
field name
can be the field key or the field label.
Labels or values with spaces should be wrapped in quotes. For example: name eq "Bender Rodriguez"
, or "First Name" eq Bender
.
eq
- Equals (exact match)ne
- Not Equallt
- Less Thangt
- Greater Thanlte
- Less Than or Equal Togte
- Greater Than or Equal Tolike
- (Case Sensitive) Likeilike
- (Case Insensitive) Likecontains
- Contains (for columns of type string-list
and enum-list
)like
and ilike
support the following wildcards:
%
- Matches any number of characters_
- Matches a single characterlike "Bender%"
would match “Bender Rodriguez” and “Bender Bending Rodriguez”.
and
- Returns rows meeting both conditionsor
- Returns rows meeting either conditions (inclusive)is
Operatoris
operator. For example: is error
returns all the rows in an error
state. is valid
returns all the rows in a valid
state. first_name is error
returns the rows where First Name is in an error
state.
\
). Here are examples of how escaping works:
Query | Value |
---|---|
"hello \" world" | hello " world |
'hello \' world' | hello ' world |
"hello world \\" | hello world \ |
"hello \ world" | hello \ world |
"hello \\ world" | hello \ world |
John "Johnny" Doe
q
parameter.
Here’s an example cURL request using the sheets/<sheetId>/records
endpoint:
Shell / cURL