Skip to content

Filtering

All list and export endpoints accept repeatable filter query parameters.

filter=logic.operator.field.value
PartValues
logicand, or
operatorSee tables below
fieldAny lead field (see list below), or attr:name for custom attributes
valueFilter value (omit for no-value operators like is_empty)

Each filter carries its own logic prefix — there is no global “AND mode” or “OR mode”.

  • Filters prefixed with and must all match (like SQL AND).
  • Filters prefixed with or match if any one of them is true (like SQL OR).
  • When mixing both: all and filters must pass and at least one or filter must pass.
ExampleMeaning
filter=and.eq.city.Pariscity must be Paris
filter=and.eq.city.Paris&filter=and.gte.rating.4city is Paris AND rating ≥ 4
filter=and.is_not_empty.email&filter=or.is_not_empty.phonehas email OR has phone
FieldTypeNotes
nametext
emailtext
phonetext
citytext
countrytext
categorytext
sourcetext
source_idtext
websitetext
ratingnumber
review_countnumber
scorenumberComputed score 0–100
tagsarrayUse array operators
locationlocationUse location operators
attr:<name>variesCustom attribute (e.g., attr:cuisine)
OperatorDescription
eqEquals (case-insensitive)
neqNot equals
containsContains substring
not_containsDoes not contain
starts_withStarts with
ends_withEnds with
is_emptyNull or empty string
is_not_emptyNot null and not empty
inEquals one of (comma-separated values)
OperatorDescription
eqEquals
neqNot equals
gtGreater than
gteGreater than or equal
ltLess than
lteLess than or equal
OperatorDescription
array_containsArray contains value
array_not_containsArray does not contain value
array_emptyArray is empty
array_not_emptyArray is not empty
OperatorDescriptionValue format
within_radiusWithin N km of a pointlat,lng,km
is_setHas coordinates
is_not_setMissing coordinates

Use attr:field_name as the field:

Terminal window
?filter=and.eq.attr:cuisine.Italian
?filter=and.gt.attr:employees.100
Terminal window
# City = Athens AND rating >= 4
?filter=and.eq.city.Athens&filter=and.gte.rating.4
# Has email OR has phone
?filter=and.is_not_empty.email&filter=or.is_not_empty.phone
# Tagged as "restaurant"
?filter=and.array_contains.tags.restaurant
# Within 5km of Athens city center
# Value format: lat,lng,radius_km
?filter=and.within_radius.location.37.98,23.73,5
# Source is either "website" or "api"
?filter=and.in.source.website,api
# Leads with a custom "cuisine" attribute = Italian
?filter=and.eq.attr:cuisine.Italian