Sort and Filter Your SheetBridge Data

Query Parameters

You can filter lists using the Operators below in the Query Parameter setup by providing the column name and value.

The example below would match rows where the "user_id" column equals "LoggedInUser>id" from MagicText.

---

Operators

Use operators for advanced filtering:

Operator	Description	Query Param Name	Query Param Value
_eq	Equals	filter[user_id][_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

The _eq operator also supports comma-separated values (acts like _in). If a user passes ffilter[Status][_eq]=active,pending , it will match either value.

---

Multiple Filters

Combine multiple filters using +ADD ANOTHER FILTER.

The example below would list rows where the "user_id" column equals "LoggedInUser>id" from MagicText AND “category” column does not equal “Instruments”. If both conditions are not met, the record will not load.

Sorting

Sort rows using the sort query parameter in the List Filters Sorting is applied after filtering and supports single or multiple columns.

Single Column Sorting

• Sort by a single column in ascending order:

• Sort by a single column in descending order (prefix with -):

---

Multi-Column Sorting

Sort by multiple columns by separating them with commas. Columns are sorted in order of priority:

This sorts by:

1. name in ascending order

2. user_id in descending order (for rows with the same name)

---

Column Name Resolution

Column names are resolved using the same header mapping system as filtering:

• Normalized headers (spaces removed, lowercase)

• Canonical keys

• Case-insensitive label matching

You can use any of these formats:

• Original column label: ?sort=Full Name

• Normalized header: ?sort=fullname

• Canonical key: ?sort=full_name

---

Value Comparison

The sorting service intelligently compares values:

• Numeric values: Sorted numerically (e.g., 2 comes before 10)

• String values: Sorted case-insensitively (e.g., apple and Apple are treated the same)

• Null values: Always pushed to the end of the sorted results

---

Combining with Other Parameters

Sorting can be combined with filtering:

This will:

• Filter rows where user_id equals LoggedinUser>id

• Sort results by name in descending order

---

Unknown Columns

If you specify a column that doesn't exist in the sheet, it will be silently ignored. The request will still succeed, but that sort directive will have no effect.