SOLVED

Re: Bulk Export : Filter types

Go to solution
Thomas_Goirand
Level 2

Bulk Export : Filter types

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!

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk Export : Filter types

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

}

View solution in original post

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk Export : Filter types

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
Level 2

Re: Bulk Export : Filter types

As usual, you rock! Thanks for your reply,