Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How to update python code?

S

Hi there!

I’m trying to work out how I could solution the following challenge. 

 

  • A user will use a Smartsheet form to request a backup.
  • I have some python code sitting on a local server, which i have been updating manually with the details from the submitted form. eg. Folder ID
  • The code is then executed as part of a scheduled cron job

 

What i’m looking to do is to take the request details from Smartsheet and parse them into the python file so i don’t need to manually edit files. Are there any ideas as to how i could  achieve this?

 

Note: I’m not looking to execute the python script on Zapier, just, update the code within the python file.

 

Thanks for any help,

 

Sean

Best answer by Sean WilliamsBest answer by Sean Williams

All done!

I went the low tech route - with something that looks like this: 

Trigger: When a row is updated in Smartsheet

Do this:

  Only continue if Backup script created is not true

  Format the filename to replace [space] with _

  Create new text file in OneDrive (based on a template)

  New row update in Smartsheet (update the Backup script created checkbox)

 

All that will remain to be done is to update the file extension from .txt to .py

 

Thanks for your ideas. 

 

Sean

View original
    Did this topic help you find an answer to your question?
    This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

    4 replies

    jpot
    Forum|alt.badge.img+5
    • jpotZapier Staff
    • Zapier Staff
    • 55 replies
    • July 30, 2020

    Hey Sean! This sounds like a really useful workflow. I don’t think we have a way to upload a file to a server, but you could you use something like Dropbox? Our Dropbox integration can add text to and create text files, and I could imagine that working, even if you have to set up a cron task to sync from Dropbox over to your file after. 

    I’d offer more advice but this realllllly seems like it might be over my head—I think pythons are snakes. But I hope the suggestion is helpful. 

    ForYourIT
    Davidh88
    S
    3 people like this
    • ForYourIT
      ForYourIT
    • Davidh88
      Davidh88
    • S
      Sean Williams
    S

    I totally agree! Pythons are snakes :)

    I was taking a look and found OneDrive - create a file from template will be really useful for this, depending on how easy/hard it will be to retrieve the file in OneDrive, otherwise, Dropbox will work too. 

     

    Thanks for your response.

    jpot
    1 person likes this
    • jpot
      jpot
    ForYourIT
    Forum|alt.badge.img+7
    • ForYourITTinkerer
    • Tinkerer
    • 259 replies
    • July 31, 2020

    Great idea @jpot . If that doesn’t work, maybe you can have your python code expose a webhook and let Zapier call this webhook. You can then send some JSON data with all the stuff you need towards the script, which would automatically take actions from there.

    Let us know how it goes! :D

    ~Bjorn

    S
    • Sean WilliamsBeginner
    • Author
    • Beginner
    • 2 replies
    • Answer
    • August 2, 2020

    All done!

    I went the low tech route - with something that looks like this: 

    Trigger: When a row is updated in Smartsheet

    Do this:

      Only continue if Backup script created is not true

      Format the filename to replace [space] with _

      Create new text file in OneDrive (based on a template)

      New row update in Smartsheet (update the Backup script created checkbox)

     

    All that will remain to be done is to update the file extension from .txt to .py

     

    Thanks for your ideas. 

     

    Sean

    nicksimard
    ForYourIT
    2 people like this
    • nicksimard
      nicksimard
    • ForYourIT
      ForYourIT
    Terms & Conditions