Hi Smartsheet friends,
I've been trying to work out a solution for the below and wanted to reach out to the Community to see if this has been accomplished before or if this is even possible. I also want to preface that I am new to API's and development as a whole.
I have a report that automatically runs daily as a .csv file and drops into a folder on my PC. My idea is to leverage Smartsheet API to grab that file and upload it as an attachment to an existing Smartsheet.
I have researched the Developer site, SDK's, Smartsheet API documentation, Smartsheet Bridge, Smartsheet Community, and even had a Smartsheet Pro Desk session; however, I still am coming up short with answers for these questions:
- Where do I put the code that I either write or grab from the Smartsheet API documentation? For example, does this go in Visual Studio or another application?
- How does the API get "triggered" to run and grab the .csv file from the folder on my PC?
I'd love to hear from you all to see if this is something that may have been successfully set up as well as any pointers you might have for this newbie. Thanks in advance!