Activities export definitions
Below are example export definition requests for all activity types. Creating an export definition is the first step in exporting records from Eloqua. The examples use all possible export fields for each activity type, but you only need to use the fields you wish to actually export and use. If you expect more than 5,000,000 records to be returned in any given export, be sure to filter the results further. Learn more about exporting activities.
Activity types:
- Bounceback
- Email clickthrough
- Email open
- Email send
- External activities
- Form submit
- Page view
- Subscribe
- Unsubscribe
- Web visit
Important: There is a maximum of 10 contact fields allowed in an activity export definition. The addition of contact fields to activity exports will add to export time. Contact fields cannot be used in the filter.
Bounceback
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='Bounceback'",
"name": "Bulk Activity Export - Bounceback",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactId": "{{Activity.Contact.Id}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
"SmtpErrorCode": "{{Activity.Field(SmtpErrorCode)}}",
"SmtpStatusCode": "{{Activity.Field(SmtpStatusCode)}}",
"SmtpMessage": "{{Activity.Field(SmtpMessage)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Bounceback",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactId": "{{Activity.Contact.Id}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
"SmtpErrorCode": "{{Activity.Field(SmtpErrorCode)}}",
"SmtpStatusCode": "{{Activity.Field(SmtpStatusCode)}}",
"SmtpMessage": "{{Activity.Field(SmtpMessage)}}"
},
"filter": "'{{Activity.Type}}'='Bounceback'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/73",
"createdBy": "API.User",
"createdAt": "2018-09-20T13:36:51.9304577Z",
"updatedBy": "API.User",
"updatedAt": "2018-09-20T13:36:51.9304577Z"
}
Email clickthrough
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='EmailClickthrough'",
"name": "Bulk Activity Export - Email Clickthrough",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"IpAddress": "{{Activity.Field(IpAddress)}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"SubjectLine": "{{Activity.Field(SubjectLine)}}",
"EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
"EmailClickedThruLink": "{{Activity.Field(EmailClickedThruLink)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
"EmailSendType": "{{Activity.Field(EmailSendType)}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Email Clickthrough",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"IpAddress": "{{Activity.Field(IpAddress)}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"SubjectLine": "{{Activity.Field(SubjectLine)}}",
"EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
"EmailClickedThruLink": "{{Activity.Field(EmailClickedThruLink)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
"EmailSendType": "{{Activity.Field(EmailSendType)}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
},
"filter": "'{{Activity.Type}}'='EmailClickthrough'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/65",
"createdBy": "API.User",
"createdAt": "2018-07-17T14:42:39.0510345Z",
"updatedBy": "API.User",
"updatedAt": "2018-07-17T14:42:39.0510345Z"
}
Email open
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='EmailOpen'",
"name": "Bulk Activity Export - Email Open",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"IpAddress": "{{Activity.Field(IpAddress)}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"SubjectLine": "{{Activity.Field(SubjectLine)}}",
"EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
"EmailSendType": "{{Activity.Field(EmailSendType)}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Email Open",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"IpAddress": "{{Activity.Field(IpAddress)}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"SubjectLine": "{{Activity.Field(SubjectLine)}}",
"EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
"EmailSendType": "{{Activity.Field(EmailSendType)}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
},
"filter": "'{{Activity.Type}}'='EmailOpen'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/66",
"createdBy": "API.User",
"createdAt": "2018-07-17T14:50:52.3183789Z",
"updatedBy": "API.User",
"updatedAt": "2018-07-17T14:50:52.3183789Z"
}
Email send
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='EmailSend'",
"name": "Bulk Activity Export - Email Send",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"ContactId": "{{Activity.Contact.Id}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"SubjectLine": "{{Activity.Field(SubjectLine)}}",
"EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
"EmailSendType": "{{Activity.Field(EmailSendType)}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Email Send",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"ContactId": "{{Activity.Contact.Id}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"SubjectLine": "{{Activity.Field(SubjectLine)}}",
"EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
"EmailSendType": "{{Activity.Field(EmailSendType)}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
},
"filter": "'{{Activity.Type}}'='EmailSend'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/67",
"createdBy": "API.User",
"createdAt": "2018-07-17T17:46:28.9274083Z",
"updatedBy": "API.User",
"updatedAt": "2018-07-17T17:46:28.9274083Z"
}
External activities
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}' = 'ExternalActivity'",
"name": "Bulk Activity Export - External Activity",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ExternalAssetName": "{{Activity.ExternalAssetName}}",
"ExternalAssetType": "{{Activity.ExternalAssetType}}",
"ExternalType": "{{Activity.ExternalActivityType}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"ContactId": "{{Activity.Contact.Id}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactId": "{{Activity.Contact.Id}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"CampaignResponseCreatedAt": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - External Activity",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ExternalAssetName": "{{Activity.ExternalAssetName}}",
"ExternalAssetType": "{{Activity.ExternalAssetType}}",
"ExternalType": "{{Activity.ExternalActivityType}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"ContactId": "{{Activity.Contact.Id}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"CampaignResponseCreatedAt": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}"
},
"filter": "'{{Activity.Type}}' = 'ExternalActivity'",
"maxRecords": 5000000,
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/425",
"createdBy": "API.User",
"createdAt": "2023-07-31T23:04:26.4070000Z",
"updatedBy": "API.User",
"updatedAt": "2023-07-31T23:04:26.4070000Z"
}
Form submit
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='FormSubmit'",
"name": "Bulk Activity Export - Form Submit",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"RawData": "{{Activity.Field(RawData)}}",
"FormSubmitSavedId": "{{Activity.Field(FormSubmitSavedId)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Contact.Field(C_EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Form Submit",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"RawData": "{{Activity.Field(RawData)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Contact.Field(C_EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
},
"filter": "'{{Activity.Type}}'='FormSubmit'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/68",
"createdBy": "API.User",
"createdAt": "2018-07-17T17:51:21.6851479Z",
"updatedBy": "API.User",
"updatedAt": "2018-07-17T17:51:21.6851479Z"
}
Page view
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='PageView'",
"name": "Bulk Activity Export - Page View",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"WebVisitId": "{{Activity.Field(WebVisitId)}}",
"Url": "{{Activity.Field(Url)}}",
"ReferrerUrl": "{{Activity.Field(ReferrerUrl)}}",
"IpAddress": "{{Activity.Field(IpAddress)}}",
"IsWebTrackingOptedIn": "{{Activity.Field(IsWebTrackingOptedIn)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Contact.Field(C_EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"LinkedToContactDate": "{{Activity.Field(LinkedToContactDate)}}",
"PageViewSavedId": "{{Activity.Field(PageViewSavedId)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Page View",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"WebVisitId": "{{Activity.Field(WebVisitId)}}",
"Url": "{{Activity.Field(Url)}}",
"ReferrerUrl": "{{Activity.Field(ReferrerUrl)}}",
"IpAddress": "{{Activity.Field(IpAddress)}}",
"IsWebTrackingOptedIn": "{{Activity.Field(IsWebTrackingOptedIn)}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Contact.Field(C_EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"LinkedToContactDate": "{{Activity.Field(LinkedToContactDate)}}",
"CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
"CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
},
"filter": "'{{Activity.Type}}'='PageView'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/69",
"createdBy": "API.User",
"createdAt": "2018-07-17T17:54:06.3563512Z",
"updatedBy": "API.User",
"updatedAt": "2018-07-17T17:54:06.3563512Z"
}
Subscribe
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='Subscribe'",
"name": "Bulk Activity Export - Subscribe",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"ContactId": "{{Activity.Contact.Id}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Subscribe",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"ContactId": "{{Activity.Contact.Id}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}"
},
"filter": "'{{Activity.Type}}'='Subscribe'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/74",
"createdBy": "API.User",
"createdAt": "2018-09-20T13:38:55.5560961Z",
"updatedBy": "API.User",
"updatedAt": "2018-09-20T13:38:55.5560961Z"
}
Unsubscribe
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='Unsubscribe'",
"name": "Bulk Activity Export - Unsubscribe",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"ContactId": "{{Activity.Contact.Id}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Unsubscribe",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
"ContactId": "{{Activity.Contact.Id}}",
"AssetType": "{{Activity.Asset.Type}}",
"AssetName": "{{Activity.Asset.Name}}",
"AssetId": "{{Activity.Asset.Id}}",
"CampaignId": "{{Activity.Campaign.Id}}",
"CRMCampaignId": "{{Activity.Campaign.Field(CRMCampaignId)}}",
"CampaignName": "{{Activity.Campaign.Field(CampaignName)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Field(EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}"
},
"filter": "'{{Activity.Type}}'='Unsubscribe'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/75",
"createdBy": "API.User",
"createdAt": "2018-09-20T13:42:03.4178334Z",
"updatedBy": "API.User",
"updatedAt": "2018-09-20T13:42:03.4178334Z"
}
Web visit
Request:
POST /activities/exports
Request body:
{
"filter": "'{{Activity.Type}}'='WebVisit'",
"name": "Bulk Activity Export - Web Visit",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"ReferrerUrl": "{{Activity.Field(ReferrerUrl)}}",
"IpAddress": "{{Activity.Field(IpAddress)}}",
"NumberOfPages": "{{Activity.Field(NumberOfPages)}}",
"FirstPageViewUrl": "{{Activity.Field(FirstPageViewUrl)}}",
"Duration": "{{Activity.Field(Duration)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Contact.Field(C_EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"LinkedToContactDate": "{{Activity.Field(LinkedToContactDate)}}",
"WebVisitSavedId": "{{Activity.Field(WebVisitSavedId)}}"
}
}
Response body:
{
"name": "Bulk Activity Export - Web Visit",
"fields": {
"ActivityId": "{{Activity.Id}}",
"ActivityType": "{{Activity.Type}}",
"ActivityDate": "{{Activity.CreatedAt}}",
"ContactId": "{{Activity.Contact.Id}}",
"VisitorId": "{{Activity.Visitor.Id}}",
"VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
"ReferrerUrl": "{{Activity.Field(ReferrerUrl)}}",
"IpAddress": "{{Activity.Field(IpAddress)}}",
"NumberOfPages": "{{Activity.Field(NumberOfPages)}}",
"FirstPageViewUrl": "{{Activity.Field(FirstPageViewUrl)}}",
"Duration": "{{Activity.Field(Duration)}}",
"ExternalId": "{{Activity.ExternalId}}",
"EmailAddress": "{{Activity.Contact.Field(C_EmailAddress)}}",
"ContactIdExt": "{{Activity.Contact.Field(ContactIDExt)}}",
"LinkedToContactDate": "{{Activity.Field(LinkedToContactDate)}}",
"WebVisitSavedId": "{{Activity.Field(WebVisitSavedId)}}"
},
"filter": "'{{Activity.Type}}'='WebVisit'",
"dataRetentionDuration": "PT12H",
"uri": "/activities/exports/39",
"createdBy": "API.User",
"createdAt": "2017-08-09T16:14:57.0142347Z",
"updatedBy": "API.User",
"updatedAt": "2017-08-09T16:14:57.0142347Z"
}