Dropping this here in the hopes Google picks it up for future developers.
At times when you cannot use the SDKs for adding rows via the API with multi-select contact columns (i.e. Bridge), the following body payload syntax is correct for posting new rows to a sheet.
[
{
"cells": [
{
"columnId": 4532552246972292,
"value": "Test Row 1"
},
{
"columnId": 1154852526444420,
"objectValue": {
"objectType": "MULTI_CONTACT",
"values": [
{
"objectType": "CONTACT",
"email": "user1.email@smartsheet.com",
"name": "User One"
},
{
"objectType": "CONTACT",
"email": "user2.mail@smartsheet.com",
"name": "User Two"
}
]
}
}
]
},
{
"cells": [
{
"columnId": 4532552246972292,
"value": "Test Row 2"
},
{
"columnId": 1154852526444420,
"objectValue": {
"objectType": "MULTI_CONTACT",
"values": [
{
"objectType": "CONTACT",
"email": "user1.email@smartsheet.com",
"name": "User One"
},
{
"objectType": "CONTACT",
"email": "user2.mail@smartsheet.com",
"name": "User Two"
}
]
}
}
]
}
]
Please feel free to add any other related syntax that may not be clear in the API docs to this thread.
