Skip to main content
phil_hart
phil_hart
Contributor ⭐️⭐️⭐️
March 22, 2018
Question

Upsert to an MDA object via CSV

  • March 22, 2018
  • 3 replies
  • 103 views
I'm looking to upsert records into an MDA object from a CSV via the "Import Data" function. However, you are only able to perform insert operations here.

Does anyone have a good workaround to upsert from a CSV into an MDA object? Would I have to upload to our S3 bucket?

    3 replies

    spencer_engel
    spencer_engel
    Expert ⭐️
    March 22, 2018
    Hi Phil, you will indeed have to load via the S3 bucket if you want to upsert data.
      sai_ram
      sai_ram
      Expert ⭐️⭐️
      March 28, 2018
      @Phil, sorry for the inconvenience.Yes,we don't support upsert. Please go with @Spencer suggestion.
      phanindra_sambaraju
      Gainsight Employee ⭐️
      phanindra_sambaraju
      Gainsight Employee ⭐️
      June 26, 2018
      Hi Phil,

      The "Import Data" in Data Management supports only insert data, not upsert. The intention of "Import Data" functionality is never to ingest data into the objects and we can not load more than 1 MB file via this route. If you want to perform an upsert operation, consider using the Bulk API connector or the S3 connector. You can use your CSV to upsert data in either case.

      Details about those routes can be found here:
      S3 Connector
      Bulk API
        Terms & ConditionsAccessibility statement