Why does the values mapping not work for me?
Question:
I'm attempting to import a CSV file using the following configuration:
{
"objects": [
{
"query": "SELECT Id, Name FROM Contact",
"operation": "Insert",
"externalId": "Name",
"useValuesMapping" : true
}
]
}
I have created a ValueMapping.csv file and enabled the feature with the useValuesMapping=true parameter, but it doesn't seem to work. What could be the issue?
Answer:
Use useValuesMapping=true for value mapping in the current engine.
useCSVValuesMapping is a legacy flag from older configurations and should be replaced with
useValuesMapping.
For your CSV import case, use:
{
"objects": [
{
"query": "SELECT Id, Name FROM Contact",
"operation": "Insert",
"externalId": "Name",
"useValuesMapping" : true
}
]
}