Filtering

Filters use a single filter query parameter with an expression string:

filter=<expression>

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 via GET /api/reference/filters/location/values and reuse it:

# Discover the ID (returns { id: 233, name: "United States", ... })
curl "https://api-next.dealroom.co/api/reference/filters/location/values?q=United+States" \
  -H "Authorization: Bearer $ACCESS_TOKEN"

# Then filter
curl "https://api-next.dealroom.co/api/data/entities?sort=-launch_date&filter=location[eq]:233" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "X-Client-Id: YOUR_CLIENT_ID"

Filter by industry (match any)

Industries (and other taxonomy values) live behind the tag_id filter. Pass ?type=industry on the values endpoint to scope the lookup, then pipe-separate the resulting IDs in the filter expression:

# Discover IDs first — returns { id: 42, name: "Fintech", ... } etc.
curl "https://api-next.dealroom.co/api/reference/filters/tag_id/values?q=fintech&type=industry" \
  -H "Authorization: Bearer $ACCESS_TOKEN"

# Then filter
curl "https://api-next.dealroom.co/api/data/entities?sort=-latest_valuation&filter=tag_id[in_any]:42|99" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "X-Client-Id: YOUR_CLIENT_ID"

Combine multiple filters

Use and() to require all conditions:

# 165 = Netherlands (discover via /api/reference/filters/location/values)
curl "https://api-next.dealroom.co/api/data/entities?sort=-launch_date&filter=and(location[eq]:165,launch_date[gte]:2018,total_funding[gte]:1000000)" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "X-Client-Id: YOUR_CLIENT_ID"

Cross-reference filter

Filter companies by their investors’ total invested amount:

filter=investor__total_invested[gte]:100000000

Sorting

Use the sort parameter with a field name. Prefix with - for descending order.

sort=-launch_date      # newest first
sort=-total_funding    # highest funded first

The full list of accepted sort keys per resource is in the Filters & Sorting Reference.

Available filters

For a complete list of all filters and sort keys grouped by scope, see the Filters & Sorting Reference. You can also fetch available filters programmatically:

curl "https://api-next.dealroom.co/api/reference/filters?scope=companies" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "X-Client-Id: YOUR_CLIENT_ID"

Getting Started

Examples

Concepts

References

Agent APIs

Expression syntax

Operators

Examples

Filter by HQ country

Filter by industry (match any)

Combine multiple filters

Cross-reference filter

Sorting

Available filters

​Expression syntax

​Operators

​Examples

​Filter by HQ country

​Filter by industry (match any)

​Combine multiple filters

​Cross-reference filter

​Sorting

​Available filters

Expression syntax

Operators

Examples

Filter by HQ country

Filter by industry (match any)

Combine multiple filters

Cross-reference filter

Sorting

Available filters