Bulk Activity API - Activity Attributes? | Community
Skip to main content
Kurt_Koller
Kurt_Koller
Level 4
June 9, 2017
Solved

Bulk Activity API - Activity Attributes?

  • June 9, 2017
  • 2 replies
  • 6302 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Kenny_Elkington

    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.

    2 replies

    Kenny_Elkington
    Adobe Employee
    Kenny_ElkingtonAdobe EmployeeAccepted solution
    Adobe Employee
    June 9, 2017

    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
      Kurt_KollerAuthor
      Level 4
      June 14, 2017

      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?

      E
      Adobe Employee
      everlyAdobe Employee
      Adobe Employee
      June 21, 2017

      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
      Ian_Cosinas
      Level 1
      June 22, 2017

      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
      Kurt_KollerAuthor
      Level 4
      June 22, 2017

      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
      Ian_Cosinas
      Level 1
      June 22, 2017

      Got it. Thanks!

      Terms & ConditionsAccessibility statement

      Loading footer...