Filtering Bulk Activity Extract API by List ID | Community
Skip to main content
Gulsah_Semiz
Level 1
Sep 30, 2019 8:20 PM UTC
Solved

Filtering Bulk Activity Extract API by List ID

Hi -- I have a question about the Bulk Activity Extract API. Is there a way to filter it by the list id? I tried the following codes, but it didn't work:

{
"format": "CSV",
"filter": {
"staticListId": 12345,
"createdAt": {
"startAt": "2019-08-01T00:00:00-00:00",
"endAt": "2019-08-31T23:59:59-00:00"
},
"activityTypeIds": [
1
]
}
}

{ 
"format": "CSV",
"filter": { 
"listId": 12345,
"createdAt": { 
"startAt": "2019-08-01T00:00:00-00:00",
"endAt": "2019-08-31T23:59:59-00:00"
},
"activityTypeIds": [ 
1
]
}
}

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Mark_PriceAccepted solution
Level 6
Sep 30, 2019 8:37 PM UTC

Pretty sure that filter is only for the Lead Extract:

https://developers.marketo.com/rest-api/bulk-extract/bulk-lead-extract/#filters 

Bulk Activity will let you filter by activityId but that will give you all 'Added to List' activities. You could filter this further in your code but seems like this strategy would extract more data than what's needed. 

3 replies

Gulsah_Semiz
Level 1
Sep 30, 2019 8:43 PM UTC

Got it. Thanks, Mark!

I also tried exporting activities calling this endpoint (https://developers.marketo.com/rest-api/lead-database/activities/) but it became so time-consuming as I couldn't find a way to automate the process. 

Translate
SanfordWhiteman
Level 10
Oct 2, 2019 6:04 AM UTC

Weird that you'd say that IMO, because using the paginated Activities endpoint is easier to automate than the Bulk Extract, since it doesn't require any polling or job coordination.  You just charge straight through, following each new page (and of course being ready to refresh the token as necessary).

Translate
Mark_PriceAccepted solution
Level 6
Sep 30, 2019 8:37 PM UTC

Pretty sure that filter is only for the Lead Extract:

https://developers.marketo.com/rest-api/bulk-extract/bulk-lead-extract/#filters 

Bulk Activity will let you filter by activityId but that will give you all 'Added to List' activities. You could filter this further in your code but seems like this strategy would extract more data than what's needed. 

Translate