NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr.
ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as expected when you specify an empty array for a MULTI_PICKLIST column. I would expect this to clear all values from the column options, but instead it seems to fail silently (no error is generated, but the column items are not cleared.)
EXAMPLES:
Attempting to include the examples here in the markdown is causing all kinds of weird formatting behavior. Instead I am attaching a text file that has both HTTP Requests and HTTP Response for two API calls, with tokens and ids obfuscated/munged. The first shows what happens when you specify a non-empty array for the options and it responds as expected, which is to set the columns options to be the elements in the array. The second shows what happens when you specify an empty array for the options and it responds not as expected - no error is generated, but the options are left populated as previously.
