Blog
Token
About Us
AiDOOS Wiki
Project Cost Estimation

Welcome to Knowledge Base!

KB at your finger tips

This is one stop global knowledge base where you can learn about all the products, solutions and support features.

Categories
All
CRM
Salesforce
ERP
SAP
Storage and Backups
Purestorage Netapp Nutanix
Cloud
AWS
Computing
IBM
Database
MongoDB MySQL PostgreSQL
DevOps
Docker Kubernetes Jenkins GitLab
Mobile
React Native Android
Web
React Angular PHP
Programming
Python
Products
CNC Software (Mastercam) 3D perception 7shifts

CRM-Salesforce

Salesforce Developers

Custom Field Object

Use custom fields to capture and track more data about your prospects. You can use custom fields in forms and sync the Pardot fields with Salesforce fields. Learn more about Pardot fields in Salesforce Help.

Include the authentication header with every request. For information on how to authenticate, see Authentication.

Resource Name Operation Description
Custom Field Create POST Create a custom field.
Custom Field Read GET Request detailed information for a single custom field.
Custom Field Update POST Update a custom field's value.
Custom Field Delete POST or DELETE Delete a custom field.
Custom Field Query GET Request information for the custom fields that match the specified criteria.

Create a custom field with the specified name and API name.

URI

Parameters

The following parameters are required to create a new custom field:

Parameter Type Description
name string The name of the custom field.
field_id string The API name of the custom field.

Parameters can include any editable field in the Custom Field object. For a list of fields in the Custom Field object, see Custom Field.

Example

Create a custom field of type integer with the name "Partner Level" and the API name "PARTNER_LEVEL_c," which doesn’t allow multiple values.

Delete a custom field specified by custom field ID.

URI

Replace <ID> with the ID of the custom field.

Example

Delete the custom field with ID 5746xx.

Request information about the specified custom field.

URI

Replace <ID> with the ID of the custom field.

Example

Request the information for the custom field with ID 12341xxx

Request information about custom fields that match the specified criteria. You can specify which custom field records and fields to request. A maximum of 200 custom fields are returned. To return all custom fields, specify the output as mobile .

To request information about a specific custom field, use Custom Field Read.

URI

Parameters to Select Custom Fields

Use these parameters to specify which custom fields are returned. Parameters can be used in any combination and any order unless otherwise specified.

Notes:

  • Parameters must be URL-encoded.
  • Dates and times must use GNU Date Input Syntax (yyyy-mm-dd:hh:ss ).
  • For a full listing of custom fields see Object Field References.
Parameter Type Options Description
created_after string today , yesterday , last_7_days , this_month , last_month , <custom_time> Request custom fields created after the specified time. Example: To request forms created in 2020, use /api/customField/version/3/do/query?created_after=2019-12-31 24:59:59 .
created_before string today , yesterday , last_7_days , this_month , last_month , <custom_time> Request custom fields created before the specified date and time. Does not include custom fields created at the specified time. <custom_time> Example : to request custom fields created before today (but not created today), use /api/customField/version/3/do/query?created_before=today .
id_greater_than integer Any positive integer Requests custom fields that have an ID greater than the specified number.
id_less_than integer Any positive integer Returns custom fields that have an ID less than the specified number.

Parameters to Specify Which Results Are Returned

Use these parameters to specify which custom fields are returned, and how the custom fields are sorted.

Parameter Type Options Description
limit integer Any integer from 1 through 200 The number of custom fields to return. Default value is 200.
offset integer Any positive integer The number of custom fields to omit from the response (the number to "skip over"). Example: Retrieve a list of custom fields, omitting the 50 most recently updated custom fields. Sort the query by the updated_at field and use offset=50: /api/customField/version/3/do/query?offset=50&sort_by=created_at
sort_by string created_at , id , probability , value The field by which the results are sorted. See Sort Order.
sort_order string ascending, descending The sort order. The default value depends on which sort_by parameter you specify. See Sort Order.

Sort Order

Use the sort_by parameter to specify which field Pardot uses to sort the results. Different fields have different default sort orders.

Value Default Sort Order Description
created_at descending Sort the results by the custom fields' created_at timestamps.
id ascending Sort the results by the custom fields' id fields.
name ascending Sort the results by the custom fields' name fields.

Updates information for the specified custom field. Specify the custom field by custom field ID. Fields that are not specified in the request are not changed. To clear a field, use a null value.

Returns an updated version of the custom field.

URI

Replace <ID> with the ID of the custom field.

Parameters

You can use any field in a Custom Field object as a parameter. For a list of fields in a Custom Field object, see Custom Field.

Example

To update a custom field's name to "CONTACTED", use the following POST command:

The XML response for a query request contains information about multiple custom fields. The XML response for a read request contains information about a single custom field.

XML Response for Custom Field Query

Tag Description
<result> Parent tag. Contains the custom fields that match the parameters specified in your query.
<total_results> The number of custom fields selected by the query. Note: The query request returns a maximum of 200 custom fields. If your query matches more than 200 custom fields, you can make several requests to retrieve all matching custom fields.
<customField> The information for a single custom field. See Custom Field.

