SOLVED

Bulk Import Lead - throws 611 system error

Go to solution
WolframLotz
Level 4

Bulk Import Lead - throws 611 system error

Hi everyone, 
I'm trying to generate a bulk import for leads. I used the documentation as refrence

https://developers.marketo.com/rest-api/bulk-import/bulk-lead-import/


But unfortunately I always receive a system error. Can anybody help and knows whats wrong?

The respond I receive:

{
    "requestId": "103cc#180703deac5",
    "success": false,
    "errors": [
        {
            "code": "611",
            "message": "System error"
        }
    ]
}


What I do
POST:

{{base_url}}/bulk/v1/leads.json?format=csv


Header:

Content-Type:multipart/form-data; boundary=------WebKitFormBoundaryBQACkJZyaiIAXog
Host:784-BQV-997.mktorest.com


Body
- This is just a test due to the documentation to ensure that the error is not caused by my csv data

------WebKitFormBoundaryBQACkJZyaiIAXogC
Content-Disposition: form-data; name="file"; filename="leads.csv"
Content-Type: text/csv
 
FirstName,LastName,Email,Company
Able,Baker,ablebaker@marketo.com,Marketo
Charlie,Dog,charliedog@marketo.com,Marketo
Easy,Fox,easyfox@marketo.com,Marketo
------WebKitFormBoundaryBQACkJZyaiIAXogC--





 

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk Import Lead - throws 611 system error


Tried a bit around but was not able to find a mistake. Basically originally it was 1:1 the example code from the documentation.

Well, you can’t go trusting that now! 🙂

 

Looks like you have extra whitespace on what you think is an empty line (and which must be empty to conform to the MIME standard). I’ve purposely used a symbol to show it:

 

------WebKitFormBoundaryBQACkJZyaiIAXogC
Content-Disposition: form-data; name="file"; filename="leads.csv"
Content-Type: text/csv
␠
FirstName,LastName,Email,Company
Able,Baker,ablebaker@marketo.com,Marketo
Charlie,Dog,charliedog@marketo.com,Marketo
Easy,Fox,easyfox@marketo.com,Marketo

------WebKitFormBoundaryBQACkJZyaiIAXogC--

 

 

 

 

 

 

 

View solution in original post

8 REPLIES 8
SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk Import Lead - throws 611 system error

Your Content-Type header and the actual body are out of sync. The header should be:

Content-Type:multipart/form-data; boundary=----WebKitFormBoundaryBQACkJZyaiIAXog

 

 Note 4 hyphens, not 6.

WolframLotz
Level 4

Re: Bulk Import Lead - throws 611 system error

Hi @SanfordWhiteman 
thanks this helped a lot. 

Unfortunately it now says 

{
    "requestId": "f3e5#18074a085fe",
    "success": false,
    "errors": [
        {
            "code": "613",
            "message": "Invalid multipart request"
        }
    ]
}


Tried a bit around but was not able to find a mistake. Basically originally it was 1:1 the example code from the documentation. 
Do you have any idea? 

Tags (1)
SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk Import Lead - throws 611 system error


Tried a bit around but was not able to find a mistake. Basically originally it was 1:1 the example code from the documentation.

Well, you can’t go trusting that now! 🙂

 

Looks like you have extra whitespace on what you think is an empty line (and which must be empty to conform to the MIME standard). I’ve purposely used a symbol to show it:

 

------WebKitFormBoundaryBQACkJZyaiIAXogC
Content-Disposition: form-data; name="file"; filename="leads.csv"
Content-Type: text/csv
␠
FirstName,LastName,Email,Company
Able,Baker,ablebaker@marketo.com,Marketo
Charlie,Dog,charliedog@marketo.com,Marketo
Easy,Fox,easyfox@marketo.com,Marketo

------WebKitFormBoundaryBQACkJZyaiIAXogC--

 

 

 

 

 

 

 

Jo_Pitts1
Level 10 - Community Advisor

Re: Bulk Import Lead - throws 611 system error

FWIW @SanfordWhiteman , I can't see the red dot when viewing, but I can see a special character (sp) when I reply to you.  And then you edited your reply to show the SP.  Funny!!!

SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk Import Lead - throws 611 system error

Yeah, the editor stripped out the red dot, unfortunately.

Davidw2022
Level 1

Re: Bulk Import Lead - throws 611 system error

Hey all, I just started using the bulk import lead testing today. After reading through the previous comments and made with corrections I am still getting the 611 system error code. Could you please give me some advice. Appreciated.

 

What I do:

 

Post:

{{base_url}}//bulk/v1/leads.json?format=csv

 

 

Headers:

Content-Type: multipart/form-data; boundary=----WebKitFormBoundaryBQACkJZyaiIAXog        (Note: With 4 hyphens only)

Content-Length: 311

Host:<munchkinId>.mktorest.com                                                                                                                (Note: Fill in with our munchkinId)

 

 

Params:

format:csv

 

 

Body (raw):

------WebKitFormBoundaryBQACkJZyaiIAXogC
Content-Disposition: form-data; name="file"; filename="leads.csv"
Content-Type: text/csv

FirstName,LastName,Email,Company
Able,Baker,ablebaker@marketo.com,Marketo
Charlie,Dog,charliedog@marketo.com,Marketo
Easy,Fox,easyfox@marketo.com,Marketo
------WebKitFormBoundaryBQACkJZyaiIAXogC--

 

 

Body(form-data)

filename: leads.csv                                                                                                                              (Note: Attach with leads.csv file)

 

 

Response:

{
"requestId": "118cf#1850c127f10",
"success": false,
"errors": [
{
"code": "611",
"message": "System error"
}
]
}

 

 

SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk Import Lead - throws 611 system error

Please use the syntax highlighter (Insert/Edit code sample) to make your requests and responses readable, as is used in earlier posts in the thread.

Davidw2022
Level 1

Re: Bulk Import Lead - throws 611 system error

Thank you for your response. Following the Marketo Bulk Lead Import documentation as well as the comments from this thread. I am still getting 611 system errors when testing it on Postman. Really appreciate your guidance.

 

Post:

{{base_url}}//bulk/v1/leads.json?format=csv

 

Headers (The actual munchkinId is filled within "Host"):

 

Content-Type: multipart/form-data; boundary=----WebKitFormBoundaryBQACkJZyaiIAXog        
Content-Length: 311
Host:<munchkinId>.mktorest.com                                                                                                                

 

Body:

 

------WebKitFormBoundaryBQACkJZyaiIAXogC
Content-Disposition: form-data; name="file"; filename="leads.csv"
Content-Type: text/csv

FirstName,LastName,Email,Company
Able,Baker,ablebaker@marketo.com,Marketo
Charlie,Dog,charliedog@marketo.com,Marketo
Easy,Fox,easyfox@marketo.com,Marketo
------WebKitFormBoundaryBQACkJZyaiIAXogC--

 

Response:

{
"requestId": "118cf#1850c127f10",
"success": false,
"errors": [
{
"code": "611",
"message": "System error"
}
]
}

 

Notes:

1.I updated the Content/Type with 4 hyphens rather than 6

2.I updated deleted the empty space within the body

3.I attached the lead.csv file in the body form-data section in postman.