API Backup Python Project

Maxime Champain

Hello there,

 

Currently I'm Trying to do a Python API to backup my company data on smartsheet. I know that there is a Java API but i want to put the script on aws so python is extremely recommended.

I found some stuff like that :

token = ' '

ss = smarsheet.Smartsheet(token)

# I Would like to backup all the file with the structure but i don't how to do that

lstfolder = ss.Home.list_folders()

action = lstfolder.data

for i in action:

     print(i.name) # with that i can have the name of the folder to recreate with os.mkdir

 

I don't know if there is an easier way to backup with python, I don't know how to get the path and keep the same structure as smartsheet view.

 

thanks for the help. I'm up to give more information about what i exactly need to do.

 

regards,

 

Taylor F

Hello Maxime, 

I see that you've written in to our API team with a similar question. Sounds like what you are looking for is a way to download all of your users sheets as an Excel file and maintain the folder structure. This is what our current Java Backup Tool will do. 

If you need to replicate this in Python, you will need to reverse engineer our Java code. 

Python API Documentation: http://smartsheet-platform.github.io/api-docs/?python#smartsheet-api-2-0

Python SDK: https://github.com/smartsheet-platform/smartsheet-python-sdk

If you run into any issues while creating your script, please don't hesitate to reach out to us at api@smartsheet.com 

Our Consulting Team can create this script for you if needed: https://www.smartsheet.com/custom-consulting

-Taylor

Maxime Champain

Yeah I would love to be help but if someone create this for me it's not helping me. Is the custom consulting can help me to understand the python sdk better ?

 

Thanks for your help.

 

regards

J. Craig Williams

Maxime,

Your last comment implies you aren't primarily interested in the solution but in learning to develop this and other solutions using the Python SDK.

The best place to start learning the SDK for me was to start here:

https://github.com/smartsheet-platform

and to post questions on the StackOverflow with the smartsheet-api tag

https://stackoverflow.com/search?q=smartsheet-api

Specifically for Python, I keep this link handy

https://smartsheet-platform.github.io/api-docs/?python#

I hope this helps.

Craig