Hi,
I’ll start by saying that I am quite new to Python and coding in general.
I’ve been using a workflow that extracts data from a googlesheet and outputs it to a json file which is then linked to an populates and after effects project. It then renders the file in the background before launching AME to compress the file and share it. Currently I have been launching this through Atom.
I wanted to change this workflow to using Anvil instead and have the json generated from table data. So when someone filled out a form it could automatically create the json file and run the after effects render in the background.
What I am struggling with is producing a local file on my computer. Can I have the json file outputted to a specific location?
Perhaps with my lack of coding experience I am missing the obvious.
Thanks
Hi @simon.antonelli - welcome to the forum!
The good news is that what you’re doing is definitely possible. What I’d suggest is using Anvil to work with the data and generate the JSON you want, then use a little Uplink script on your computer to write that JSON into the right location. (As a bonus, it could also kick off the rendering process! We have at least one user who uses a similar architecture to drive CAD software from a web app.)
Thanks so much! I hadn’t considered using Uplink it that way but it makes perfect sense.
Hi there,
Thanks again, you’re advice worked really well! I was able to data the data through and render with a single click 
I had a follow up question in terms of video delivery: What would work best, uploading back to the Anvil App to be viewed by the user or link to them via a 3rd party like Wistia?
Kind regards
S