XML Response for Custom Field Read

Tag Description
<customField> The information for a single custom field. See Custom Field.

Salesforce Developers

Custom Redirect Object

Track links on your website or third-party site with Pardot’s custom redirects. For example, you can track a link on your Twitter page or a banner ad on a third-party site. When a user clicks a link, a corresponding activity is created on their profile. Learn about custom redirects in Salesforce Help.

Include the authentication header with every request. For information on how to authenticate, see Authentication.

Resource Name Operation Description
Custom Redirect Read GET Request information for a single custom redirect record.
Custom Redirect Query GET Request information for custom redirects that match the specified criteria.

Request information for a single custom redirect record.

URI

Replace <ID> with the Pardot ID of the custom redirect.

Example

Request the information for the custom redirect with ID 1234.

Requests information about custom redirects that match the specified criteria. You can specify the custom redirects and fields to request. A maximum of 200 custom redirects are returned. To return all custom redirects, specify the output as mobile .

To request information about a specific custom redirect, use Custom Redirect Read.

URI

Parameters to Select Custom Redirects

Use these parameters to specify the custom redirects to return. Parameters can be used in any combination and in any order unless otherwise specified.

Notes:

  • Parameters must be URL-encoded.
  • Dates and times must use GNU Date Input Syntax (yyyy-mm-dd:hh:ss ).
  • For a full listing of custom redirect fields see Object Field References.
Parameter Type Possible Values Description
created_after string today , yesterday , last_7_days , this_month , last_month , <custom_time> Requests custom redirects created after the specified time. Example: To request custom redirects created in 2020, use //api/customRedirect/version/3/do/query?created_after=2019-12-31%2024:59:59 .
created_before string today , yesterday , last_7_days , this_month , last_month , <custom_time> Requests custom redirects created before the specified date and time. Doesn’t include custom redirects created at the specified time. Example : To request custom redirects created before today (but not created today), use /api/customRedirect/version/3/do/query?created_before=today .
id_greater_than integer Any positive integer Requests custom redirects that have an ID greater than the specified number.
id_less_than integer Any positive integer Returns custom redirects that have an ID less than the specified number.
updated_after string today , yesterday , last_7_days , this_month , last_month , <custom_time> Requests custom redirects that were last updated after the specified date and time.
updated_before string today , yesterday , last_7_days , this_month , last_month , <custom_time> Selects custom redirects that were last updated before the specified date and time.

Parameters to Specify Which Results Are Returned

Use these parameters to specify which custom redirect fields are returned, and how the custom redirects are sorted.

Parameter Type Possible Values Description
limit integer Any integer from 1 through 200. The number of custom redirects to return. Default value is 200.
offset integer Any positive integer The number of custom redirects to omit from the response (the number to "skip over"). Example: Retrieve a list of custom redirects, omitting the 50 most recently updated custom redirects. Sort the query by the updated_at field and use offset=50: api/customRedirect/version/3/do/query?sort_by=updated_at&offset=50
sort_by string created_at , id The field by which the results are sorted. See Sort Order.
sort_order string ascending , descending , updated_at The sort order. The default value depends on which sort_by parameter you specify. See Sort Order.

Sort Order

Use the sort_by parameter to specify which field Pardot uses to sort the results. Different fields have different default sort orders.

Value Default Sort Order Description
created_at descending Sort the results by the custom redirects' created_at timestamps.
id ascending Sort the results by the custom redirects' id fields.
updated_at descending Sort the results by the custom redirects' updated_at timestamps.

The XML response for a query request contains information about multiple custom redirects. The XML response for a read request contains information about a single custom redirect.

XML Response for a Custom Redirect Query

Tag Description
<result> Parent tag. The custom redirects that match the parameters specified in your query.
<total_results> The number of custom redirects selected by the query. Note : The query request returns a maximum of 200 custom redirects. If your query matches more than 200 custom redirects, you can make several requests to retrieve all matching custom redirects.
<customRedirect> The information for a single custom redirect. See Custom Redirect in Object Field References.
Tag Description
<customRedirect> The information for a single custom redirect. See Custom Redirect in Object Field References.
Read article

Salesforce Developers

Dynamic Content Object

Dynamic content personalizes parts of your website based on what you know about a viewer. Learn more about dynamic content in Salesforce Help.

Include the authentication header with every request. For information on how to authenticate, see Authentication.

Resource Name Operation Description
Dynamic Content Query GET Request information for dynamic content that matches the specified criteria.
Dynamic Content Read GET Request information for a single dynamic content record.

Request information for the dynamic content records that match the specified criteria. You can specify the dynamic content records and fields to request. A maximum of 200 records are returned. To return all dynamic content records, specify the output as mobile .

URI

Parameters to Select Dynamic Content Records

Use these parameters to specify the dynamic content records to return. Parameters can be used in any combination and in any order unless otherwise specified.

Notes:

  • Parameters must be URL-encoded.
  • Dates and times must use GNU Date Input Syntax (for example, yyyy-mm-dd:hh:ss ).
  • For a full listing of dynamic content fields see Object Field References.
Parameter Type Possible Values Description
created_after string today , yesterday , last_7_days , this_month , last_month , <custom_time> Request dynamic content records created after the specified time. Example: To request forms created in 2020, use /api/dynamicContent/version/3/do/query?created_after=2019-12-31 24:59:59 .
created_before string today , yesterday , last_7_days , this_month , last_month , <custom_time> Request dynamic content records created before the specified time. Doesn’t include dynamic content records created at the specified time. Example : To request dynamic content records created before today (but not created today), use /api/dynamicContent/version/3/do/query?created_before=today .
id_greater_than integer Any positive integer Request dynamic content records that have an ID greater than the specified number.
id_less_than integer Any positive integer Request dynamic content records that have an ID less than the specified number.
updated_after string today , yesterday , last_7_days , this_month , last_month , <custom_time> Request dynamic content records that were last updated after the specified time.
updated_before string today , yesterday , last_7_days , this_month , last_month , <custom_time> Request dynamic content records that were last updated before the specified time.

Parameters to Specify Which Results Are Returned

Use these parameters to specify the dynamic content fields to return, and how the dynamic content records are sorted.

Parameter Type Possible Values Description
limit integer Any integer from 1 through 200. The number of dynamic content records to return. Default value is 200.
offset integer Any positive integer The number of dynamic content records to omit from the response (the number to "skip over"). Example: Retrieve a list of dynamic content records, omitting the 50 most recently updated records. Sort the query by the updated_at field and use offset=50: /api/dynamicContent/version/3/do/query?sort_by=updated_at&offset=50
sort_by string created_at , id , updated_at The field by which the results are sorted. See Sort Order.
sort_order string ascending, descending The version/3. The default value depends on which sort_by parameter you specify. See Sort Order.

Sort Order

Use sort_by to specify which field Pardot uses to sort the results. Different fields have different default sort orders.

Value Default Sort Order Description
created_at descending Sort the results by the dynamic content records' created_at timestamps.
id ascending Sort the results by the dynamic content records' id fields.
updated_at descending Sort the results by the dynamic content records' updated_at timestamps.

Request information for a single dynamic content record.

URI

Replace <ID> with the Pardot ID of the dynamic content record.

Example

Request information about the dynamic content record with ID 1234.

The XML response for a query request contains information for multiple dynamic content records. The XML response for a read request contains information for a single dynamic content record.

XML Response for a Dynamic Content Query

Tag Description
<result> Parent tag. Contains the dynamic content records that match the parameters specified in your query.
<total_results> Contains the number of dynamic content records selected by the query. Note The query request returns a maximum of 200 dynamic content records. If your query matches more than 200 records, you can make several requests to retrieve all matching records.
<dynamicContent> The information about a single dynamic content record. See Dynamic Content in Object Field References for a complete description of fields.

XML Response for a Dynamic Content Read

Tag Description
<dynamicContent> The information about a single dynamic content record. See Dynamic Content in Object Field References for a description of fields.
Read article

Salesforce Developers

Email Template Object

Use an email template to design a reusable email layout for your engagement programs, autoresponders, one-to-one emails, and list emails. Learn about email templates in Salesforce Help.

Include the authentication header with every request. For information on how to authenticate, see Authentication.

Resource Name Operation Description
Email Template Read GET Request information about a single email template.
One-to-One Email Templates GET Request information about the email templates that are used in one-to-one emails.

Request information about a single email template.

URI

Replace <ID> with the Pardot ID of the email template.

Parameters to Select a Template

Use this parameter to specify the email templates to return.

Parameter Type Possible Values Description
archived boolean true , false If true , the request returns archived and unarchived templates. If false , only unarchived templates are returned. Default value is false .

Request the email templates that are enabled for one-to-one emails.

URI

Parameters to Select One-to-One Email Templates

Use this parameter to specify which one-to-one email templates to return.

Parameter Type Possible Values Description
archived boolean true , false If true , the request returns both archived and unarchived templates. If false , only unarchived templates are returned. Default is false .

Use the XML response for read requests and one-to-one requests to learn more about your email templates.

XML Response for an Email Template Read

Tag Description
<emailTemplate> Parent tag. Contains data fields for a single email template.
<error> Flag if an error occurred.
<errorCode> Code for the error which occurred.
<errorMessage> Description of the error.
<sendOptions> The associated send options object, including sender-specific data.
<replyToAddress> The email address in the email's Reply-To header.
<sendFromData> A JSON array representing the sender hierarchy tied to the email template.
<id> The Pardot ID of the email template.
<name> The name of the email template.
<htmlMessage> The HTML version of the email template body.
<textMessage> The plain text version of the email template body.
<isDripEmail> Flag if the template is available for use in engagement programs.
<isListEmail> Flag if the template is available for use in list emails.
<subject> The subject of the email message.

XML Response for One-to-One Email Templates

