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

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
Answers
-
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.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
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!
-
Hi Genevieve,
I'm looking for a solution similar to the above. Would like to automate (daily) updating a sheet, report, then widget on the Dashboard. Sounds like this can be done through the API (at least mostly), but not through the UI.. Am I correct? I see references to using Data Shuffle but would rather code it and have some flexibility in use and customization.
Thanks,
Steve
-
Hi @SteveW
If you update an underlying sheet, that will automatically update a Report and Dashboard using that sheet as the source. 🙂
The way that you automate updating the sheet will depend on where your data is stored. You can use the API, yes!
Cheers,
GenevieveNeed more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Hi Genevieve,
Thank you so much for the feedback, and so quickly! Now I know the path forward we need to take. No doubt you'll be hearing from me. Thanks again for the fast update!
Steve
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives