Salesforce MultiPicklist Mapping - using brackets | Experience Community
Skip to main content

Salesforce MultiPicklist Mapping - using brackets

  • December 1, 2022
  • 3 replies
  • 267 views
C
Forum|alt.badge.img

I have a survey set up that feeds back into a Salesforce object. Some of the fields are multi-select picklists, for which I have made sure the option text in Qualtrics exactly matches the values in Salesforce. Everything works fine, except for one scenario - if my picklist option has brackets in it, the Mapping fails with the message 'Multipick: bad value for restricted picklist field:'. This does not occur in single-choice picklists with brackets, nor does it occur if I don't select the option with brackets.
This happens even if I simplify the options down to A, B and (C), so it's definitely the brackets that are causing the problem.
Obvious solution, of course is to re-write the options to not use brackets, but that feels like giving in - can anyone else help?

3 replies

vgayraud
QPN Level 7 ●●●●●●●
Forum|alt.badge.img+60
  • vgayraud
  • QPN Level 7 ●●●●●●●
  • December 8, 2022

Could you post the failed run JSON file input and output?

Vincent Gayraud - https://www.linkedin.com/in/vincent-gayraud-790344116/
C
Forum|alt.badge.img

JSON Input:

{
"payload": {
"Fire": true,
"Type": "OutcomeAction",
"action": "Insert",
"actionId": "OCAC_1rdBRO5Nywd7WBg",
"actionType": "createable",
"assignmentRule": true,
"authUser": {
"brandId": "mybrand",
"userId": "UR_3aZJw6JK1kjuwnk"
},
"contextId": "SV_8ukB0f4Z8TVG850",
"createdAt": 1669629885740,
"debugEmail": "",
"elementConfigured": true,
"keyvalues": [
{
"isExternalId": false,
"isKeyRecord": false,
"isPickList": false,
"key": "SampleDate__c",
"label": "SampleDate__c",
"type": {
"limit": 0,
"type": "date"
},
"value": "2011-11-11"
},
{
"isExternalId": false,
"isKeyRecord": false,
"isPickList": false,
"key": "Multipick__c",
"label": "Multipick__c",
"type": {
"limit": 4099,
"type": "multipicklist"
},
"value": "C, (D)"
},
{
"isExternalId": false,
"isKeyRecord": false,
"isPickList": false,
"key": "SinglePick__c",
"label": "SinglePick__c",
"type": {
"limit": 765,
"type": "picklist"
},
"value": ""
}
],
"name": "TestQualtrics",
"objectName": "TestQualtrics",
"objectType": "TestQualtrics__c",
"outcomeId": "OC_x2V1NfLrHT1TQRz",
"ownerObject": {
"orgId": "myOrg",
"userId": ""
},
"sfAccount": {
"label": "myAccount",
"selected": true,
"value": {
"credential": "",
"id": "",
"issuedAt": "2022-11-28T10:03:39.070395Z",
"type": "sandbox"
}
},
"surveyId": "SV_8ukB0f4Z8TVG850",
"taskNumber": 1,
"taskRegistryId": "Salesforce",
"triggerAction": "Salesforce",
"type": "sfResponseMapping",
"updatedAt": 1669887847810
},
"user": {
"userId": "",
"brandId": ""
},
"executionData": {
"workflowId": "R_uh083PNFfqhCdPj-OC_x2V1NfLrHT1TQRz",
"runId": "",
"actionId": "OCAC_1rdBRO5Nywd7WBg",
"contextId": "SV_8ukB0f4Z8TVG850",
"uniqueId": "R_uh083PNFfqhCdPj",
"outcomeId": "OC_x2V1NfLrHT1TQRz",
"taskToken": null,
"attempt": 0,
"orchestrator": "TEMPORAL"
}
}

JSON Output:
{
"name": "The task is configured incorrectly. Review the task’s configuration then try again.",
"message": "[{\\"message\\":\\"Multipick: bad value for restricted picklist field: (D)\\",\\"errorCode\\":\\"INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST\\",\\"fields\\":[\\"Multipick__c\\"]}]",
"needRetry": false
}

C
Forum|alt.badge.img

This the JSON from the test survey I created to prove to myself it was brackets that were the problem.

Terms & ConditionsAccessibility statement