Export API Overview
The Export API provides a way to retrieve large volumes of data from Account Engagement. It uses Account Engagement's existing API structures, patterns, and terminology.
Use the Export API to retrieve large sets of data when you don't need synchronous completion responses or when query limitations are too restrictive.
An export is associated with a query and a data set in Account Engagement. When you create an export, the query is split into smaller queries, which return smaller sets of data. These smaller queries are processed in parallel, and the retrieved data is saved in CSV files. When the export is complete, the CSV files are available to download.
The order of the records returned in the CSV files isn’t guaranteed. The number of records in each CSV file varies, and all of the files associated with an export make up the full data set for the query.
The Export resource is used to create an export and get the status of an export. When the export is complete, the links to the CSV files containing the data are available in the response.
A relationship is a property on an object that references another object, denoted in the documentation by the field’s type. For example, Prospects have a relationship field called campaign
that links to the Campaign object.
In Version 5 of the Account Engagement API, Export requests can have relationships as part of their fields parameter. Callers of the Export API can use these relationship fields to build exports that retrieve data from multiple objects in a single request, reducing the need for multiple exports. For example, we can create an export for VisitorActivity and include relationship data from Campaigns, Emails, and Prospects.
- The Export API is subject to the daily Account Engagement API call limit and the concurrent Account Engagement API call limit for your account.
- Similar to a queue, Export API calls are executed sequentially for each account. Older exports are processed before newer exports.
- The number of fields specified in the Export API calls can’t exceed 150.
- Collection fields can’t be exported. For example, on List Email the
senderOptions
andreplyToOptions
fields are not supported. - On procedures where no end date is supplied, for example,
createdAfter
is specified butcreatedBefore
isn’t, the export retrieves all data up until the creation date of the export. - Similar to the Synchronous API, relationships in an Export can have a max depth of 3, for example, on Prospect
campaign.folder.parentFolder.name
. - Exported relationship fields don’t support any non-scalar value such as related object collections.
The data associated with an export expires after 7 days. When data expires, the Export resource removes links to the CSV files and shows that the export has expired. Attempts to retrieve the data after an export expires will fail.
Exports that have not completed processing after 7 days will expire. Expired exports will no longer process and the results will not be made available. To retrieve this data, a new export should be created.
- The first row contains the name of the fields.
- The remaining rows contain the record data.
- Dates are returned in the user’s timezone at the time they created the export.
- For example, if a user is in the “PST” timezone and creates an export, the dates in the export are in “PST”. If a second user is in the “EST” timezone and downloads the exported files, the dates in the export are in “PST”.
- If a user’s timezone changes, previous exports created by the user have dates formatted in the previous timezone. Dates in new exports use the new timezone.
- Dates are returned in ISO8601 format:
2023-01-27T09:17:01-05:00
. To request the legacy date format, see thelegacyDateFormat
parameter. - Booleans are represented as
true
orfalse
in CSV. - Multiselect fields or fields that allow multiple responses return semicolon-delimited values:
one;two;three
. Semicolons in the field value are escaped with a backslash:first\;value;second\;value
. - Fields with null values are represented as empty values in CSV.
- Relationship field names in the CSV header are dot delimited.
This document assumes that you're familiar with connecting to the Account Engagement API, managing objects, and creating CSV files. You can export data by using these endpoints.
Verb | URI Path | Action |
---|---|---|
POST | /v5/exports | Create an export job. |
GET | /v5/exports/{id} | Read the status of an export job. |
GET | /v5/exports | Query export jobs. |
GET | /v5/exports/{id}/results | Download the results for an export job. |
POST | /v5/exports/{id}/do/cancel | Cancel an export job. |
Required Editable Fields
These fields are required for the Create operation.
Field | Type | Description |
---|---|---|
fields | Array | Specifies the fields to be exported. Only fields available for query are valid for every object. Fields are required to match the names documented for Version 5 objects. Prospect custom fields require the __c suffix. Object relationships can be exported by supplying the dot delimited field notation identical to how Synchronous API relationships are used. |
procedure | Object | The procedure to execute. A procedure is a query and execution plan used to retrieve data. Each object has its own set of procedures. See the Procedures section for available procedures. |
Procedure fields
Field | Type | Description |
---|---|---|
name | String | The name of the object to export and the procedure in the format Object/Procedure . The object name is without spaces and isn’t pluralized, e.g. ListEmail/FilterByCreatedAt |
arguments | Object | Arguments used to manipulate the behavior of the procedure. These arguments are specific to the procedure. See the Procedures section for available procedures. |
Optional Editable Fields
These are the optional fields for the Create operation.
Field | Type | Description |
---|---|---|
includeByteOrderMark | Boolean | Optional. False (Default): Do not include Byte Order Mark header in produced CSV True : Include Byte Order Mark header in produced CSV. |
maxFileSizeBytes | Integer | Optional. (The default value is 209,715,200 bytes, or 200MB). Asks the system to produce files no larger than the provided value. The minimum supported value is 10,000,000 bytes, almost 10MB. The maximum supported value is 209,715,200. |
legacyDateFormat | Boolean | Optional. False (Default): Export CSV contains timestamps in ISO 8601 format: 2023-01-27T09:17:01-05:00 . True : Export CSV contains timestamps in legacy format: 2023-01-27 09:17:01 . This format may be easier for legacy CSV readers to interpret. |
Read-Only Fields
Field | Type | Description |
---|---|---|
id | Integer | ID of the export job. |
status | String | The status of the export. See Export State Enum. |
isExpired | Boolean | Indicates whether the export has expired. |
createdAt | Datetime | The date and time that the export was created. |
updatedAt | Datetime | The date and time that the export was last updated. |
createdById | Integer | ID of the individual who created this export. |
updatedById | Integer | ID of the individual who last updated this export. |
createdBy | User | User object representing the user who created this job. See documentation for User for available fields. |
updatedBy | User | User object representing the user who last updated this job. See documentation for User for available fields. |
resultRefs | Array | This property contains a list of URLS to CSV files available for download. If there’s no data associated with the export, this property is null. The order of the URLs in the array isn’t significant. The field isn’t available for query. |
Used to create an export job.
Params
Field | Description |
---|---|
fields | The value for fields is a comma-separated enumeration of the fields to be returned. If no fields are input, an error is returned. |
Create an Export Job Example Request
Request headers:
Request body:
Create an Export Job Example Response
- Status Code: 201
- Output Representation
Errors
- Status code: 4xx
- Error codes: See Error Codes & Messages
Create a Visitor Activity Export with Relationships Example Request
Request headers:
Request body:
Create a Visitor Activity Export with Relationships Example Response
An example VisitorActivity export CSV result that has relationships can be found under the Download Results section.
- Status Code: 201
- Output Representation
Errors
- Status code: 4xx
- Error codes: See Error Codes & Messages
Returns the current state of the export.
Params for Read
URL Element | Description |
---|---|
fields | (Required) The value for fields is a comma-separated enumeration of the fields to be returned. |
id | (Required) The ID of the export. |
Example Request for Read
Example Response for Read
Status Code: 200
Errors for Read
- Status code: 4xx
- Error codes: See Error Codes & Messages
Retrieving a collection of export jobs follows the conventions described in Version 5 Overview.
When executing a query, the following fields can be specified in the orderBy
parameter. See the conventions for query described in the Version 5 Overview.
id
createdAt
updatedAt
Example Request
Example Response
Status Code: 200
When executing a query, the following parameters can be used to filter the returned results. These parameters can be specified in the request along with any shared parameters defined in Version 5 Overview. When specifying more than one parameter, all parameters must match the record for it to be returned in the results.
Parameter | Description |
---|---|
id | Returns any export where ID is equal to the given integer value. |
idList | Returns any export where ID is included in the given list of values. |
idGreaterThan | Returns any export where ID is greater than the specified value, non-inclusive. |
idGreaterThanOrEqualTo | Returns any export where ID is greater than or equal to the specified value. |
idLessThan | Returns any export where ID is less than the specified value, non-inclusive. |
idLessThanOrEqualTo | Returns any export where ID is less than or equal to the specified value. |
createdAt | Returns any export where CreatedAt is equal to the given datetime value. |
createdAtAfter | Returns any export where CreatedAt is after the given datetime value, non-inclusive. |
createdAtAfterOrEqualTo | Returns any export where CreatedAt is after or equal to the given datetime value. |
createdAtBefore | Returns any export where CreatedAt is before the given datetime value, non-inclusive. |
createdAtBeforeOrEqualTo | Returns any export where CreatedAt is before or equal to the given datetime value. |
updatedAt | Returns any export where UpdatedAt is equal to the given datetime value. |
updatedAtAfter | Returns any export where UpdatedAt is after the given datetime value, non-inclusive. |
updatedAtAfterOrEqualTo | Returns any export where UpdatedAt is after or equal to the given datetime value. |
updatedAtBefore | Returns any export where UpdatedAt is before the given datetime value, non-inclusive. |
updatedAtBeforeOrEqualTo | Returns any export where UpdatedAt is before or equal to the given datetime value. |
isExpired | Determines whether to return expired records. The value can be false (default) or true |
Errors for Query
- Status Code: 4xx
- Error codes: See Error Codes & Messages
The URLs retrieved from the Read endpoint can be used to download the results of the export. A failure occurs when attempting to download any results from an expired export. See Expiration for more information. The URL is provided by the resultRefs
field in a read.
Params for Download Results
URL Element | Description |
---|---|
id | The ID of the export job. |
fileId | The ID for the individual export file produced. |
Errors for Download Results
- Status Code: 4xx
- Error codes: See Error Codes & Messages
Example CSV Result with Reltionships
An example CSV file with VisitorActivity Relationships. See Create for the example create request and response for this CSV file.
id | campaignId | campaign.name | prospectId | prospect.firstName | prospect.lastName | prospect.email | emailId | email.name | email.subject | type | typeName |
---|---|---|---|---|---|---|---|---|---|---|---|
201563 | 100 | "Website Tracking" | 616 | "Chatty" | "Pardot" | "chatty@salesforce.com" | 1056 | "Scoring Category Email" | "Scoring Categories" | 11 | "Email" |
201564 | 302 | "Salesforce Buyer's Guide Campaign" | 652 | "Astro" | "Nomical" | "astro.nomical@salesforce.com" | 1056 | "Buyer's Guide" | "Salesforce Buyer's Guide" | 11 | "Email" |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
992458 | 302 | "Salesforce Buyer's Guide Campaign" | 1502 | "Genie" | "Rabbit" | "genie.rabbit@salesforce.com" | 2073 | "Buyer's Guide" | "Salesforce Buyer's Guide" | 11 | "Email" |
Used to cancel the export. If the export is already completed or failed, it can't be canceled. Canceling an export updates that updatedAt
and updatedBy
fields of the export.
Cancel Export Example Response
- Status Code: 201
- Output Representation
Errors for Cancel
- Status Code: 4xx
- Error codes: See Error Codes & Messages
See Campaign for more information.
Retrieves all campaign records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all campaign records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Custom Field for more information.
Retrieves all custom field records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all custom fields records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Custom Redirect for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Dynamic Content for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Email Template for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See External Activity for more information.
Retrieves all visitor activity records with an activityDate
value that is greater than the activityAfter
argument and less than the activityBefore
argument.
Arguments
activityAfter
: Selects external activities that occurred after the specified time.. The value must be specified using ISO 8601 formatted date and time (including timezone offset).activityBefore
: Optional. Selects visitor activities that occurred before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).
Retrieves all external activity records with a createdAt
value that is greater than the createdAfter
argument and less than the createdBefore
argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).
See File for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Folder for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Form for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Form Handler for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Form Handler Field for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).
See Landing Page for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Layout Template for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Lifecycle History for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).
See Lifecycle Stage for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Lifecycle Stage Prospect for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).
See List for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See List Email for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See List Membership for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Opportunity for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Prospect for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Prospect Account for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Tracker Domain for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See User for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Visit for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).
See Visitor for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).deleted
: (Optional) Selects records based on whether they're deleted or not. The value can be true, false, or all.
See Visitor Activity for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).type
: (Optional) Selects visitor activities of the specified types sent as an array of integers. If this argument isn’t specified, then all of the visitor activities belonging to any type is returned. See a list of available Visitor Activity Types in Visitor Activity. TypeSession
is omitted.prospectOnly
: (Optional) Selects only those visitor activities associated with a prospect. When this field is set tofalse
, all visitor activities with and without a prospect are returned. The values can betrue
orfalse
.
Retrieves all records with an updatedAt
value that is greater than the updatedAfter argument and less than the updatedBefore argument.
Arguments
updatedAfter
: Selects records that were updated after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).updatedBefore
: (Optional) Selects records that were updated before the specified time. This value must be after the value inupdatedAfter
. If this argument isn’t specified, then all data after theupdatedAfter
date up until the creation date of the Export is returned. TheupdatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).type
: (Optional) Selects visitor activities of the specified types sent as an array of integers. If this argument isn’t specified, then all of the visitor activities belonging to any type are returned. See a list of available Visitor Activity Types in Visitor Activity. TypeSession
is omitted.prospectOnly
: (Optional) Selects only those visitor activities associated with a prospect. When this field is set tofalse
, all visitor activities with and without a prospect are returned. The values can betrue
orfalse
.
See Visitor Page View for more information.
Retrieves all records with a createdAt value that is greater than the createdAfter argument and less than the createdBefore argument.
Arguments
createdAfter
: Selects records that were created after the specified time. The value must be specified using ISO 8601 formatted date and time (including timezone offset).createdBefore
: (Optional) Selects records that were created before the specified time. This value must be after the value increatedAfter
. If this argument isn’t specified, then all data after thecreatedAfter
date up until the creation date of the Export is returned. ThecreatedAfter
must be within a year of the creation date of the Export. The value must be specified using ISO 8601 formatted date and time (including timezone offset).
waiting
: The export is waiting to be processed.processing
: A server has started processing the export.complete
: The export is complete and the results are available for download.failed
: A fatal error has occurred and the data can’t be retrieved. Try executing the export again. If the error occurs again, contact support.canceled
: The export is canceled and can't be restarted.