Filtering
Filter rows using query parameters on the GET /api/v1/bridge/{bridgeId}/{sheetId} endpoint. Multiple filters are combined with AND logic.
Simple Equality
Use simple equality by providing the column name and value:
GET /api/v1/bridge/{bridgeId}/{sheetId}?filter[Name]=John
Matches rows where the "Name" column equals "John".
Operators
Use operators for advanced filtering:
| Operator |
Description |
Example |
_eq |
Equals |
filter[Name][_eq]=John |
_neq |
Not equals |
filter[Name][_neq]=John |
_contains |
Contains substring |
filter[Name][_contains]=John |
_in |
In list |
filter[Status][_in]=active,pending |
_null |
Is null |
filter[Email][_null]=true |
_notnull |
Is not null |
filter[Email][_notnull]=true |
_gt |
Greater than |
filter[Age][_gt]=18 |
_gte |
Greater than or equal |
filter[Age][_gte]=18 |
_lt |
Less than |
filter[Age][_lt]=65 |
_lte |
Less than or equal |
filter[Age][_lte]=65 |
Multiple Filters
Combine multiple filters (AND logic):
GET /api/v1/bridge/{bridgeId}/{sheetId}?filter[Status]=active&filter[Age][_gte]=18