Custom Objects in Marketo - Part 4 - Bulk Upload | Community
Skip to main content
John_M
Adobe Employee
John_MAdobe Employee
Adobe Employee
September 18, 2015

Custom Objects in Marketo - Part 4 - Bulk Upload

  • September 18, 2015
  • 12 replies
  • 10562 views

In previous entries in this blog series, I've demonstrated how to upload custom object data into marketo using REST and SOAP.. but did you know its also possible to upload data in bulk.. from the Marketo UI, just like you'd upload Lead Data? It's true, and its really cool. The addition of this feature truly brings custom objects within reach for even non technical Marketo users.

If you recall, when we last left our hero (that's me)  We'd created an Automobile object using the new Custom Objects Interface. Since then the Interface has stealthily shifted around a bit, while maintaining the same functionality.

Fig 1: The Automobile's Definition

Fig 2: The Automobile's Attributes

Next up is creating an input file, and here's our sample.

Great! The process is a LOT like uploading bulk leads actually, but here's how it looks. Start out in the lead database under New-->Import Custom Object Data

Select your input file, and choose your options. My file was text, autodetected, and Ive chosen to tell Marketo to use my dedupe field and a link field of email address, which is great for inserts and updates. You can also choose the MArketo GUID as the dedupe mode.

Then.. map the fields to the object fields...

Now you can see the objects in the lead details.

Cool, right?

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

12 replies

A
Anonymous
December 10, 2015

This is cool, thanks! I have some quick questions:

  1. Is there any constraint checking i.e. on the link and unique fields?
  2. Sounds like we can we use this method to upsert a custom object i.e. to update/refresh the object after it's been initially loaded - is that right?
  3. Is there a way of calling this bulk load method from an ETL layer or from a script? Or can we only integrate using the SOAP/REST APIs?

Thanks!

Ross

    Edward_Masson
    Edward_Masson
    Level 10
    January 14, 2016

    This is very cool @John Mattos​!

      John_M
      Adobe Employee
      John_MAdobe EmployeeAuthor
      Adobe Employee
      January 14, 2016

      1. Yes! You'll get errors if the fields are incorrectly populated.

      2. Yes!

      3. I wish... stay tuned.... I've been fighting for that for a LONG time I envision it working like the bulk lead upload API.. nothing yet... but we're talking about.

      John_M
      Adobe Employee
      John_MAdobe EmployeeAuthor
      Adobe Employee
      January 14, 2016

      Thanks! I think its really cool, and a long time coming

      Janine_Willis
      Janine_Willis
      Level 2
      July 13, 2016

      Hi John,

      When I process a bulk upload Marketo doesn't remember my field mappings from the previous bulk upload to the Custom Object. Marketo does this when uploading a list upload. Is this something I can reach out to Support to fix or a known issue? It's a real pain to map 40+ fields on a Custom Object every day. Thanks!

      A
      Anonymous
      September 27, 2016

      Thank you John for this wonderful overview. I just imported custom object data and it was a successful upload. Yet, the custom object data does not display in my Marketo account. Is there a delay before the data displays in Marketo?

      W
      WyattBa
      Level 4
      June 6, 2017

      Hi @John Mattos​,

      Do you know how to bulk delete via REST API? Pasting all the different marketoGUID's or dedupeFields I want to delete seems really painful. Is there a wildcard or another way to delete in mass?

        Srujan_Vishwana
        Srujan_Vishwana
        Level 4
        June 6, 2017

        Hi @Wyatt Bales​

        Below is a syntax which allows us to delete in mass using objects as key differentiators.

        POST /?delete HTTP/1.1

        Host: please.provide.your.host.name.here

        Authorization: authorization string

        Content-Length: Size

        Content-MD5: MD5

        <?xml version="1.0" encoding="UTF-8"?>

        <Delete>

            <Quiet>true</Quiet>

            <Object>

                 <Key>Key</Key>

                 <VersionId>VersionId</VersionId>

            </Object>

            <Object>

                 <Key>Key</Key>

            </Object>

            ...

        </Delete>

        Let me know if this helps.

        Regards,

        Sru

        John_M
        Adobe Employee
        John_MAdobe EmployeeAuthor
        Adobe Employee
        June 6, 2017

        Hey Wyatt.

        Looking at this http://developers.marketo.com/rest-api/lead-database/#objects  you can choose to deleteBy "dedupeFields" , and depending on how your object is set up... you can pas sin whatever dedupe fields you like. If your fields are something like "email" and "uniqueID", you can try passing in only one of them, like "email" to see if it deletes all the custom objects associated with that email.

        my guess is that it will bark at you that you have to include all of the dedupe fields, meaning there isnt really a way to mass delete.. but I'd definitely try it.

        A
        Anonymous
        August 9, 2017

        Hi All,

        Has someone tried dedupeFields with Bulk Import Custom Object API?

        Even when I used dedupeFields, the API still responds with Error 1003.

        {

                    "code": "1003",

                    "message": "Dedupe field 'product_code' not specified in header"

                },

                {

                    "code": "1003",

                    "message": "Dedupe field 'customer_id' not specified in header"

        }

        Appreciate if someone can share how they tackled this?

        Cheers,

        Waqas

        Show more replies
        Terms & ConditionsAccessibility statement

        Loading footer...