Bulk Export : Filter types | Community
Skip to main content
Thomas_Goirand
Thomas_Goirand
Level 2
January 9, 2019
Solved

Bulk Export : Filter types

  • January 9, 2019
  • 1 reply
  • 3122 views

Hello there,

I just tried to work on exporting .csv file of Smart Lists and Static Lists for use in Power BI. Actually, I do not really understand if the doc is not up to date or if my code is mistaken. So far, I have been only able to use the filter : CreatedAt. Not working with any of staticList or smartList filters I tried.

Here is some example of code I can't get working. I built it using the doc here : http://developers.marketo.com/rest-api/bulk-extract/bulk-lead-extract/#creating_a_job

{
"fields":[
     "utmcampaign",
     "sourcecampagne",
     "firstName",
     "Id",
     "lastName",
     "leadowner",
     "leadStatus",
     "createdAt",
     "updatedAt"
     ],
"format": "CSV",
"filter":"staticListID":"4508"
}

Any expert having some advice?

PS : Happy new year y'all!

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

Your example isn't valid JSON, so that wouldn't work in any case.

And staticListID is spelled wrong, it's staticListId.

And staticListId is an Integer, not a String!

So try

{
  "staticListId" : 1234
}

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
January 9, 2019

Your example isn't valid JSON, so that wouldn't work in any case.

And staticListID is spelled wrong, it's staticListId.

And staticListId is an Integer, not a String!

So try

{
  "staticListId" : 1234
}
    Thomas_Goirand
    Thomas_GoirandAuthor
    Level 2
    January 9, 2019

    As usual, you rock! Thanks for your reply,

    Terms & ConditionsAccessibility statement

    Loading footer...