Skip to navigation
Automation & Bulk ActionsExports

Export leads based on a search query

View as Markdown

You will receive a link to the generated file via email once the export is done.

The exported file is GZIP compressed to make your download and our upload faster. The content-encoding HTTP header will be set to gzip and the content-type HTTP header will be set to text/csv for CSV exports or application/json for JSON exports.

Parameters:

  • s_query/results_limit/sort (optional) - The Advanced Filtering API parameters used to narrow the exported results down. By default, all leads are exported.
  • format - Format of the exported file. The choices are: csv, json. JSON is recommended for raw backups or data migrations.
  • type - Type of the export.
    • leads - For CSV exports, it results in one row per lead. For JSON exports, this is the recommended type and is a superset of the other two types.
    • contacts - For CSV exports, it results in one row per contact.
    • lead_opps - For CSV exports, it results in one row per opportunity.
  • date_format (optional) - Controls the format of date objects. Note: this only works with the csv format.
    • original (default) - A date format that includes microseconds and timezone information.
      • Date: [YYYY]-[MM]-[DD]
      • Date w/ time: [YYYY]-[MM]-[DD] [hh]:[mm]:[ss.sssss]±[hh]:[mm]
    • iso8601 (recommended) - An ISO 8601 compatible date representation that does not include microseconds.
      • Date: [YYYY]-[MM]-[DD]
      • Date w/ time: [YYYY]-[MM]-[DD]T[hh]:[mm]:[ss]±[hh]:[mm]
    • excel - An Excel compatible date format. Dates are always in UTC, do not include timezone information or microseconds, and use a 12 hour clock with an AM or PM designation.
      • Date: [YYYY]-[MM]-[DD]
      • Date w/ time: [YYYY]-[MM]-[DD] [hh]:[mm]:[ss] [AM|PM]
  • fields (optional) - By default we return all the data fields in each export type. If you only need specific fields exported, you can explicitly list them in fields to get smaller exports.
  • include_activities (optional) - Activities aren’t included in any exports by default. If you want all your Activities exported as well, pass "include_activities": true. Note: this only works for leads type with json format.
  • include_smart_fields (optional) - Smart Fields aren’t included in any exports by default. If you want all of them exported as well, pass "include_smart_fields": true. Note: this only works for leads type with json format or any type formatted as csv. Smart fields are calculated fields, like number of emails on a lead.
  • send_done_email - Set to false if you don’t want to get a confirmation email after the bulk action is done.

Authentication

AuthorizationBasic
Use your API key as the username and leave the password empty.
OR
AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Request

This endpoint expects any.

Response

Successful response
created_bystring or null
date_createddatetime
date_formatenum
Allowed values:
date_updateddatetime
download_urlstring or null
fieldslist of strings
formatenum
Allowed values:
idstring
n_docsinteger or null
n_docs_processedinteger
organization_idstring
send_done_emailboolean
statusenum
Allowed values:
typeenum
Allowed values:
updated_bystring or null
limitinteger or nullOptional
paramsmap from strings to nullable maps from strings to JSON or lists of JSON or strings or integers or doubles or booleans or nullOptional
querystring or nullOptional
results_limitinteger or nullOptional
s_querymap from strings to nullable maps from strings to JSON or lists of JSON or strings or integers or doubles or booleans or nullOptional
sortlist of maps from strings to nullable JSONDict or lists of JSON or strings or integers or doubles or booleans or nullOptional

Errors

400
Bad Request Error
401
Unauthorized Error
404
Not Found Error