Tag Description
<emailTemplates> Parent tag. Contains individual email template records.
<templates> Parent tag for each template.
<id> The Pardot ID of the email template.
<name> The name of the email template.
<isOneToOneEmail> Flag if the email template is available for use in one-to-one emails (always true).
<isArchived> Flag if the email template is in the Recycle Bin in Pardot.
<isAutoResponderEmail> Flag if the email template is available for use as an auto response from a form submission.
<isDripEmail> Flag if the email template is available for use in engagement programs.
<isListEmail> Flag if the email template is available for use in list emails.
<subject> The subject of the email message.
Read article

Salesforce Developers

Email Object

Use email resources to send emails to prospects, and to learn how prospects responded to the emails. Learn more about email in Salesforce Help.

Include the authentication header with every request. For information on how to authenticate, see Authentication.

Resource Name Operation Description
Email List Send POST Send an email to all prospects in the specified list.
Email One-to-One Send POST Send an email to a single prospect.
Email Read GET Request information for an email, such as the email name and subject.
Email Statistics GET Request statistics for a list email, such as the number of clicks, opens, and opt-outs.

Send an email to every prospect on the specified list.

URI

Creating the Email

You can satisfy the required fields to create a list email send request in the following ways:

  1. Specify list_ids[] , campaign_id , and email_template_id .
  2. Specify list_ids[] , campaign_id , text_content , name , subject , from_email , and from_name .
  3. Specify list_ids[] , campaign_id text_content , name , subject , and from_user_id .

Parameters

The following parameters can be used in a list email send request.

Parameter Type Description
campaign_id integer The Pardot ID of the campaign to which the email send is assigned.
from_name string The name of the user sending the email.
from_email string The email address of user sending the email.
from_user_id string The Pardot ID of the user sending the email.
from_assigned_user boolean If the prospect has an assigned user, send the email from that user.
from_account_owner boolean If the prospect has an account owner, send the email from that user.
replyto_email string The email address to use for the reply emails.
list_ids[] array The Pardot ID of the email lists. The email is sent to all users on the specified lists. You can post multiple list IDs for multiple lists.
suppression_list_ids[] integer The Pardot ID of the suppression list. The email isn’t sent to any user on the suppression lists. You can post multiple suppression list IDs for multiple lists.
tags[] string The name of the tags to create or associate with the email. You can post multiple tags.
operational_email boolean When true , the email is sent to the prospect regardless of opt-out status. Your account must have this feature enabled to use this setting.
name string The email record's name.
subject string The email's subject.
text_content string The email's text body. Must contain either %%unsubscribe%% or %%email_preference_center%% .
html_content string The email's html body. Must contain either %%unsubscribe%% or %%email_preference_center%% .
email_template_id integer The Pardot ID of the email template.
scheduled_time ISO8601 string The ISO8601 date and time to send the email.
format (xml or json) The format in which the response is sent. The default is xml .

Example

Schedule an email for October 31 at 5pm GMT-4. Use a template with ID 6789. Send the email to four prospect lists and specify two suppression lists. The email is sent from the assigned user (if one is assigned). Three tags are assigned to the email.

This example uses cURL.

XML Response for an Email List Send

Tag Description
<email> Parent tag. Contains information about the email. For more information about email fields, see Email.

Send an email to a single prospect. You can specify the prospect by Pardot ID or email address.

URIs

Replace <ID> with the Pardot ID of the email.

Replace <prospect_email> with the prospect's email address.

Creating the Email

You can satisfy the required fields to send an email in the following ways:

  1. Specify campaign_id and email_template_id .
  2. Specify campaign_id , text_content , name , subject , from_email and from_name .
  3. Specify campaign_id text_content , name , subject , and from_user_id .

Parameters

The following parameters can be used in a one-to-one email send request.

Parameter Type Description
campaign_id integer The ID of the Pardot campaign to associate the email with.
prospect_id integer The Pardot ID of the prospect you're sending the email to.
prospect_email string The email address of the prospect you're sending the email to.
from_name string The name of the user sending the email.
from_email string The email address of user sending the email.
from_user_id string The Pardot ID of the user sending the email.
replyto_email string The email address to use for the reply emails.
tags[] string The name of the tags to create or associate with the email. You can post multiple tags.
operational_email boolean When true , the email is sent to the prospect regardless of opt-out status. Your account must have this feature enabled to use this setting.
name string The email record's name.
subject string The email's subject.
text_content string The email's text body. Must contain either %%unsubscribe%% or %%email_preference_center%% .
html_content string The email's html body. Must contain either %%unsubscribe%% or %%email_preference_center%% .
email_template_id integer The Pardot ID of the email template.
format xml or json The format in which the response is sent. The default is xml .

Example

Send an email to the prospect with Pardot ID 1234.

XML Response for Email One-to-One Send

When an email send is successful, the response contains a copy of the email.

Tag Description
<email> Parent tag. Contains information about the email. For more information about email fields, see Email.

Request information for an email, such as the Pardot ID, Pardot name, and message body. For information about fields in an email record, see Email.

URI

Replace <ID> with the Pardot ID of the email.

Parameters

The request can include this parameter.

Parameter Type Description
include_message boolean If false , the response doesn’t include the html or text body of the email message. Default value is true .

Example

Request information for the email with ID 12345.

Request statistical information for a list email, such as the number of clicks, opens, and opt-outs.

URI

