This workflow allows us to monitor the system and recover any CSV files for further inspection or troubleshooting. We will also set it up so that after all the records have been imported, the CSV file will be moved from the Files to Import folder to the Imported Files folder and an email will be sent to notify an admin of the number of records imported. If any new files have been added since the last run, the script will parse the CSV file, loop through the rows and import each row as a new record into a defined Fulcrum app. In our first scenario, we will configure a system where CSV files can be saved to a folder on Drive and a script running on a timer will periodically check the folder for new files. This, combined with Apps Script’s ability to set timed triggers and make external API requests makes it ideal for automating the import and export of Fulcrum data. Scripts are authored in JavaScript via the browser-based code editor, saved in the cloud, and leverage Google’s massive infrastructure.ĭrive has all the features one would expect of a modern file storage platform, including a generous free storage quota, secure sharing mechanisms, mobile apps for both Android & iOS, and desktop apps for integrated backup and sync. It’s worth mentioning again how easy Apps Script makes it integrate with Google services. I highlighted Apps Script in a previous post where we wired up Fulcrum webhooks to build a simple notification system powered by Gmail. We will be leveraging Apps Script, Google’s excellent scripting platform for extending their suite of services. In this post, I’ll walk through how to integrate Fulcrum with Drive, Google’s file storage service. We provide a variety of integration points for getting data both into and out of Fulcrum and offer a full range of Professional Services if you need help getting things wired up. Fulcrum was built to be extensible, enabling users to integrate best-in-class data collection tools with other applications and services for complete workflow customization.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |