help to export data with bulk 2.0 exports API

May 28, 2020 6:37PM

Hi Eloqua experts,

I want to export data from one of my Eloqua object using Bulk 2.0 Exports API. I followed the example from Eloqua doc on Exporting data but the example failed when I tested it.

The API endpoint I use is: /bulk/2.0/activities/exports

the export json data is: {
   "name":"Example Activity Export",
   "fields":{
   "ActivityId":"{{Activity.Id}}",
   "AssetName":"{{Activity.Asset.Name}}",
   "ActivityType":"{{Activity.Type}}",
   "ActivityDate":"{{Activity.CreatedAt}}",
   "ContactId":"{{Activity.Contact.Id}}",
   "VisitorId":"{{Activity.Visitor.Id}}",
   "AssetType":"{{Activity.Asset.Type}}",
   "AssetId":"{{Activity.Asset.Id}}",
   "RawData":"{{Activity.Field(RawData)}}"
   },
   "filter":"'{{Activity.Type}}'='FormSubmit'"
}

But POSTMAN came back with 400 error code validation error. The response from Eloqua is:

help to export data with bulk 2.0 exports API

Howdy, Stranger!