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?
Already have an account? Login
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
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: