Upsert to an MDA object via CSV

  • 2
  • Problem
  • Updated 4 months ago
  • Solved
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?
Photo of Phil Hart

Phil Hart

  • 418 Points 250 badge 2x thumb

Posted 7 months ago

  • 2
Photo of Spencer Engel

Spencer Engel, Employee

  • 5,844 Points 5k badge 2x thumb
Hi Phil, you will indeed have to load via the S3 bucket if you want to upsert data.
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 13,270 Points 10k badge 2x thumb
@Phil, sorry for the inconvenience.Yes,we don't support upsert. Please go with @Spencer suggestion.
Photo of Phanindra Sambaraju

Phanindra Sambaraju, Employee

  • 290 Points 250 badge 2x thumb
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
(Edited)