Multi select column via API shows as a TEXT_NUMBER type

Sean Smith

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

},

Peter Harink

Hi Sean,

You need to use the level argument : <param name="level"> compatibility level </param>

Please have a look at : https://developers.smartsheet.com/blog/leveling-up-understanding-multi-contact-and-multi-picklist-columns-in-the-smartsheet-api

Kind regards,

Peter Harink | 4EF.nl | Consultant & Managing Partner | peter.harink@4ef.nl