Do everything in one place
Customize your Box and SQL Server integration with the following
triggers and actions.
Triggers
When this happens…
Box
- New upload/download event (beta) Real-timeNew upload/download event in folder
- Monitor sign requests Real-timeMonitor sign requests in Box
- New CSV file in directory BatchNew CSV file in Box
- New/updated file in directoryNew/updated file in Box
- New line in CSV fileNew line in CSV file in Box
- New/updated CSV file in directory BatchNew/updated CSV file in Box
- New/updated file metadata in directoryNew/updated file metadata in Box
- New/updated folder in directoryNew/updated folder in Box
Any other trigger you can think up
SQL Server
- New rowNew row in a table in SQL Server
- New rows BatchNew batch of rows in a table in SQL Server
- New rows via custom SQL BatchNew batch of rows via custom SQL in SQL Server
- Scheduled query BatchScheduled query using custom SQL in SQL Server
- New/updated rowNew/updated row in a table in SQL Server
- New/updated rows BatchNew/updated batch of rows in a table in SQL Server
- New/updated rows via custom SQL BatchNew/updated batch of rows via custom SQL in SQL Server
Any other trigger you can think up
Actions
Do this…
Box
- Custom actionCustom action in Box (Custom)
- Add comment to fileAdd comment to file in Box
- Cancel sign requestCancel sign request in Box
- Create collaborationCreate collaboration in Box
- Create file shared linkCreate shared link for file in Box
- Create folderCreate folder in Box
- Create folder shared linkCreate shared link for folder in Box
- Create file metadataCreate metadata in a file in Box
- Create sign requestCreate sign request in Box
- Download fileDownload contents from a file in Box
- Get file download URLGet file download URL in Box
- List folder itemsList files and folders in a specific folder in Box
- Get file commentsGet file comments in Box
- Get file metadataGet metadata in a file in Box
- Get sign requestGet sign request in Box
- List sign requestsList sign requests in Box
- Rename/move file or folderRename/move file or folder in Box
- Rename other user’s file or folderRename other user's file in Box
- Resend sign requestResend sign request in Box
- Search files/foldersSearch files or folders in Box
- Update CSV file in boxUpdate CSV file in Box
- Update file metadataUpdate metadata in a file in Box
- Upload file using file contentsUpload file using file contents to Box
- Upload file using file URLUpload file from public URL to folder
Any other action you can think up
SQL Server
- Bulk load from an on-prem file BulkBulk load rows into a table in SQL Server from an on-prem file
- Delete rowsDelete rows in a table in SQL Server
- Execute stored procedureExecute stored procedure in SQL Server
- Export query result BulkExport result of custom SQL in SQL Server
- Insert rowInsert row in a table in SQL Server
- Insert rows BatchInsert batch of rows in a table in SQL Server
- Replicate schemaReplicate table schema in SQL Server
- Run custom SQLRun custom SQL in SQL Server
- Run long query using custom SQLRun long query using custom SQL in SQL Server
- Select rowsSelect rows in a table in SQL Server
- Select rows using custom SQLSelect rows using custom SQL in SQL Server
- Replicate rows BatchReplicate batch of rows to table in SQL Server
- Get table schemaGet table schema for SQL Server
- Update rowsUpdate rows in a table in SQL Server
- Update rows BatchUpdate batch of rows in a table in SQL Server
- Upsert rowUpsert row in a table in SQL Server
- Upsert rows BatchUpsert batch of rows in a table in SQL Server
Any other action you can think up
The wonders of Workato
Easily set up as many intelligent automations you need.
- 1000s of ready-to-use templates
- Accelerate work with intelligent automation
- Do it yourself, faster
- Build bots. Put them to work