Bulk activities export for data value changes in a certain field | Community
Skip to main content
Yogesh_Biyani
Yogesh_Biyani
Level 2
June 13, 2020
Question

Bulk activities export for data value changes in a certain field

  • June 13, 2020
  • 1 reply
  • 3684 views

I would like to export data value changes for a field. How do I specify the field in the Bulk Activity Extract?

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

1 reply

Arun_Sharma9
Arun_Sharma9
Level 3
June 15, 2020

Hi @yogesh_biyani ,

 

There is no functionality available in Bulk Activity Export to filter based on field.

 

Marketo do offer to get lead changes based on fields (but it is not bulk), for that you can refer https://developers.marketo.com/rest-api/endpoint-reference/lead-database-endpoint-reference/#!/Activities/getLeadChangesUsingGET

 

Thanks,

Arun Sharma

Arun Sharma
    Yogesh_Biyani
    Yogesh_BiyaniAuthor
    Level 2
    June 15, 2020

    @arun_sharma9  Thanks for the reply.

     

    Lead changes can work but we need the changes for 20k lead ids so we will have to write a script and be cognizat of the API call limits.

     

    On the other hand, since we only need the changes I can limit the bulk export fields to “fields”: [“leadId”, “attributes”] and reduce the export size. Do you know if the 500MB export limit applies to the query or the actual download? 

     

    Yogesh

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    June 15, 2020

    Lead changes can work but we need the changes for 20k lead ids so we will have to write a script and be cognizat of the API call limits.

    You can filter /leadchanges.json by a Static List ID. Yes, you'll need to paginate still, which consumes an API call per 300 records (not lead records, activity records).

     

    On the other hand, since we only need the changes I can limit the bulk export fields to “fields”: [“leadId”, “attributes”] and reduce the export size. Do you know if the 500MB export limit applies to the query or the actual download? 

    It's the download bytes (not clear what you mean by "the query").

    Terms & ConditionsAccessibility statement

    Loading footer...