Smartsheet Salesforce Integration: "Value is not supported for this column Type."

Gbhagia

I have created Workflow for bi-directional sync in the Smartsheet Salesforce Connector between Salesforce and Smartsheet.

In Salesforce, I have a Lookup(User) field named "Assigned To" and in Smartsheet, I have a corresponding "Assignee" column with the Multi-Select Contact List data type.

When I update the "Assignee" column in Smartsheet, it syncs correctly to Salesforce. However, when I update the "Assigned To" field in Salesforce, I get the following error:

"Smartsheet REST exception occurred.

Error code: 1235.

Error Message: Value is not supported for this column type. Use objectValue instead."

How can I correctly map the "Assigned To" field from Salesforce to the Multi-Select Contact List column in Smartsheet without this error?

Any insights or solutions would be greatly appreciated!

Thanks.

prime_nathaniel

@Gbhagia

This is very interesting, I would have thought SMAR built the API dynamically into their connector, but anyways the object format for multi contact is actually different than that for single contact fields.

If it is behaving as you described it is a limitation of connector. Below is the correct JSON formatting for single vs multi contact. Notice that single used ObjectValue but multi uses Multi contact type and an array of objects with contact type.

So what does that mean for you, basically it means that you will need to pick a SINGLE contact column as your target for SDFC to SMAR.

Single contact looks like

{

            "columnId": 7079310979714948,

            "objectValue": "m@primeconsulting.com"

},

Multi contact looks like

{

            "columnId": 183174050303876,

            "objectValue": {

            "objectType": "MULTI_CONTACT",

            "values": [

                {

                    "objectType": "CONTACT",

                    "email": "m@primeconsulting.com",

                    "name": "m@primeconsulting.com",

                    "imageId": "u!1!zrNUs5NX3Ds!wjnVfxsJuD8!bIK_ui9l-8o"

                },

                {

                    "objectType": "CONTACT",

                    "email": "n@primeconsulting.com",

                    "name": "Nathaniel Kam",

                    "imageId": "u!1!e5kqRzIrIzo!5RMoeYpbbzo!EF1zsRF2725"

                },

                {

                    "objectType": "CONTACT",

                    "email": "test@test.com",

                    "name": "test@test.com"

                }

            ]

        }