Syntax: Add Row via API for Multi Select Contact Column, MULTI_CONTACT
Options
Ryan Sides
Community Champion
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.