What is SQL Server? 

How to connect your SQL Server account to Zoho Flow

1. Select the required trigger or action. If you select a trigger, click Next.
2. If there are no existing SQL Server connections in your account, click Connect. Otherwise, click New.
   Alternatively, you can create a new connection by navigating to Settings, then Connections. Click Create connection and choose SQL Server.
3. Enter a connection name.
4. Check the App is installed on-premises box if you're using the on-prem version of SQL Server. Leave it unchecked for the cloud version or if your account is hosted publicly.
   Note: For a cloud database, you need to allow-list Zoho Flow's IP addresses in your inbound rule.
5. For an on-prem setup, choose an on-prem agent from the dropdown to create a Zoho Flow connection with your local machine. If you don't already have an agent installed, click New.
6. Configure the following fields to create the connection:
   Host: The URL of your hosted server
   Port: The port number that your server is running on, typically 1433.
   Username: Your SQL Server username
   Password: Your SQL Server password
   Database: The name of the SQL Server database that you want to access
   Enable SSL?: The option to use SSL (Secure Sockets Layer) for encrypted communication between the SQL Server client and server
7. Once configured, click Authorize.
   

Triggers and actions available in Zoho Flow

Triggers

Note:

To use the Row added and the Row added or updated triggers, you need to configure the following fields:

1. Trigger column: Select a unique column with incremental values — ideally timestamp columns such as created_at, updated_at, published_at, etc.  By default, the result is sorted in ascending order, and the limit is 100.
2. Where condition: Use a Where condition to filter the rows. Zoho Flow will retrieve only rows added after the last execution of the flow, so you receive only the latest updates that satisfy the Where condition.
   

You can use Filter criteria when using these triggers to selectively pass information based on your custom criteria instead of passing the entire payload.

Actions

Note: The maximum number of records that can be fetched in a single execution is 100.

To use the Fetch row action, you need to configure the following fields: