Multi select column via API shows as a TEXT_NUMBER type

06/18/20
Accepted

I am trying to update the options in a multi select column via API but if fails with

1|bot | [Smartsheet] 2020-06-18T11:12:30.360Z[ ERROR] Request failed after 0 retries

1|bot  | [Smartsheet] 2020-06-18T11:12:30.361Z[  ERROR] PUT https://api.smartsheet.com/2.0/sheets/xxxxxxxxxxxxxxx/columns/xxxxxxxxxxxxxxxxxx

1|bot | [Smartsheet] 2020-06-18T11:12:30.361Z[ ERROR] Response: Failure (HTTP 400)

1|bot |    Error Code: 1060 - Column options are not allowed for column type TEXT_NUMBER.

1|bot |    Ref ID: 1l5wo01sjzakv


When I retrieve the column it is defined as a TEXT_NUMBER in the API return:

{

"id": xxxxxxxxxxxxxxxxxxxxxxxx,

"version": 2,

"index": 70,

"title": "Non-Core Products",

"type": "TEXT_NUMBER",

"options": [

"vCD 9.x",

"vCD 10.x",

"vCAv",

"NSX",

"HCX",

"vSAN",

"vROPs",

"vRNI",

"vRLI",

"vRA",

"SRM",

"Horizon",

"Airwatch",

"Workspace ONE",

"vRO",

"VCF",

"VMC on AWS",

"N/A"

],

"validation": true,

"width": 150

},

Best Answer

Answers

Sign In or Register to comment.