Marketo batch uploading

7 replies
3386 views
Translate All

Is there a limit to the number of leads that can be in a REST API csv upload to marketo using the `bulk/v1/leads.json` call? I uploaded a 9MB file with 113592 leads in it, but only 112900 made it into marketo.

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

SanfordWhiteman

User Group Leader

The limit should be bytes, not leads (and of course you’re under the byte limit). Are you sure there wasn’t a chunk of duplicates?

Translate

Jo_Pitts1

Community Advisor

Or potentially some records that failed the import?

Translate

D

darthzeranAuthor

Level 2

no records failed the import, per me checking the failure batch API route.

Translate

D

darthzeranAuthor

Level 2

The file can contain any number of records, so long as the file totals less than 10MB in size<-- as per the docs.

I was using the REST API to upload documents of 9 and 5 MB, but each time, it would not process all the records. I decided to try to upload the files manually through the website, and I got file too large errors until I used a 1MB file.

Translate

Jo_Pitts1

Community Advisor

Ryan,

Congratulations on getting a solution - even if it is one that I imagine didn't please you much.

Another alternative would be to not use the bulk api, but to submit the records in batches of 300 via the regular API.

There are significant benefits to using the API, namely:

You can dedupe on things other than email address
You can detect bad data and correct in your loader

Cheers

Jo

Translate

Sign up

Login with SSO

Login to the community

Login with SSO