Skip to main content
ricardo
ricardo
Contributor ⭐️⭐️
June 21, 2018
Question

Duplicated data when importing from CSV file to a MDA object

  • June 21, 2018
  • 3 replies
  • 119 views
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?

    3 replies

    kunal_bhat
    kunal_bhat
    Helper ⭐️⭐️⭐️
    June 22, 2018
    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
     
      ricardo
      ricardoAuthor
      Contributor ⭐️⭐️
      June 25, 2018
      Worked like a charm, i upserted the MDA object using Bulk API (basically cURL command)
      Thank you
        kunal_bhat
        kunal_bhat
        Helper ⭐️⭐️⭐️
        June 25, 2018
        Awesome! Thanks for asking!
          Terms & ConditionsAccessibility statement