Question

Upsert to an MDA object via CSV

  • 22 March 2018
  • 3 replies
  • 73 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

Userlevel 7
Badge +2
Hi Phil, you will indeed have to load via the S3 bucket if you want to upsert data.
Userlevel 7
Badge +1
@Phil, sorry for the inconvenience.Yes,we don't support upsert. Please go with @Spencer suggestion.
Badge
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

Reply