Filtering
Filter expressions for GET requests on public data APIs.
Pass a filter query parameter on public Read rows requests:
field:operator:valueCombine clauses with and(...) / or(...) using ; or , separators.
Examples
# Equality
curl -G 'https://api.blazesheets.com/v1/<api-id>' \
--data-urlencode 'filter=status:eq:active'
# Grouped conditions
curl -G 'https://api.blazesheets.com/v1/<api-id>' \
--data-urlencode 'filter=and(active:eq:true;score:gte:80)'
# OR group
curl -G 'https://api.blazesheets.com/v1/<api-id>' \
--data-urlencode 'filter=or(role:eq:admin;role:eq:owner)'Operators
| Operator | Meaning |
|---|---|
eq | Equal (soft compare) |
ne / neq | Not equal |
gt / gte / lt / lte | Numeric / string compare |
like / ilike | Regex match (case-sensitive / insensitive) |
contains / not_contains | Substring or list membership |
starts_with / ends_with | String prefix / suffix |
in / nin / not_in | Value in list (|-separated) |
is_null / is_not_null / not_null | Empty / non-empty cells |
Lists
For in / nin, separate values with |:
country:in:US|CA|UKInvalid filter expressions return 400 BAD_REQUEST.
See the generated API Reference for the full Read rows operation schema.