Multi select column via API shows as a TEXT_NUMBER type
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
-
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
Answers
-
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
-
Excellent. Thanks Peter
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives