Kurt_Koller

I won't belabor this, but CSV != SQL dump, and again, the Marketo UI CSV dump of the lead data from the UI (same data) does the (correct in my opinion) ,, behaviour and doesn't include the word null for missing data.

Sanford,The CSV export from the Marketo UI does exactly what I suggest.

I will add logic to our parsers to look for a null string and replace it with an actual null in our database. One thing that gets lost is that sometimes people end up with the text "null" in a field in Marketo because of import issues etc, and encoding nulls the way they are currently encoded in bul...

OK. Here's my $0.02 on this.I'd say that CSV is a loose standard that existed well before JSON became a thing, and I've never seen a CSV implementation where null is returned.The JSON spec says you can have a string, numeric, or null for a value. The parsers can look for this easily, because a strin...

My other response didn't post for some reason. Thanks for #1 request, and thanks for #4. Appreciate all your answers.

David Everly​ thanks for the response. With #2, I just pulled an export of leads from the UI with the same fields, and none of them contain the word null in them. Sample line from the CSV for my account in our system, note the ,,, and not ,null,null,null:1013663,kk@digitalpi.com,Digital Pi,2016-04-2...

Nish Vel​I haven't seen that, I've seen missing marketoGUID in bulk export and I've raised a support ticket but don't have resolution yet. I've been away from the project a little while I'm waiting for resolution. I haven't seen duplicates but honestly I was stymied by the lack of a key and didn't n...

thanks, the accept header wasn't working for us at launch, I will try again. Appreciate all your responses over the last few days.

Thanks Dave! It would be great if we could manage the files in daily quota/delete them for more quota. There are some instances where it's 250M-500M a day in activities and getting any kind of history is a very long and arduous process.Thanks again

You could look at the Bulk Extract API for Leads. Once you have the initial leads pulled, you can pull just updates every night via the Bulk Extract. The initial pull isn't straightforward either using the regular API that you specify or the bulk extract, you'll have to do some kind of loop with eit...