SQL Server and SPOTIO 2.0 integration | Workato

Build Powerful Workflows, fast

SQL Server

New row
New row in a table in SQL Server
New rows Batch
New batch of rows in a table in SQL Server
New rows via custom SQL Batch
New batch of rows via custom SQL in SQL Server
Scheduled query Batch
Scheduled query using custom SQL in SQL Server
New/updated row
New/updated row in a table in SQL Server
New/updated rows Batch
New/updated batch of rows in a table in SQL Server
New/updated rows via custom SQL Batch
New/updated batch of rows via custom SQL in SQL Server

Any other trigger you can think up

SPOTIO 2.0

Activity changed Batch Real-time
Monitors for activities that are created or updated in Spotio
Activity deleted Real-time
Monitors for activities that are deleted in Spotio
Record created/updated Batch Real-time
Monitors for data objects (E.G. leads, contacts, opportunities) created or updated in Spotio
Record deleted Real-time
Monitors for data objects deleted in Spotio

Any other trigger you can think up

SQL Server

Bulk load from an on-prem file
Bulk load rows into a table in SQL Server from an on-prem file
Delete rows Batch
Delete rows in a table in SQL Server
Execute stored procedure Batch
Execute stored procedure in SQL Server
Export query result
Export query result as a CSV file in SQL Server
Insert row
Insert row in a table in SQL Server
Insert rows Batch
Insert batch of rows in a table in SQL Server
Replicate schema
Replicate table schema in SQL Server
Run custom SQL Batch
Run custom SQL in SQL Server
Run long query using custom SQL
Run long query using custom SQL in SQL Server
Select rows Batch
Select rows in a table in SQL Server
Select rows using custom SQL Batch
Select rows using custom SQL in SQL Server
Replicate rows Batch
Replicate batch of rows to table in SQL Server
Get table schema
Get table schema for SQL Server
Update rows
Update rows in a table in SQL Server
Update rows Batch
Update batch of rows in a table in SQL Server
Upsert row
Upsert row in a table in SQL Server
Upsert rows Batch
Upsert batch of rows in a table in SQL Server

Any other action you can think up

SPOTIO 2.0

Create activity
Create a new activity (visit, call, email, etc.) in Spotio
Create appointment
Schedule a new appointment with a data object in Spotio
Create data object
Create a new data object in Spotio with all relevant information
Delete data object
Delete a data object permanently or move related records to another parent
Export data objects
Generate a CSV export of your data objects that will be emailed to you
Get activity feed
Get a paginated list of activities with comprehensive filtering options
Get appointment
Get details for a specific appointment using its ID
Get data object by ID
Get complete details for a specific data object using its unique ID
Get user by external id
Get a user in your Spotio account using their external id
Get users
Get a list of users in your Spotio account with basic filtering
Merge data objects
Merge one or more source data objects into a target data object in Spotio
Search data objects
Search and filter data objects in your Spotio account using various criteria
Search users
Search for users in your Spotio account with comprehensive filtering options
Update activity
Update details of an existing activity in Spotio
Update appointment
Update the details of an existing appointment in Spotio
Update data object
Update any fields on an existing data object using its ID

Any other action you can think up