Bulk Activity API - Activity Attributes?

[Kurt_Koller]

We've been anticipating the bulk API for retrieving Lead and Activity information. Can't wait.

I've looked over the documentation for the Activity bulk download at http://developers.marketo.com/rest-api/bulk-extract/bulk-activity-extract/

I have a question, I see that I can specify fields and in the documentation it says:

Default fields are: marketoGUID, leadId, activityDate, activityTypeId, campaignId, primaryAttributeValueId, primaryAttributeValue, attributes.  Fields may only be filtered out when exporting activities

That's cool, but where will we get the the attributes we currently get when we download activities? Like on a change value, there's Old Value, New Value, etc, each activity type has specific additional attributes. What field do we specify to get those attributes, and how will they be represented in the resulting CSV, SSV, TSV file? Json in a single column? Any information would be appreciated, and as a suggestion in this case a sample CSV in the documentation would be very useful.

[Kenny_Elkington · Accepted solution]

The secondary attributes will be a JSON structure inside of the “attributes” column if you choose to export as a spreadsheet.  If you choose JSON, it will be an object in the “attributes” member of the activity record.

[Kurt_Koller]

Thanks Kenny. To clarify, if I go through the bulk API I can specify CSV, TSV, and SSV according to the docs. I assume that's what you mean by exporting to a spreadsheet? I don't see anything in the documentation for Bulk API about exporting as JSON? If so, how?

[David_Everly]

Your assumption is correct, specifying CSV, TSV, or SSV in format parameter is what is meant by "export to spreadsheet".  Exporting as JSON is not supported.

[Ian_Cosinas]

Is there a way to include email, firstName, lastName or custom fields in the result? I am getting Invalid Field when adding these fields in the request. Thanks!

[Kurt_Koller]

Those are lead fields and not activity fields.

You will get an activity for change data value for these when they change, like if first name changes the new first name will be in the New Value attribute for that change data value activity. But if you're looking to export lead data that's the bulk lead export, not bulk activity export.

[Ian_Cosinas]

Got it. Thanks!