Replace <ID> with the Pardot ID of the email.

Example

Request statistics for the email with ID 12345.

XML Response for Email Statistics Request

Tag Description
<stats> The statistics for a single list email.
<sent> The number of emails sent.
<delivered> The number of emails delivered.
<total_clicks> The total number of clicks for the email.
<unique_clicks> The number of unique clicks for the email.
<soft_bounced> The number of soft bounces for the email.
<hard_bounced> The number of hard bounces for the email.
<opt_outs> The number of opt outs for the email
<spam_complaints> The number of spam complaints for the email.
<opens> The number of opens for the email.
<unique_opens> The number of unique opens for the email.
<delivery_rate> The delivery rate based on the number of emails sent.
<opens_rate> The open rate based on the number of emails delivered.
<click_through_rate> The click-through rate based on the number of emails delivered.
<unique_click_through_rate> The unique click-through rate based on the number of emails delivered.
<click_open_ratio> The ratio between email clicks and opens.
<opt_out_rate> The opt-out rate based on the number of emails delivered.
<spam_complaint_rate> The spam complaint rate based on the number of emails delivered.
Read article

Salesforce Developers

Export API Overview

The Export API provides a way to retrieve large volumes of data from Pardot. It uses Pardot'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 Pardot. 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 resource.

  • The Export API is subject to the daily Pardot API call limit and the concurrent Pardot API call limit for your account.
  • Export API calls are executed sequentially for each account, with older exports being processed before newer exports.
  • The number of fields specified in the Export API calls can't exceed 150.

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 fail.

To prevent errors with automations, files generated by the export API don't include a BOM (Byte Order Mark) in the beginning of the file. Exports created from the Pardot UI produce files with a BOM header.

  • The first row contains the name of the field.
  • The second row and beyond 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 “PST” timezone and creates an export, the dates in the export are in “PST”. If a second user is in “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 the standard Pardot API date format of YYYY-MM-DD HH:mm:SS .
  • Fields with null values are represented as an empty value in CSV.

A procedure is a query and execution plan used to retrieve the data. Each object has a different set of procedures.

External Activity

See External Activity for more information.

Fields

Select the external activity fields you want to export.

Field Type Nullable Description
id Integer No The External Activity ID.
extension String No The extension for the type. This value must be less than or equal to 255 characters.
extensionSalesforceId String No The extension's Salesforce ID.
type String No The type of external activity that this record corresponds to. This must be a value from one of the registered types in the account. This value must be less than or equal to 255 characters.
typeSalesforceId String No The type's Salesforce ID.
prospectId Integer No The prospect ID the activity was linked to based on the email.
value String Yes Any string value associated to this event. This value is not checked and can be any value. The value must be less than or equal to 100 characters.
value String Yes Any string value associated to this event. This value is not checked and can be any value. The value must be less than or equal to 100 characters.
activityDate DateTime No The date the external activity happened. This value can be used by the user to back date or forward date the activity. If not specified, then the current date is used. This must be in "YYYY-MM-DD" format.
createdAt DateTime No The time the record was created in Pardot. This field is the standard system field and the value is equal to the time the record is created in the data store.
createdById Integer Yes The ID of the user that sent the request to Pardot (the authenticated user of the request).

Abilities

Action Requirements
Create export Prospect > External Activity > View ability
View export Prospect > External Activity > View ability and be the same user that created the export
View all exports Admin > Exports > View ability
Query exports Admin > Exports > View ability

filter_by_created_at

Retrieves all external activity records with a created_at value that is greater than the created_after argument and less than the created_before argument.

Arguments

  • created_after Required. Selects external activities that were created after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • created_before : Optional. Selects external activities that were created before the specified time. This value must be after the value in created_after . If this argument isn’t specified, then no upper boundary is used in the query, and all data after the created_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.

The range between created_after and created_before cannot exceed 1 year. When prospect_updated_before is not specified, the current date is used to gauge the interval.

filter_by_activity_date

Retrieves all visitor activity records with an activityDate value that is greater than the activity_after argument and less than the activity_before argument.

Arguments

  • activity_after : Required. Selects external activities that occurred after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • activity_before : Optional. Selects visitor activities that occurred before the specified time. This value must be after the value in updated_after . If this argument isn’t specified, then no upper boundary is used in the query, and all data after the updated_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.

The range between activity_after and activity_before can’t exceed 1 year. When updated_before isn’t specified, the current date is used to gauge the interval.

Visitor Activity

Fields

Select the visitor activity fields you want to export. See the visitor activity fields that are available. The value for fields must be an array of strings of the available fields.

Abilities

Action Requirements
Create export Prospects > Visitors > View ability
View export Prospects > Visitors > View ability and be the same user that created the export
View all exports Admin > Exports > View ability
Query exports Admin > Exports > View ability

To create an export with this procedure, the user must have the following:

  • “Prospects > Visitors > View“ ability

To view an export with this procedure, the user must have the following:

  • “Prospects > Visitors > View“ ability AND
  • The user must be the same as the user that created the export

OR

  • “Admin > Exports > View”

filter_by_created_at

