Filters use a singleDocumentation Index
Fetch the complete documentation index at: https://developers.beta.dealroom.co/llms.txt
Use this file to discover all available pages before exploring further.
filter query parameter with an expression string:
Expression syntax
| Form | Syntax | Example |
|---|---|---|
| Single | field[op]:value | total_funding[gte]:1000000 |
| AND | and(expr,expr,...) | and(total_funding[gte]:1000000,location[eq]:233) |
| OR | or(expr,expr,...) | or(location[eq]:118871,location[eq]:1297711) |
| Nested | and(or(...),expr) | and(or(location[eq]:118871,location[eq]:1297711),total_funding[gte]:1000000) |
| Cross-ref | relation__field[op]:value | investor__total_invested[gte]:100000000 |
Operators
| Operator | Description |
|---|---|
eq | Exact match |
neq | Not equal |
gt | Greater than |
gte | Greater than or equal |
lt | Less than |
lte | Less than or equal |
in_any | Matches any of the given values |
nin_any | Matches none of the given values |
in_all | Matches all values (relation filters only) |
nin_all | Excludes all values (relation filters only) |
in and nin are legacy aliases for in_any and nin_any. Prefer the
canonical names.Examples
Filter by HQ country
Locations are matched by numeric ID from the Dealroom location taxonomy, not by country name. Look up an ID once viaGET /api/filters/location/values and
reuse it:
Filter by industry (match any)
Industries (and other taxonomy values) live behind thetag_id filter. Pass
?type=industry on the values endpoint to scope the lookup, then pipe-separate
the resulting IDs in the filter expression:
Combine multiple filters
Useand() to require all conditions:
Cross-reference filter
Filter companies by their investors’ total invested amount:Sorting
Use thesort parameter with a field name. Prefix with - for descending order.