As you can see in the image below I sent twice the same file with 3 records and they duplicated.
Here is the MDA object Keys
So, how can i set these Keys to upsert this MDA object with my CSV file?
Question
Duplicated data when importing from CSV file to a MDA object
My goal is to have an MDA object being upserted, but I can not tell GainSight which field should be updated and which one should be created.
As you can see in the image below I sent twice the same file with 3 records and they duplicated.
Here is the MDA object Keys
So, how can i set these Keys to upsert this MDA object with my CSV file?
As you can see in the image below I sent twice the same file with 3 records and they duplicated.
Here is the MDA object Keys
So, how can i set these Keys to upsert this MDA object with my CSV file?
Hi Ricardo,
Did you use the "Import Data" route in Data Management to load data via CSV? If that's the case, then it would only insert data, not upsert. 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
Hope this helps! Do reply if this doesn't work for you.
Thanks,
Kunal
Did you use the "Import Data" route in Data Management to load data via CSV? If that's the case, then it would only insert data, not upsert. 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
Hope this helps! Do reply if this doesn't work for you.
Thanks,
Kunal
1 person likes this
Worked like a charm, i upserted the MDA object using Bulk API (basically cURL command)
Thank you
Thank you
Reply
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.