I've tried different thing but I still get the same error.
When I try the following code:
multival = smart.models.MultiPicklistObjectValue()
multival.values = value
new_cell.strict = True
new_cell.object_value = multival
new_row.cells.append(new_cell)
The column submission looks like:
"{"columnId": 7199257397618564, "objectValue": {"objectType": "MULTI_PICKLIST", "values": ["one", "two"]}, "strict": true}"
The error:
"{"response": {"statusCode": 400, "reason": "Bad Request", "content": {"errorCode": 5536, "message": "The value \"com.navigo.smartsheet.rest.helper.sheet.cell.model.MultiPicklist@1b73a08\" could not be saved in column \"Audience\". This column is restricted to PICKLIST values only.", "refId": "l5hc94o7bn4e"}}}"
When I try:
new_cell.strict = True
new_cell.value = np.asarray(value)
new_row.cells.append(new_cell)
I get:
{"response": {"statusCode": 400, "reason": "Bad Request", "content": {"detail": {"index": 0}, "errorCode": 1012, "message": "Required object attribute(s) are missing from your request: cell.value.", "refId": "11w2h928lwr0c"}}}
Has anyone solved for this? How do you submit a new_row via Python when a column value is a multi picklist?