Unsubscribe Filter | Community
Skip to main content
C
Carlis
New Participant
April 27, 2022
Solved

Unsubscribe Filter

  • April 27, 2022
  • 1 reply
  • 2840 views

The endpoint I'm using is /bulk/v1/leads/export/create.json.  Below is my json for the POST body.  Everything in it is working except the Unsubscribed filter.  What do I have wrong in the json.  The resulting csv file is returning TRUE and FALSE in the Unsubscribed column.

{ "fields":["email", "unsubscribed"], "format":"CSV", "columnHeaderNames":{"email":"Email Address", "unsubscribed":"Unsubscribed Status"}, "filter":{ "createdAt":{"startAt":"2022-03-27T01:29:19-05:00", "endAt":"2022-04-27T01:29:19-05:00"}, "Unsubscribed":true} }

 

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 SanfordWhiteman

Bulk Export doesn’t like system Smart Lists (which is what this looks like from your screenshot). Create a custom SL. Note once you’re using a SL you don’t need to worry about having multiple filter criteria as those can go in the SL itself — it’s far more flexible.

1 reply

Darshil_Shah1
Darshil_Shah1
Community Manager
April 27, 2022

Unfortunately, the filter attribute in the bulk export create job API endpoint does not accept the filter values based on the filed and its value (i.e., something like "Unsubscribed":true isn't supported in the payload)

Below are the accepted filter parameters that you can filter on:

1. createdAt

2. updatedAt

3. staticListName

4. staticListId

5. smartListName

6. smartListId

One way to extract only unsubscribed records is to use the smart list in Marketo with Unsubscribed = TRUE filter and use that as a filter in the payload for extracting the data programmatically via the bulk extract API.

C
CarlisAuthor
New Participant
April 27, 2022

I have an Unsubscribed Smart List.  I've tried smartListName = "Unsubscribed People" and smartListName = "Unsubscribed".  Neither work.  I don't know how to get the smartListId.

 

 

Darshil_Shah1
Darshil_Shah1
Community Manager
April 27, 2022

Well, Marketo's infrastructure supports only one filter type per export job (should've mentioned in the previous comment probably). You may be getting the results based on the first filter type i.e., createdAt filter. You can filter people based on the createdAt filter if that's more important for your use-case, and then strip-out the rows with Unsubscribed Status = false from the response.

Terms & ConditionsAccessibility statement

Loading footer...