Filtering

You can filter exported data three ways: no filter, simple filtering, and advanced filtering. Without filter parameters, the API returns all products. Simple filtering lets you search for one or more values in a specific column. Advanced filtering lets you build multi-criteria queries.

Examples throughout this section use the following schema:

CREATE TABLE IF NOT EXISTS `data` (
   `id`           TEXT,
   `color`        text DEFAULT '',
   `name`         text DEFAULT '',
   `email`        text DEFAULT '',
   `countryCode`  text DEFAULT ''
);

The queryable columns and returned attributes depend on your data schema.

No Filter

Retrieve all products without any filter parameters.

Pagination

Paginate over the full product set using limit and offset.

Group By

Return unique values for a column using the groupBy parameter.

Simple Filter

Filter results by one or more values for a single column.

Advanced Filter

Build complex multi-criteria filters with operators, ordering, and more.