query. The query object can include:
filter- Filter conditionssort- Sort configurationpagination- Pagination settingsaggregate- Aggregation configuration (for aggregate endpoints)
Basic Example
URL Encoding
The query object must be JSON-stringified and URL-encoded:Filtering
Filters allow you to narrow down results based on field values.Basic Filter
Composite Filter (AND)
Composite Filter (OR)
Supported Operators
Comparison Operators:equals- Exact matchnotEquals- Not equal togt- Greater than (numbers)gte- Greater than or equal (numbers)lt- Less than (numbers)lte- Less than or equal (numbers)
like- Case-sensitive pattern match (use%as wildcard)ilike- Case-insensitive pattern match (use%as wildcard)notLike- Case-sensitive negative matchstartsWith- Starts with valueendsWith- Ends with value
in- Value is in array (for array fields)not-in- Value is not in arrayincludes- Array includes value (for array fields)not-includes- Array does not include value
before- Before dateonOrBefore- On or before dateafter- After dateonOrAfter- On or after date
and- All filters must matchor- Any filter must match
Filter Examples
Filter by protocol:Sorting
Sort results by any field in ascending or descending order. Sort Structure:asc- Ascending orderdesc- Descending order""- No sorting (use default)
Pagination
Control the number of results returned and navigate through pages. Pagination Structure:page- Page number (starts at 1)perPage- Number of results per page (max varies by endpoint, typically 100)
Aggregation
For aggregate and timeseries endpoints, you can specify aggregation parameters. Aggregate Structure:groupBy- Field to group by (e.g.,protocol_id,network_id,asset_class_id,date)aggregateFunction- Function to apply:sum,avg,min,maxinterval- Time interval (for timeseries):day,week,month,yearmode- Aggregation mode:stock- Point-in-time snapshot (latest value per period)flow- Aggregate over period (sum/avg/etc. of all values)