Insert into smartsheet api dropdown cell with API

Question

I am trying to use the Smartsheet api (Python sdk) to insert values from a text file into individual cells in the Smartsheet. Is it possible to insert a value into a cell with drop downs and choose the desired value of the dropdown (and leave the other options available)? If it's possible the sample code would be much appreciated.

To expand with an example...

Say I have a text file where one of the values to be inserted is "Fridge" and that word needs to be selected in a cell containing four drop down options: Fridge; Washer; Dryer; Microwave. Can I somehow select the "Fridge" option from the drop down list using the API, and leave the other drop down elements available (ie don't just replace the four options with the text "Fridge")?

you'd get more help if you provided an example of code that you tried but couldn't get to work — Andrei R, Nov 08 '17 at 05:29
I was wondering whether it was possible at all. I have searched hard but not found anything that answers the need, hence the question. — Ian Macintosh, Nov 08 '17 at 07:40

Kim Brandl · Accepted Answer · 2017-11-08T18:00:03.793

Yes, it's possible via API to set the selected value for a dropdown list cell in Smartsheet.

Using your example, here's what the dropdown list looks like in my sheet:

To select one of those values for a cell (in an already existing row) in this sheet, I simply execute an Update Row(s) request as shown here, to set the value of the specified cell to "Fridge":

PUT https://api.smartsheet.com/2.0/sheets/SHEET_ID/rows
[
    {
        "id": "ROW_ID", 
        "cells": [
            {"columnId": COLUMN_ID,"value": "Fridge"}
        ]
    }
]

After this API request is executed, I can see that the value "Fridge" is selected for the specified cell in my sheet, and the dropdown list is preserved.

Likewise, if the row doesn't yet exist, you can use the Add Row(s) operation to add the new row with the specified list value selected for the specified cell.

For a code sample that shows how to use the Update Row(s) operation with the Python SDK, see here: https://smartsheet-platform.github.io/api-docs/?python#update-rows.

For a code sample that shows how to use the Add Row(s) operation with the Python SDK, see here: https://smartsheet-platform.github.io/api-docs/?python#add-rows

(Edited answer to add information about the **Add Row(s)** operation. — Kim Brandl, Nov 08 '17 at 18:00

Insert into smartsheet api dropdown cell with API

1 Answers1