Retrieves all visitor activity records with a created_at value that is greater than the created_after argument and less than the created_before argument.

Arguments

  • created_after : Selects visitor activities that were created after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • created_before : (Optional) Selects visitor activities that were created before the specified time. This value must be after the value in created_after . If this argument isn’t specified, then no upper boundary is used in the query, and all data after the created_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • type : (Optional) Selects visitor activities of the specified types. 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 in Object Field References. Type Session is omitted.
  • prospect_only : (Optional) Selects only those visitor activities associated with a prospect. When this field is set to false , all visitor activities with and without a prospect are returned. The values can be true or false .

filter_by_updated_at

Retrieves all visitor activity records with an updated_at value that is greater than the updated_after argument and less than the updated_before argument.

Arguments

  • updated_after : Selects visitor activities that were updated after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • updated_before : (Optional) Selects visitor activities that were updated before the specified time. This value must be after the value in updated_after . If this argument isn’t specified, then no upper boundary is used in the query, and all data after the updated_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • type : (Optional) Selects visitor activities of the specified types. If this argument isn’t specified, then all visitor activities belonging to any type are returned. See a list of available Visitor Activity Types in Visitor Activity in Object Field References. Type Session is omitted.
  • prospectOnly : (Optional) Selects only those visitor activities associated with a prospect. When this field is set to false , all visitor activities with and without a prospect are returned. The values can be true or false .

The range between created_ater and created_before or between updated_after and updated_before can’t exceed 1 year. When updated_before isn’t specified, the current date is used to gauge the interval.

List Membership

Fields

Select the fields that you want to export. See the fields that are available. The value for fields must be an array of strings of the available fields.

Abilities

Action Requirements
Create export Marketing > Segmentation > Lists > View ability and Prospects > Visitors > View ability
View export Marketing > Segmentation > Lists > View ability and Prospects > Visitors > View ability and ability and be the same user that created the export
View all exports Admin > Exports > View ability
Query exports Admin > Exports > View ability

To create an export with this procedure, the user must have the following:

  • “Marketing > Segmentation > Lists > View“ ability AND
  • “Prospects > Visitors > View“ ability

To view an export with this procedure, the user must have the following:

  • “Marketing > Segmentation > Lists > View“ ability AND
  • “Prospects > Visitors > View“ ability AND
  • The user must be the same as the user that created the export

OR

  • “Admin > Exports > View”

filter_by_created_at

Retrieves all list membership records with a created_at value that is greater than the created_after argument and less than the created_before argument.

Arguments

  • created_after : Selects list membership that were created after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • created_before : (Optional) Selects list membership that were created before the specified time. This value must be after the value in created_after . If this argument isn’t specified, then no upper boundary is used in the query, and all data after the created_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • deleted : (Optional) Selects list membership based on whether it’s deleted or not. The value can be true , false , or all .

filter_by_updated_at

Retrieves all list membership records with a updated_at value that is greater than the updated_after argument and less than the updated_before argument.

Arguments

  • updated_after : Selects list membership that were created after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • updated_before : (Optional) Selects list membership that were created before the specified time. This value must be after the value in updated_after . If this argument isn’t specified, then no upper boundary is used in the query, and all data after the updated_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • deleted : (Optional) Selects list membership based on whether it’s deleted or not. The value can be true , false , or all .

The range between created_after and created_before or between updated_after and updated_before can’t exceed 1 year. When created_before isn’t specified, the current date is used to gauge the interval.

Prospect

Fields

Select the prospect fields that you want to export. See the prospect fields that are available. The value for fields must be an array of strings of the available fields.

Abilities

Action Requirements
Create export Prospects > Visitors > View ability
View export Prospects > Visitors > View ability and be the same user that created the export
View all exports Admin > Exports > View ability
Query exports Admin > Exports > View ability

To create an export with this procedure, the user must have the following:

  • “Prospects > Visitors > View“ ability

To view an export with this procedure, the user must have the following:

  • “Prospects > Visitors > View“ ability AND
  • The user must be the same as the user that created the export

OR

  • “Admin > Exports > View”

filter_by_updated_at

Retrieves all prospect records with a updated_at value that is greater than the updated_after argument and less than the updated_before argument.

Arguments

  • updated_after : Selects prospects that were updated after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • updated_before : (Optional) Selects prospects that were updated before the specified time. This value must be after the value in updated_after . If this argument is not specified, then no upper boundary is used in the query, and all data after the updated_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.

filter_by_created_at

Retrieves all prospect records with a created_at value that is greater than the created_after argument and less than the created_before argument.

Arguments

  • created_after : Selects prospects that were created after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • created_before : (Optional) Selects prospects that were created before the specified time. This value must be after the value in created_after . If this argument is not specified, then no upper boundary is used in the query, and all data after the created_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • deleted : (Optional) Selects prospects based on whether they're deleted or not. The value can be true , false , or all .

The range between created_after and created_before or between updated_after and updated_before cannot exceed 1 year. When updated_before is not specified, the current date is used to gauge the interval.

Prospect Account

Fields

Select the prospect account fields you want to export. See the prospect account fields that are available. The value for fields must be an array of strings of the available fields.

