Do everything in one place
Customize your SQL Server and OneDrive integration with the following
triggers and actions.
Triggers
When this happens…
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
OneDrive
- New line in CSV fileNew line in CSV file in OneDrive
- New event Real-timeNew event in OneDrive
- New fileNew file in OneDrive
- New folderNew folder in OneDrive
- New/updated fileNew/updated file in OneDrive
Any other trigger you can think up
Actions
Do this…
SQL Server
- Bulk load from an on-prem fileBulk load rows into a table in SQL Server from an on-prem file
- Delete rows BatchDelete rows in a table in SQL Server
- Execute stored procedure BatchExecute stored procedure in SQL Server
- Export query resultExport query result as a CSV file 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 SQL BatchRun custom SQL in SQL Server
- Run long query using custom SQLRun long query using custom SQL in SQL Server
- Select rows BatchSelect rows in a table in SQL Server
- Select rows using custom SQL BatchSelect 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
OneDrive
- Custom actionCustom action in OneDrive (Custom)
- Create folderCreate folder in Microsoft OneDrive
- Add permissionAdd permission to a file or folder in Microsoft OneDrive
- Delete file or folderDelete file or folder in Microsoft OneDrive
- Remove permissionRemove permission for a file or folder in Microsoft OneDrive
- Download FileDownload file contents in Microsoft OneDrive
- List files and folders BatchList files and folders in Microsoft OneDrive
- List permissions BatchList permissions for a file or folder in Microsoft OneDrive
- Search files BatchSearch files in Microsoft OneDrive
- Upload file via file contentUpload file via file content in Microsoft OneDrive
- Upload file from URLUpload file from URL to Microsoft OneDrive
- Upload large file via sessionUpload large file via file session to Microsoft OneDrive
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