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
}
]
}