Abilities

Action Requirements
Create export Prospects > Prospect Accounts > View ability
View export Prospects > Prospect Accounts > View ability and be the same user that created the export
View all exports Admin > Exports > View ability
Query exports Admin > Exports > View ability

To create an export with this procedure, the user must have the following:

  • “Prospects > Prospect Accounts > View“ ability

To view an export with this procedure, the user must have the following:

  • “Prospects > Prospect Accounts > View“ ability AND
  • The user must be the same as the user that created the export

OR

  • “Admin > Exports > View”

filter_by_prospect_updated_at

Retrieves all prospect account records associated with a prospect that has an updated_at value that is greater than the prospect_updated_after argument and less than the prospect_updated_before argument.

Arguments

  • prospect_updated_after : Selects prospect accounts associated with a prospect that has been updated after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • prospect_updated_before : (Optional) Selects prospect accounts associated with a prospect that has been updated before the specified time. This value must be after the value in prospect_updated_after . If this argument is not specified, then no upper boundary is used in the query, and all data after the prospect_updated_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • prospect_deleted : (Optional) Selects prospect account based on whether it is associated with a prospect that has been deleted. The value can be true , false , or all . Default value is false .

The range between prospect_updated_after and prospect_updated_before cannot exceed 1 year. When prospect_updated_before is not specified, the current date is used to gauge the interval.

filter_by_updated_at

Retrieves all prospect account records with an updated_at value that is greater than the updated_after argument and less than the updated_before argument.

Arguments

  • updated_after : Selects prospect accounts that have been updated after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • updated_before : (Optional) Selects prospect accounts that have been updated before the specified time. This value must be after the value in updated_after . If this argument is not specified, then no upper boundary is used in the query, and all data after the updated_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • deleted : (Optional) Selects prospect accounts based on whether they have been deleted. The value can be true , false , or all . Default value is false .

The range between updated_after and updated_before cannot exceed 1 year. When updated_before is not specified, the current date is used to gauge the interval.

Visitor

Fields

Select the visitor fields you want to export. See the visitor fields that are available. The value for fields must be an array of strings of the available fields.

Abilities

Action Requirements
Create export Prospects > Visitors > View ability
View export Prospects > Visitors > View ability and be the same user that created the export
View all exports Admin > Exports > View ability
Query exports Admin > Exports > View ability

To create an export with this procedure, the user must have the following:

  • “Prospects > Visitors > View“ ability

To view an export with this procedure, the user must have the following:

  • “Prospects > Visitors > View“ ability AND
  • The user must be the same as the user that created the export

OR

  • “Admin > Exports > View”

filter_by_prospect_updated_at

Retrieves all visitor records associated with a prospect that has an updated_at value that is greater than the prospect_updated_after argument and less than the prospect_updated_before argument.

Arguments

  • prospect_updated_after : Selects visitors associated with a prospect that has been updated after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • prospect_updated_before : (Optional) Selects visitors associated with a prospect that has been updated before the specified time. This value must be after the value in prospect_updated_after . If this argument is not specified, then no upper boundary is used in the query, and all data after the prospect_updated_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • prospect_deleted : (Optional) Selects visitor based on whether it is associated with a prospect that has been deleted. The value can be true , false , or all . Default value is false .

The range between prospect_updated_after and prospect_updated_before cannot exceed 1 year. When prospect_updated_before is not specified, the current date is used to gauge the interval.

filter_by_updated_at

Retrieves all visitor records with an updated_at value that is greater than the updated_after argument and less than the updated_before argument.

Arguments

  • updated_after : Selects visitors that have been updated after the specified time. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • updated_before : (Optional) Selects visitors that have been updated before the specified time. This value must be after the value in updated_after . If this argument is not specified, then no upper boundary is used in the query, and all data after the updated_after is returned. The value can be today , yesterday , last_7_days , this_month , last_month , or a custom time specified in GNU Date Input Syntax format.
  • deleted : (Optional) Selects visitors based on whether they have been deleted. The value can be true , false , or all . Default value is false .

The range between updated_after and updated_before cannot exceed 1 year. When updated_before is not specified, the current date is used to gauge the interval.

Use these endpoints.

Used to initiate the export of an object through a defined procedure.

POST

Request Body

Content-Type must be application/json .

Input Representation

  • object : Specifies which object to export.
  • fields : Specifies the fields that will be exported. If no fields value is given, all available fields are exported.
  • procedure : The procedure to execute. A procedure is a query and execution plan used to retrieve data. Each object has a different set of procedures. See the Procedures section for available procedures.
    • name : The name of the procedure.
    • arguments : Arguments used to manipulate the behavior of the procedure. These arguments are specific to the procedure. See the documentation for the procedure to see which arguments apply. If duplicate argument names are provided the latter value is used.

Success

Status Code: 200

