I am our team's Alteryx server and gallery admin. We have a series of workflows that require information from a JSON file that contain credential information to be imported into the workflow so input tool or python tools can use those credentials. That JSON file is located on a physical windows network shared folder so that our whole team can access them without having to resort to using google drive connectors in their workflows. Also because our ODBC connections use those JSON files, so they need to be in a folder where the server itself can access them.
Those JSON files get renewed every Friday at 7:15pm by our IT team and they put the new files on a Google drive folder. I need an automated way to be able to copy that JSON file from Google drive to the physical windows network shared drive folder.
My original plan was to schedule a workflow that copies them from Google drive to the network shared folder, but I see that google drive can only "see" csv, gsheet, xlsx, and yxdb files, so that won't work.
Can anyone think of a way to achieve this with Alteryx or any other method? Keep in mind this needs to happen from the gallery/server when I'm not logged into the server itself via remote desktop connection.
