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!
Solved! Go to Solution.
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
}
As usual, you rock! Thanks for your reply,