Output Representation

  • id : The ID of the export. ID is used to check the status of the export.
  • state : The state of the export. Displays "Waiting" when the export has been queued for processing, "Processing" when the server is working on the export and "Complete" when the export has completed. See Export State.
  • isExpired : Indicates that the export has expired. When an export has expired, this returns true and no data related to the export can be downloaded.
  • resultRefs : (Optional) This property appears when an export is complete, and it contains a list of URLS to CSV files available for download. If there’s no data associated with the export, this property is absent. If there’s only a single CSV file available for download, this property is a string containing the URL to download the file. If there are multiple CSV files, resultRefs is an array of URLs.
  • createdAt : The date and time the export was created in the timezone of the user making the request.
  • updatedAt : The date and time the export was updated in the timezone of the user making the request.

Errors

  • Status Code: 4xx
  • Error codes: See Error Codes

Example

Here’s a request to execute the visitor activity procedure named filter_by_created_at , which retrieves all visitor activity data where the created_at value is between two dates. In this example, the data is retrieved from December 25, 2019 to December 25, 2020.

After sending the request as a POST , the response is as follows. From this response we know the export is queued for execution but hasn't started or completed. We suggest waiting a few minutes before checking the Read endpoint for the new status.

Used to retrieve the status of the export. When an export is complete, the links to download the results are available in the result body.

GET

Params

{id} : The ID of the export.

Success

Status Code: 200

Output Representation

  • id : The ID of the export. This ID is used to check the status of the export.
  • state : The state of the export. Displays "Waiting" when the export has been queued for processing, "Processing" when the server is working on the export and "Complete" when the export is completed. See Export State.
  • isExpired : Indicates that the export has expired. After an export has expired, this property returns true and no data associated with the export can be downloaded.
  • resultRefs : (Optional) This property appears only when the export has completed and contains a list of URLS to CSV files available for download. If there’s no data associated with the export, this property is absent. If there’s only a single CSV file available for download, resultRefs is a string containing the URL to download the file. If there are multiple CSV files, resultRefs is an array of URLs. The order of the URLs in the array isn’t significant.
  • createdAt : The date and time the export was created in the timezone of the user making the request.
  • updatedAt : The date and time the export was updated in the timezone of the user making the request.

Errors

  • Status Code: 4xx
  • Error codes: See Error Codes

Example

After calling the Create endpoint, the ID of the export is given in the response. This ID is used in the URL to call the Read endpoint.

If the export is waiting to be processed, state is "Waiting", as in the following example.

If the export is finished, state is "Complete" and resultRefs contains URLs to download the CSV files.

Used by administrators to retrieve a list of exports and their status. A user must have the “Admin > Exports > View” ability to execute this endpoint.

GET

Params

  • created_after : (Optional) Filters the results to return only exports that were created after the specified time.
  • created_before : (Optional) Filters the results to return only exports that were created before the specified time.
  • updated_after : (Optional) Filters the results to return only exports that were updated after the specified time.
  • updated_before : (Optional) Filters the results to return only exports that were updated before the specified time.
  • status : (Optional) Filters the results to return exports in the given state. Allowed values are "Complete", "Failed", "Processing", or "Waiting".
  • object : (Optional) Filters the results to return exports for the specified object.
  • sort_by : (Optional) Sorts the results by the specified property value. Allowed values are "id", "created_at", or "updated_at". If not specified, the results are returned by "id" in "descending" order.
  • sort_order : (Optional) Used with sort_by . Adjusts the direction of the sort using the values "ascending" or "descending". If not specified, the results are in "descending" order.

Success

Status Code: 200

Output Representation

  • result : A collection of exports
    • total_results : The total number of results matching the filter.
    • export : A collection of exports. If there are no results, this property is omitted. If there's a single result, it's an object. If there are multiple results, it's an array of results.
      • id : The ID of the export. This ID is used to check the status of the export.
      • state : The state of the export. Displays "Waiting" when the export has been queued for processing, "Processing" when the server is working on the export and "Complete" when the export has completed. See Export State.
      • isExpired : Indicates that the export has expired. After an export has expired, this property returns true and no data associated with the export can be downloaded.
      • createdAt : The date and time the export was created in the timezone of the user making the request.
      • updatedAt : The date and time the export was updated in the timezone of the user making the request.

The export representation returned in query doesn’t contain resultRefs . Use the read endpoint for the export to get the full export representation.

Errors

  • Status Code: 4xx
  • Error codes: See Error Codes

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.

GET

Success

The data represented in CSV format. See the CSV Format section for more information.

Errors

  • Status code: 4xx
  • Error codes: See Error Codes

Used to cancel the export. If the export is already completed or failed, it can't be canceled.

POST

Params

{id} : The ID of the export.

Success

Status Code: 200

Output Representation

  • id : The ID of the export. This ID is used to check the status of the export.
  • state : The state of the export. See Export State.
  • isExpired : Indicates that the export has expired. After an export has expired, this property returns true and no data associated with the export can be downloaded.
  • createdAt : The date and time the export was created in the timezone of the user making the request.
  • updatedAt : The date and time the export was updated in the timezone of the user making the request.

Errors

  • Status Code: 4xx
  • Error codes: See Error Codes & Messages

Example

After calling the Create endpoint, the ID of the export is given in the response. This ID is used in the URL to call the Cancel endpoint.

If the export is not already completed or failed, it is canceled.

Export State

  • "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.
Read article