topic Hello All, I am getting array data from API, I am inserting it in salesforce in a multiselect picklist field but I am getting the data there as array, but I want the values in picklist separately, what can I use to do this. I am attaching screenshots in Workato Pros Discussion Board

Hello All, I am getting array data from API, I am inserting it in salesforce in a multiselect picklist field but I am getting the data there as array, but I want the values in picklist separately, what can I use to do this. I am attaching screenshots

harendra — Thu, 14 Jul 2022 18:04:40 GMT

Re: Hello All, I am getting array data from API, I am inserting it in salesforce in a multiselect picklist field but I am getting the data there as array, but I want the values in picklist separately, what can I use to do this. I am attaching screenshots

scharan — Thu, 14 Jul 2022 18:34:33 GMT

Hi Hrendra

Did you specify the response schema so that each value will be saved in a list format with field names.

So that you can use one the one which you want.

Re: Hello All, I am getting array data from API, I am inserting it in salesforce in a multiselect picklist field but I am getting the data there as array, but I want the values in picklist separately, what can I use to do this. I am attaching screenshots

p-held — Fri, 15 Jul 2022 20:57:14 GMT

Hi Harendra,

for me it worked to send a string with the values separated with semicolon to Salesforce for a multiselect picklist field.

So in your case just do listname.pluck('fieldname').join(';') with your list and map the resultstring to the Salesforce field which should lool like SF_fieldname:"a;b;c"