Why the Values Mapping does not working for me?


Question.

I'm using the following configuration to import the CSV file:

{
 "objects": [
   {
      "query": "SELECT Id, Name FROM Contact",
      "operation": "Insert",
      "externalId": "Name",
       "useValuesMapping" : true
    }
 ]
}

I've created ValueMapping.csv file and allowed the feature by useValuesMapping=true parameter, but the feature does not work.

What am I doing wrong?


Answer.

You should remember, that there are two different parameters to allow value mapping for csv-to-org and for org-to-org.

For csv-to-org you should use:  useCSVValuesMapping=true

For org-to-org use: useValuesMapping=true

Try the configuration below:

{
 "objects": [
   {
      "query": "SELECT Id, Name FROM Contact",
      "operation": "Insert",
      "externalId": "Name",
       "useCSVValuesMapping" : true // This will enable mapping of CSV values
    }
 ]
}
Last updated on 13th Nov 2023