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--
Solved! Go to Solution.
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--
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.
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?
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--
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!!!
Yeah, the editor stripped out the red dot, unfortunately.
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:
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.
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.