Make a search request
To search your CRM, make aPOST
request to the object’s search endpoint. CRM search endpoints are constructed using the following format: /crm/v3/objects/{object}/search
. In the request body, you’ll include filters to narrow your search by CRM property values. For example, the code snippet below would retrieve a list of all contacts that have a specific company email address.
createdate
, email
, firstname
, hs_object_id
, lastmodifieddate
, and lastname
. For example, the above request would return the following response:
properties
array in the request body. For example:
Searchable CRM objects and engagements
Objects
The tables below contain the object search endpoints, the objects they refer to, and the properties that are returned by default.Search endpoint | Object | Default returned properties |
---|---|---|
/crm/v3/objects/carts/search | Carts | createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/companies/search | Companies | name , domain , createdate ,hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/contacts/search | Contacts | firstname ,lastname ,email ,lastmodifieddate ,hs_object_id , createdate |
/crm/v3/objects/deals/search | Deals | dealname , amount , closedate,``pipeline ,dealstage , createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/deal_split/search | Deal splits | hs_createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/discounts/search | Discounts | createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/feedback_submissions/search | Feedback submissions | hs_createdate ,hs_lastmodifieddate ,hs_object_id |
/crm/v3/objects/fees/search | Fees | createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/invoices/search | Invoices | createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/leads/search | Leads | createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/line_items/search | Line items | quantity , amount , price , createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/orders/search | Orders | createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/commerce_payments/search | Payments | createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/products/search | Products | name , description ,price , createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/quotes/search | Quotes | hs_expiration_date , hs_public_url_key , hs_status ,hs_title , hs_createdate , hs_lastmodifieddate ,hs_object_id |
/crm/v3/objects/subscriptions/search | Subscriptions (Commerce) | hs_createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/taxes/search | Taxes | createdate , hs_lastmodifieddate , hs_object_id |
/crm/v3/objects/tickets/search | Tickets | content , hs_pipeline , hs_pipeline_stage ,hs_ticket_category , hs_ticket_priority , subject ,createdate , hs_lastmodifieddate , hs_object_id |
Engagements
The table below contains the engagement search endpoints, the engagements they refer to, and the properties that are returned by default.Search endpoint | Engagement | Default returned properties |
---|---|---|
/crm/v3/objects/calls/search | Calls | hs_createdate ,hs_lastmodifieddate ,hs_object_id |
/crm/v3/objects/emails/search | Emails | hs_createdate ,hs_lastmodifieddate ,hs_object_id |
/crm/v3/objects/meetings/search | Meetings | hs_createdate ,hs_lastmodifieddate ,hs_object_id |
/crm/v3/objects/notes/search | Notes | hs_createdate ,hs_lastmodifieddate ,hs_object_id |
/crm/v3/objects/tasks/search | Tasks | hs_createdate ,hs_lastmodifieddate ,hs_object_id |
Search default searchable properties
Search all default text properties in records of the specified object to find all records that have a value containing the specified string. By default, the results will be returned in order of object creation (oldest first), but you can override this with sorting. For example, the request below searches for all contacts with a default text property value containing the letterX
.
Search endpoint | Object | Default searchable properties |
---|---|---|
/crm/v3/objects/calls/search | Calls | hs_call_title , hs_body_preview |
/crm/v3/objects/companies/search | Companies | website , phone , name , domain |
/crm/v3/objects/contacts/search | Contacts | firstname ,lastname ,email ,phone ,hs_additional_emails , fax , mobilephone , company , hs_marketable_until_renewal |
/crm/v3/objects/{objectType}/search | Custom objects | Up to 20 selected properties. |
/crm/v3/objects/deals/search | Deals | dealname ,pipeline ,dealstage , description , dealtype |
/crm/v3/objects/emails/search | Emails | hs_email_subject |
/crm/v3/objects/feedback_submissions/search | Feedback submissions | hs_submission_name , hs_content |
/crm/v3/objects/meetings/search | Meetings | hs_meeting_title , hs_meeting_body |
/crm/v3/objects/notes/search | Notes | hs_note_body |
/crm/v3/objects/products/search | Products | name , description ,price , hs_sku |
/crm/v3/objects/quotes/search | Quotes | hs_sender_firstname , hs_sender_lastname , hs_proposal_slug , hs_title , hs_sender_company_name , hs_sender_email , hs_quote_number , hs_public_url_key |
/crm/v3/objects/tasks/search | Tasks | hs_task_body , hs_task_subject |
/crm/v3/objects/tickets/search | Tickets | subject , content , hs_pipeline_stage , hs_ticket_category , hs_ticket_id |
Filter search results
Use filters in the request body to limit the results to only records with matching property values. For example, the request below searches for all contacts with a first name of Alice.Please note: when filtering search results for calls, conversations, emails, meetings, notes, or tasks, the property
hs_body_preview_html
is not supported. For emails, the properties hs_email_html
and hs_body_preview
are also not supported.filters
within filterGroups
:
- To apply AND logic, include a comma-separated list of conditions within one set of
filters
. - To apply OR logic, include multiple
filters
within afilterGroup
.You can include a maximum of fivefilterGroups
with up to 6filters
in each group, with a maximum of 18 filters in total. If you’ve included too many groups or filters, you’ll receive aVALIDATION_ERROR
error response. For example, the request below searches for contacts with the first nameAlice
AND a last name other thanSmith
, OR contacts that don’t have a value for the propertyemail
.
- When filtering for an enumeration property, search is case-sensitive for all filter operators.
- When filtering for a string property using
IN
andNOT_IN
operators, the searched values must be lowercase.Below are the available filter operators:
Operator | Description |
---|---|
LT | Less than the specified value. |
LTE | Less than or equal to the specified value. |
GT | Greater than the specified value. |
GTE | Greater than or equal to the specified value. |
EQ | Equal to the specified value. |
NEQ | Not equal to the specified value. |
BETWEEN | Within the specified range. In your request, use key-value pairs to set highValue and value . Refer to the example below the table. |
IN | Included within the specified list. Searches by exact match. In your request, include the list values in a values array. When searching a string property with this operator, values must be lowercase. Refer to the example below the table. |
NOT_IN | Not included within the specified list. In your request, include the list values in a values array. When searching a string property with this operator, values must be lowercase. |
HAS_PROPERTY | Has a value for the specified property. |
NOT_HAS_PROPERTY | Doesn’t have a value for the specified property. |
CONTAINS_TOKEN | Contains a token. In your request, you can use wildcards (*) to complete a partial search. For example, use the value *@hubspot.com to retrieve contacts with a HubSpot email address. |
NOT_CONTAINS_TOKEN | Doesn’t contain a token. |
BETWEEN
operator to search for all tasks that were last modified within a specific time range:
IN
operator to search for companies that have specified values selected in a dropdown property.
Search through associations
Search for records that are associated with other specific records by using the pseudo-propertyassociations.{objectType}
. For example, the request below searches for all tickets associated with a contact that has the contact ID of 123
:
Please note: the option to search through custom object associations is not currently supported via search endpoints. To find custom object associations, you can use the associations API.
Sort search results
Use a sorting rule in the request body to list results in ascending or descending order. Only one sorting rule can be applied to any search. For example, the request below sorts returned contacts with most recently created first:Paging through results
By default, the search endpoints will return pages of 10 records at a time. This can be changed by setting thelimit
parameter in the request body. The maximum number of supported objects per page is 200. For example, the request below would return pages containing 20 results each.
after
parameter provided in the paging.next.after
property of the previous response. If the paging.next.after
property isn’t provided, there are no additional results to display. You must format the value in the after
parameter as an integer. For example, the request below would return the next page of results:
Limitations
- It may take a few moments for newly created or updated CRM objects to appear in search results.
- Archived CRM objects won’t appear in any search results.
- The search endpoints are rate limited to five requests per second per account.
- The maximum number of supported objects per page is 200.
- A query can contain a maximum of 3,000 characters. If the body of your request exceeds 3,000 characters, a 400 error will be returned.
- The search endpoints are limited to 10,000 total results for any given query. Attempting to page beyond 10,000 will result in a 400 error.
- When filtering, you can include a maximum of five
filterGroups
with up to sixfilters
in each group, with a maximum of 18 filters in total. - When searching for phone numbers, HubSpot uses special calculated properties to standardize the format. These properties all start with
hs_searchable_calculated_*
. As a part of this standardization, HubSpot only uses the area code and local number. You should refrain from including the country code in your search or filter criteria.