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

Powered by Converge