ODBC guide

Get contacts by email (search)

Returns contacts matching a search filter. This example filters by email; you can change the filter to other properties. SearchFilters is a JSON array of filter objects (property name, operator, value).

SELECT Id
  , IsArchived
  , CreatedAt
  , UpdatedAt
  , email
  , firstname
  , lastname
  , company_size
FROM search_contacts
WITH (SearchFilters='[ {"propertyName": "email", "operator": "EQ", "value": "bh@hubspot.com" } ]')