SQL Server

  • Reference

Microsoft SQL Server is a relational database management system developed by Microsoft. Connect to SQL Server to manage data. You can perform various actions such as create, update, get, and delete on rows in a table.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions and Integration Service Environments (ISEs)
Power Automate Premium All Power Automate regions
Power Apps Premium All Power Apps regions
Connector Metadata
Publisher Microsoft

Ensure your account is correctly set up and provisioned as a SQL AAD user prior to using Active Directory authentication in the SQL Server connector. Follow these instructions to do so.

If you're using non-AAD connection types, you should provide the same Server name/Database name as it is defined in the connection (or Use connection settings option).

To learn how to use this connector in Power Apps, go to Connect to SQL Server from Power Apps.

Known issues and limitations with actions

Short description Operation(s) Long description
Get deterministic results in an action output Get rows (V2) Usage of the Order By parameter is recommended in order to get deterministic results in action output. If Order By isn't specified, primary keys or unique keys are used by SQL Server by default. Non-deterministic results might cause issues, such as duplicating records in the action output when pagination is enabled. SQL views don't support primary key, which is the limitation from SQL Server itself.
Execute a SQL query limited support Execute a SQL query (V2) Not supported for on-premises SQL Server.
General CRUD requirements Get row (V2)
Get rows (V2)
Update row (V2)
Delete row (V2)		 String values will be trimmed in the case of Azure SQL instance usage. Therefore, blank strings will be converted into empty strings.

For INSERT and UPDATE operations, the connector will return the updated rows. This requires that the connection will need to have permission to read data from the SQL Server as well.

A Primary Key is required for the following operations:
- GetItem
- PatchItem
- DeleteItem
Aggregation transformation parameter support Get rows (V2) Only the following Aggregation transformations are supported:

- filter: Allows filtering input set. Supports the same expressions as $filter. Example: filter(ColName1 eq 1).

- aggregate: Allows aggregation using one of following methods: average, max, min, sum, countdistinct. Example: aggregate(ColName2 with max as MaxValue).

You can combine several operators separated by forward slashes to express that they are consecutively applied. This means the result of each transformation is the input to the next transformation. Example: filter(ColName1 eq 4)/aggregate(ColName2 with sum as MaxWorkItemId).

Known issues and limitations with triggers

Short description Operation(s) Long description
Modify an item: row operations When an item is modified (V2) Fires on both INSERT and UPDATE row operations.
Modify an item: column requirements When an item is modified (V2) A ROWVERSION or an IDENTITY column is required.
Create an item: column requirement When an item is created (V2) An IDENTITY column is required.
Create an item When an item is created (V2) Use the latest inserted row's identity column value as a threshold (trigger state) in order to identify newly inserted rows later. The logic assumes every new row's identity has to be bigger than the previous one. Therefore, in case identity sequence is reset for a table due to explicit t-sql command or table truncation, trigger logic will skip new rows for the existing flow. There are two different workarounds possible: First, you can reset the flow trigger state by updating the trigger action card (for example, rename it, update parameters, or add a new connection), and save the changes. Or, you can restore the target table identity sequence using the following approach.

Note

Turning off and turning on the flow will not reset the trigger state.

General known issues and limitations

Following are some of the general known issues and limitations of using SQL connector.

  • Stored Procedures can't be invoked from Power Apps.
    • One workaround is to create a flow and invoke the flow from Power Apps.
  • Insert and update to a table doesn't work if you have a SQL Server side Trigger defined on the table. To workaround this issue, you can do either of the following:
    • Use a Stored Procedure or Native Query.
    • Remove the Trigger from your SQL table.
  • When invoking a stored procedure on an on-premises SQL Server, we have the following limitations:
    • Output values for OUTPUT parameters aren't returned. You can still specify input values for OUTPUT parameters.
    • Return value isn't available.
    • Only the first result set is returned.
    • Dynamics schemas aren't supported for result sets.
  • The response size limit is 8 MB through on-premises SQL Server.
  • The request size limit is 2 MB through on-premises SQL Server.
  • The minimum supported version for on-premises SQL Server is SQL Server 2005.
  • The following data types can't be used as query option predicates:
    • date
    • datetime
    • datetime2
    • smalldatetime
  • Currently multiple result sets support is limited for SQL native query execution: only result sets, up to the first empty one result set, will be returned. As a workaround, Stored Procedure usage is proposed.
  • The result set schema after executing SQL queries and stored procedures should contain unique non-empty column names.
  • The result set schema for any operation inside the stored procedure that returns some set of results (for example, any inner SELECT statement) should contain unique non-empty column names.
  • If the SQL query/stored procedure execution time exceeds 110 seconds, actions will timeout. To learn how to execute long-running stored procedures in Logic Apps, and to workaround the execution time limitation, go to Long-Running SQL Stored Procedures in LogicApps.
  • Private endpoint of SQL Server can only be accessed within ISE. To learn more, go to Access to Azure virtual networks.
  • Setting Force Encryption isn't supported. By default, SQL Database and SQL Managed Instance secure customer data by encrypting data in motion with Transport Layer Security (TLS). To learn more information, go to Azure SQL security overview.
  • Using Service Principal to connect to SQL Server is only supported in Logic Apps.
  • Due to current authentication pipeline limitations, AAD guest users aren't supported when using AAD type connections to SQL Server. As a workaround, use SQL/Windows auth type connections.

Special throttling limits

SQL connector has different throttling limits in different cases. In the following table, Native operations include SQL stored procedure and SQL Query. CRUD stands for create, read, update, and delete operations.

Service Environment Operations Name Calls Renewal Period (seconds)
Power Apps Shared Environment All API calls per user 300 30
Power Apps Shared Environment All Concurrent calls per connection 125 -
Logic Apps & Power Automate Shared Environment Native API calls per connection 500 10
Logic Apps & Power Automate Shared Environment CRUD API calls per connection 100 10
Logic Apps & Power Automate Shared Environment Native Concurrent calls per connection 200 -
Logic Apps & Power Automate Shared Environment CRUD Concurrent calls per connection 125 -

Note

Concurrent calls are a number of in-flight requests that a particular connection can make. For example, for Logic Apps native calls, a single connection will be able to make 200 concurrent calls. Any calls after that will return 429 as long as all the 200 calls are still executing. There's no time duration since the calls can take an arbitrary amount of time, but the point of this limit is to prevent a lot of long-running queries from a single connection and not cause it to starve other connections. For example, if a connection makes 200 calls (all at once), and all of them take around 50 seconds to execute, all other calls will fail with 429 for the next 50 seconds. Once one or more queries finish execution and results are returned, any subsequent calls will be processed.

Power Apps data type mappings

SQL Server Power Apps
bigint, decimal, int, money, numeric, smallint, smallmoney, tinyint, float, real Number
char, nchar, varchar, nvarchar, text, ntext Text
bit Boolean
date, datetime/datetime2/smalldatetime, datetimeoffset, time DateTime
uniqueidentifier Guid

Note

If a SQL Server data type isn't listed in the table above, it isn't supported. Examples of unsupported SQL Server data types include: binary(), varbinary(), image, cursor, rowversion, hierarchyid, sql_variant xml, Spatial Geometry Types, Spatial Geography Types, and table.

Power Apps delegable functions and operations for SQL Server

These Power Apps operations, for a given data type, can be delegated to SQL Server for processing (rather than processing locally within Power Apps).

Operation/Function Number Text Boolean DateTime Guid
Filter Yes Yes Yes No [1] Yes
Sort Yes Yes Yes Yes -
SortByColumns Yes Yes Yes Yes -
Search No Yes No No -
Lookup Yes Yes Yes Yes Yes
=, <> Yes Yes Yes No Yes
<, <=, >, >= Yes No No No -
in (substring) - Yes [2] - - -
+ Yes - - No -
- Yes - - No -
* Yes - - No -
/ Yes - - No -
StartsWith - Yes [3] - - -
EndsWith - Yes [4] - - -
IsBlank No [5] No [5] No [5] No [5] No [5]
Len (length) - Yes [6] - - -
Sum Yes - - - -
Average Yes - - - -
Min Yes - - No -
Max Yes - - No -

Note

Expressions joined with And, Or, and Not are delegable to SQL Server.

  1. Direct date filters don't work for SQL Server. However, you can create a calculated column that will work. For instance, ALTER TABLE myTable ADD DateAsInt AS (YEAR([date]) * 10000 + MONTH([date]) * 100 + DAY([date])) and then filter on the calculated number column.
  2. The in (substring) operator. Supported for ("string value" in \<column>), but not for (\<column> in "string value").
  3. StartsWith. Supported for (StartsWith(\<column>, "string value")), but not for (StartsWith("string value", \<column>)).
  4. EndsWith. Supported for (EndsWith(\<column>, "string value")) but not for (EndsWith("string value", \<column>)). If a char(10) column has a value of "hello", EndsWith(\<column>, "llo") will return false, and that's by design. A char(10) column has 10 characters.
  5. An expression such as Filter('[dbo].[MyOrders]', !IsBlank(CustomerId)) won't delegate to the server. However, this is semantically close to Filter('[dbo].[MyOrders]', CustomerId <> Blank()), which does delegate to the server. These expressions differ in that the second expression won't treat the empty string ("") as empty. These expressions aren't equivalent, but the latter might work for your purposes. You can’t use this method for the Guid data type.
  6. Len. Power Apps delegates the Len function, but it might not work as you expect. A char(10) column with value "hello" will always have, in SQL Server, a length of 10, however, Power Apps will treat that string as having a length of 5, which could cause discrepancies and confusion. You shouldn't use char/nchar on the server; use varchar/nvarchar instead.

Use formal parameters

Execute a SQL query [DEPRECATED] and Execute a SQL query (V2) actions allow usage of formal parameters. They're defined as key-value pairs, where key is the parameter name and value is the SQL data type (like INT or NVARCHAR(255)). Once name and data type are defined, a new input field for a value will be shown.

Managed identity authentication

Currently, managed identity authentication is only supported in Logic Apps. Follow the steps below to use it to connect to your SQL data.

  1. Create an Azure Managed Identity.

  2. Enable Azure AD in SQL.

    1. In Azure Portal, navigate to the SQL server to be enabled with AAD authentication.
    2. In the Settings section of the blade, select Activate Directory admin.
    3. Select an Azure AD user account to be made an administrator of the server, choose Select, and then save.

  3. Create a contained user in the database to represent the managed identity. This step requires Microsoft SQL Server Management Studio (SSMS).

    1. Start SSMS and connect to the SQL server that the managed identity will access. Use Active Directory - Universal with MFA support in Authentication, and the Azure AD account that you set as the server administrator.

    2. In the Object Explorer, expand the Databases folder.

    3. Right-click on a user database and select New query.

    4. In the query window, execute the following to link the managed identity to a new user in the database:

       CREATE USER [ExampleManagedIdentityName] FROM EXTERNAL PROVIDER

    5. Clear the query window. Then, run the following line to assign a role to the manage identity:

      ALTER ROLE db_datareader ADD MEMBER [ExampleManagedIdentityName]

  4. If using a user-assigned identity, associate the logic app with the managed identity:

    1. Navigate to the Logic App that will use the managed identity.
    2. Under the Settings section of the blade, select Identity.
    3. Go to the User assigned tab and select Add.
    4. Select the managed identity to be used, and select Add.

Note

The following steps will assign to a managed identity with name ExampleManagedIdentityName the role of db_datareader. When running those commands, remember to use the name of your managed identity (instead of ExampleManagedIdentityName) and assign the correct role for your needs; for example, db_datareader can't execute write operations.

To learn more, go to the following links:

Known issues

If the roles assigned to managed identity are at database level, it won't have the required scopes to list all databases. It will throw an error like the one below when populating the Database name drop-down.

Couldn't retrieve values. Error code: 'Unauthorized', Message: 'Credentials are missing or not valid'.
Inner exception: The credentials provided for the SQL source are invalid

There are two options to fix/work around this:

  1. Give the managed identity a server-level role so it can list all databases.
  2. Enter the name of the database with the Enter custom value option. The actions and following dropdowns will work.

Connector in-depth

To learn about the connector, go to the in-depth section.

Creating a connection

The connector supports the following authentication types:
Azure AD Integrated Use Azure Active Directory to access your SQL database. All regions except US Government (GCC) Not shareable
Azure AD Integrated (Azure Commercial) Use Azure Active Directory to access your SQL database in Azure Commercial. US Government (GCC) only Not shareable
Azure AD Integrated (Azure Government) Use Azure Active Directory to access your SQL database in Azure Government. US Government (GCC) only Not shareable
SQL Server Authentication Use an account name and password to access your SQL database. All regions Shareable
Windows Authentication Use an on-premise Active Directory account name and password to access your SQL database. All regions Shareable
Windows Authentication (Non Shared) Use an on-premise Active Directory account name and password to access your SQL database. All regions Not shareable
Default [DEPRECATED] This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility. All regions Not shareable

Azure AD Integrated

Auth ID: oauth

Applicable: All regions except US Government (GCC)

Use Azure Active Directory to access your SQL database.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Azure AD Integrated (Azure Commercial)

Auth ID: oauthCom

Applicable: US Government (GCC) only

Use Azure Active Directory to access your SQL database in Azure Commercial.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Azure AD Integrated (Azure Government)

Auth ID: oauth

Applicable: US Government (GCC) only

Use Azure Active Directory to access your SQL database in Azure Government.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

SQL Server Authentication

Auth ID: sqlAuthentication

Applicable: All regions

Use an account name and password to access your SQL database.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
SQL server name string Specify the name of the SQL server (server[:port]) True
SQL database name string SQL database name True
Username securestring Username credential True
Password securestring Password credential True
Gateway gatewaySetting On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details

Windows Authentication

Auth ID: windowsAuthentication

Applicable: All regions

Use an on-premise Active Directory account name and password to access your SQL database.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
SQL server name string Specify the name of the SQL server (server[:port]) True
SQL database name string SQL database name True
Username securestring Username credential True
Password securestring Password credential True
Gateway gatewaySetting On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details True

Windows Authentication (Non Shared)

Auth ID: windowsAuthenticationNonShared

Applicable: All regions

Use an on-premise Active Directory account name and password to access your SQL database.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
Username securestring Username credential True
Password securestring Password credential True
Gateway gatewaySetting On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details True

Default [DEPRECATED]

Applicable: All regions

This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
SQL server name string SQL server name True
SQL database name string SQL database name True
Authentication Type string Authentication type to connect to your database
Username securestring Username credential True
Password securestring Password credential True
Gateway gatewaySetting On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details

Throttling Limits

Name Calls Renewal Period
API calls per connection10010 seconds

Actions

Delete row (V2)

This operation deletes a row from a table.
Delete row [DEPRECATED]

This action has been deprecated. Please use Delete row (V2) instead.

This operation deletes a row from a table.
Execute a SQL query (V2)

Execute a SQL query (V2)
Execute a SQL query [DEPRECATED]

This action has been deprecated. Please use Execute a SQL query (V2) instead.

Execute a SQL query
Execute stored procedure (V2)

This operation runs a stored procedure.
Execute stored procedure [DEPRECATED]

This action has been deprecated. Please use Execute stored procedure (V2) instead.

This operation runs a stored procedure.
Get row (V2)

This operation gets a row from a table.
Get row [DEPRECATED]

This action has been deprecated. Please use Get row (V2) instead.

This operation gets a row from a table.
Get rows (V2)

This operation gets rows from a table.
Get rows [DEPRECATED]

This action has been deprecated. Please use Get rows (V2) instead.

This operation gets rows from a table.
Get tables (V2)

This operation gets tables from a database.
Get tables [DEPRECATED]

This action has been deprecated. Please use Get tables (V2) instead.

This operation gets tables from a database.
Insert row (V2)

This operation inserts a new row into a table.
Insert row [DEPRECATED]

This action has been deprecated. Please use Insert row (V2) instead.

This operation inserts a new row into a table.
Transform data using Power Query

Transform data using Power Query. Note: This operation does not work when connecting using SQL Azure AD.
Update row (V2)

This operation updates an existing row in a table.
Update row [DEPRECATED]

This action has been deprecated. Please use Update row (V2) instead.

This operation updates an existing row in a table.

Delete row (V2)

Operation ID:
DeleteItem_V2

This operation deletes a row from a table.

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Table name
 table True string

Name of table
Row id
 id True string

Unique identifier of the row to delete

Delete row [DEPRECATED]

Operation ID:
DeleteItem

This action has been deprecated. Please use Delete row (V2) instead.

This operation deletes a row from a table.

Parameters

Name Key Required Type Description
Table name
 table True string

Name of table
Row id
 id True string

Unique identifier of the row to delete

Execute a SQL query (V2)

Operation ID:
ExecutePassThroughNativeQuery_V2

Execute a SQL query (V2)

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Query
 query True dynamic

query body

Returns

The outputs of this operation are dynamic.

Execute a SQL query [DEPRECATED]

Operation ID:
ExecutePassThroughNativeQuery

This action has been deprecated. Please use Execute a SQL query (V2) instead.

Execute a SQL query

Parameters

Name Key Required Type Description
Query
 query True dynamic

query body

Returns

The outputs of this operation are dynamic.

Execute stored procedure (V2)

Operation ID:
ExecuteProcedure_V2

This operation runs a stored procedure.

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Procedure name
 procedure True string

Name of stored procedure
Parameters list
 parameters True dynamic

Input parameters to the stored procedure

Returns

The outputs of this operation are dynamic.

Execute stored procedure [DEPRECATED]

Operation ID:
ExecuteProcedure

This action has been deprecated. Please use Execute stored procedure (V2) instead.

This operation runs a stored procedure.

Parameters

Name Key Required Type Description
Procedure name
 procedure True string

Name of stored procedure
Parameters list
 parameters True dynamic

Input parameters to the stored procedure

Returns

The outputs of this operation are dynamic.

Get row (V2)

Operation ID:
GetItem_V2

This operation gets a row from a table.

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Table name
 table True string

Name of SQL table
Row id
 id True string

Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get row [DEPRECATED]

Operation ID:
GetItem

This action has been deprecated. Please use Get row (V2) instead.

This operation gets a row from a table.

Parameters

Name Key Required Type Description
Table name
 table True string

Name of SQL table
Row id
 id True string

Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows (V2)

Operation ID:
GetItems_V2

This operation gets rows from a table.

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Table name
 table True string

Name of SQL table
Aggregation transformation
 $apply string

A sequence of OData aggregation transformations
Filter Query
 $filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
 $orderby string

An ODATA orderBy query for specifying the order of entries.
Skip Count
 $skip integer

The number of entries to skip (default = 0).
Top Count
 $top integer

Total number of entries to retrieve (default = all).
Select Query
 $select string

Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Get rows [DEPRECATED]

Operation ID:
GetItems

This action has been deprecated. Please use Get rows (V2) instead.

This operation gets rows from a table.

Parameters

Name Key Required Type Description
Table name
 table True string

Name of SQL table
Aggregation transformation
 $apply string

A sequence of OData aggregation transformations
Filter Query
 $filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
 $orderby string

An ODATA orderBy query for specifying the order of entries.
Skip Count
 $skip integer

The number of entries to skip (default = 0).
Top Count
 $top integer

Total number of entries to retrieve (default = all).
Select Query
 $select string

Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Get tables (V2)

Operation ID:
GetTables_V2

This operation gets tables from a database.

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name

Returns

Represents a list of tables.

Body
TablesList

Get tables [DEPRECATED]

Operation ID:
GetTables

This action has been deprecated. Please use Get tables (V2) instead.

This operation gets tables from a database.

