Using Python to connect to READ, ADD, UPDATE, DELETE from Smartsheet

FOttolini

Dear Colleagues,

I definitely need your help.

I am using the example https://github.com/smartsheet-samples/python-read-write-sheet/blob/master/python-read-write-sheet.py to connect to Smartsheet, but the end is always a new Sheet ID with the data I retrieved from Excel.

What I want to do:

Connect to a specific Sheet ID;

Retrieve rows, columns, cells as needed (READ);

ADD, UPDATE, DELETE cells, columns, rows to a specific Sheet ID.

I have tried my best to try to make it work. I just can't. Can you please help? It is really important for a project I am working on.

Thanks in advance for all your help.

Kind Regards,

Fabio Ottolini

Genevieve P.

Hi @FOttolini

It sounds like you're using the API to Import a sheet, which will always create a new sheet, as you've found (see the UI explanation, here: Import Files to Create New Sheets)

Instead you'll want to use Get Sheet to retrieve information, and then use one of the Update commands for when you want to update that specific sheet.

• Get Sheet
• Update Rows
• Update Column

Cheers,

Genevieve

FOttolini

Thanks a lot! Very useful indeed. The problem with the example I have sent is that as an inexperienced Smartsheet user, it seems there is something obscure going on. Again, thank you!