Skip to main content
Filters use a single filter query parameter with an expression string: 
filter=<expression>

​
Expression syntax

FormSyntaxExample
Singlefield[op]:valuetotal_funding_usd[gte]:1000000
ANDand(expr,expr,...)and(total_funding_usd[gte]:1000000,location[eq]:233)
ORor(expr,expr,...)or(location[eq]:118871,location[eq]:1297711)
Nestedand(or(...),expr)and(or(location[eq]:118871,location[eq]:1297711),total_funding_usd[gte]:1000000)
Cross-refrelation__field[op]:valueinvestor__total_invested_usd[gte]:100000000

​
Operators

OperatorDescription
eqExact match
neqNot equal
gtGreater than
gteGreater than or equal
ltLess than
lteLess than or equal
in_anyMatches any of the given values
nin_anyMatches none of the given values
in_allMatches all values (relation filters only)
nin_allExcludes 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

curl "https://api-next.dealroom.co/api/entities?sort=-launch_year&filter=location_country[eq]:United+Kingdom" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "User-Agent: MyApp/1.0 (you@example.com)" \
  -H "X-Client-Id: YOUR_CLIENT_ID"

​
Filter by industry (match any)

curl "https://api-next.dealroom.co/api/entities?sort=-valuation&filter=industries[in_any]:fintech,payments" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "User-Agent: MyApp/1.0 (you@example.com)" \
  -H "X-Client-Id: YOUR_CLIENT_ID"

​
Combine multiple filters

Use and() to require all conditions: 
curl "https://api-next.dealroom.co/api/entities?sort=-launch_year&filter=and(location_country[eq]:Germany,launch_year[gte]:2018,total_funding_usd[gte]:1000000)" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "User-Agent: MyApp/1.0 (you@example.com)" \
  -H "X-Client-Id: YOUR_CLIENT_ID"

​
Cross-reference filter

Filter companies by their investors’ total invested amount: 
filter=investor__total_invested_usd[gte]:100000000

​
Sorting

Use the sort parameter with a field name. Prefix with - for descending order. 
sort=-launch_year      # newest first
sort=-total_funding_usd  # highest funded first

​
Available filters

Browse the API Reference for the complete list of filters available on each endpoint. Common entity filters include:
  • location_country, location_city, location_continent
  • industries, technologies, tags
  • launch_year, total_funding_usd, latest_valuation_usd
  • employee_count, growth_stage
  • has_funding, is_recently_funded