Returns

Represents a list of tables.

Body
TablesList

Insert row (V2)

Operation ID:
PostItem_V2

This operation inserts a new row into a table.

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Table name
 table True string

Name of table
Row
 item True dynamic

Row to insert into the specified table

Returns

The outputs of this operation are dynamic.

Insert row [DEPRECATED]

Operation ID:
PostItem

This action has been deprecated. Please use Insert row (V2) instead.

This operation inserts a new row into a table.

Parameters

Name Key Required Type Description
Table name
 table True string

Name of table
Row
 item True dynamic

Row to insert into the specified table

Returns

The outputs of this operation are dynamic.

Transform data using Power Query

Operation ID:
SqlExecutePassThroughPowerQuery

Transform data using Power Query. Note: This operation does not work when connecting using SQL Azure AD.

Parameters

Name Key Required Type Description
query
 query mquery

Query Text

Returns

The outputs of this operation are dynamic.

Update row (V2)

Operation ID:
PatchItem_V2

This operation updates an existing row in a table.

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Table name
 table True string

Name of table
Row id
 id True string

Unique identifier of the row to update
Row
 item True dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Update row [DEPRECATED]

Operation ID:
PatchItem

This action has been deprecated. Please use Update row (V2) instead.

This operation updates an existing row in a table.

Parameters

Name Key Required Type Description
Table name
 table True string

Name of table
Row id
 id True string

Unique identifier of the row to update
Row
 item True dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Triggers

When an item is created (V2)

Triggers a flow when an item is created in SQL
When an item is created [DEPRECATED]

This action has been deprecated. Please use When an item is created (V2) instead.

Triggers a flow when an item is created in SQL
When an item is modified (V2)

Triggers a flow when an item is modified/inserted in SQL
When an item is modified [DEPRECATED]

This action has been deprecated. Please use When an item is modified (V2) instead.

Triggers a flow when an item is modified/inserted in SQL

When an item is created (V2)

Operation ID:
GetOnNewItems_V2

Triggers a flow when an item is created in SQL

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Table name
 table True string

Name of SQL table
Filter Query
 $filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Top Count
 $top integer

Total number of entries to retrieve (default = all).
Order By
 $orderby string

An ODATA orderBy query for specifying the order of entries.
Select Query
 $select string

Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

When an item is created [DEPRECATED]

Operation ID:
GetOnNewItems

This action has been deprecated. Please use When an item is created (V2) instead.

Triggers a flow when an item is created in SQL

Parameters

Name Key Required Type Description
Table name
 table True string

Name of SQL table
Filter Query
 $filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Top Count
 $top integer

Total number of entries to retrieve (default = all).
Order By
 $orderby string

An ODATA orderBy query for specifying the order of entries.
Select Query
 $select string

Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

When an item is modified (V2)

Operation ID:
GetOnUpdatedItems_V2

Triggers a flow when an item is modified/inserted in SQL

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name
Table name
 table True string

Name of SQL table
Filter Query
 $filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Top Count
 $top integer

Total number of entries to retrieve (default = all).
Order By
 $orderby string

An ODATA orderBy query for specifying the order of entries.
Select Query
 $select string

Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

When an item is modified [DEPRECATED]

Operation ID:
GetOnUpdatedItems

This action has been deprecated. Please use When an item is modified (V2) instead.

Triggers a flow when an item is modified/inserted in SQL

Parameters

Name Key Required Type Description
Table name
 table True string

Name of SQL table
Filter Query
 $filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Top Count
 $top integer

Total number of entries to retrieve (default = all).
Order By
 $orderby string

An ODATA orderBy query for specifying the order of entries.
Select Query
 $select string

Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Definitions

TablesList

Represents a list of tables.

Name Path Type Description
value
 value array of Table

List of Tables

Table

Represents a table.

Name Path Type Description
Name
 Name string

The name of the table. The name is used at runtime.
DisplayName
 DisplayName string

The display name of the table.
DynamicProperties
 DynamicProperties object

Additional table properties provided by the connector to the clients.