SQL Server and Personr 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

Personr

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

Personr

Custom action
Custom action in Personr (Custom)
Create an Entity
Create a new entity in Personr
Generating a verification link
Once you've created an entity, you can generate a hosted link for verification in Personr
Retrieving entity questionnaire answers
If your flow contains a questionnaire or product and plan logic block using Flow Logic, use this endpoint to retrieve the answers inputted by the entity during the verification process
Retrieving entity verification results
Verifications typically take ~2 minutes on average to process. When an entity has finished processing, use this action to retrieve extracted registry data along with the verification result

Any other action you can think up