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