Marketo batch uploading | Community
Skip to main content
D
darthzeran
New Participant
September 21, 2021
Question

Marketo batch uploading

  • September 21, 2021
  • 2 replies
  • 3343 views

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.

 

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

2 replies

D
darthzeranAuthor
New Participant
September 22, 2021

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.

 

 

 

 

Jo_Pitts1
Jo_Pitts1
Community Manager
September 22, 2021

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:

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

Cheers

Jo

 

SanfordWhiteman
SanfordWhiteman
New Participant
September 21, 2021

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?

Jo_Pitts1
Jo_Pitts1
Community Manager
September 21, 2021

Or potentially some records that failed the import?

    D
    darthzeranAuthor
    New Participant
    September 22, 2021

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

    Terms & ConditionsAccessibility statement

    Loading footer...