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?
Question
Upsert to an MDA object via CSV
+5Hi Phil, you will indeed have to load via the S3 bucket if you want to upsert data.
+1@Phil, sorry for the inconvenience.Yes,we don't support upsert. Please go with @Spencer suggestion.
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
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
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.