Azure Database for MySQL
![](https://connectoricons-prod.azureedge.net/releases/v1.0.1709/1.0.1709.3859/azuremysql/icon.png)
Azure Database for MySQL Flexible Server provides a fully managed database service for app development and deployment with built-in capabilities, such as high availability, read replicas, custom maintenance and more. Use the connector to connect to Azure database for MySQL Flexible Server databases to read/write data and trigger workflows when your data changes.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions |
Power Automate | Premium | All Power Automate regions |
Power Apps | Premium | All Power Apps regions |
Connector Metadata | |
---|---|
Publisher | Microsoft |
Website | https://go.microsoft.com/fwlink/?linkid=2136898 |
Privacy policy | https://go.microsoft.com/fwlink/?linkid=512132 |
Creating a connection
The connector supports the following authentication types:
Basic Authentication | Use a username and password to access your MySQL database. | All regions | 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 |
Basic Authentication
Auth ID: mysqlAuthentication
Applicable: All regions
Use a username and password to access your MySQL 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 |
---|---|---|---|
Server | string | Specify the MySQL server. | True |
Database Name | string | Specify the MySQL database name. | True |
Username | securestring | Username credential | True |
Password | securestring | Password credential | True |
Encrypt Connection | bool | Encrypt Connection |
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.
Throttling Limits
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 200 | 60 seconds |
Actions
Delete row |
This operation deletes a row from a table. |
Execute a MySQL query |
Execute a MySQL query |
Execute Stored Procedure |
This operation runs a stored procedure. |
Get row |
This operation gets a row from a table. |
Get rows |
This operation gets rows from a table. |
Get Stored Procedures |
This operation gets stored procedures for a database. |
Get tables |
This operation gets tables from a database. |
Insert row |
This operation inserts a new row into a table. |
Update row |
This operation updates an existing row in a table. |
Delete row
This operation deletes a row from a table.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL 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 |
Execute a MySQL query
Execute a MySQL query
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL server |
Database name
|
database | True | string |
Database name |
Query
|
query | True | dynamic |
query body |
Returns
Execute Stored Procedure
This operation runs a stored procedure.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL 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
Get row
This operation gets a row from a table.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL server |
Database name
|
database | True | string |
Database name |
Table name
|
table | True | string |
Name of MySQL table |
Row id
|
id | True | string |
Unique identifier of the row to retrieve |
Returns
Get rows
This operation gets rows from a table.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL server |
Database name
|
database | True | string |
Database name |
Table name
|
table | True | string |
Name of MySQL table |
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. |
|
Maximum Get Count
|
$top | integer |
Maximum number of entries to retrieve (default = 512). |
|
Skip Count
|
$skip | integer |
The number of entries to skip (default = 0). |
|
Select Query
|
$select | string |
Specific fields to retrieve from entries (default = all). |
Returns
Get Stored Procedures
This operation gets stored procedures for a database.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL server |
Database name
|
database | True | string |
Database name |
Returns
Represents a list of procedures.
- Body
- ProceduresList
Get tables
This operation gets tables from a database.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL server |
Database name
|
database | True | string |
Database name |
Returns
Represents a list of tables.
- Body
- TablesList
Insert row
This operation inserts a new row into a table.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL 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
Update row
This operation updates an existing row in a table.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL 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
Triggers
When an item is created |
Triggers a flow when an item is created in MySQL |
When an item is modified |
Triggers a flow when an item is modified/inserted in MySQL |
When an item is created
Triggers a flow when an item is created in MySQL
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL server |
Database name
|
database | True | string |
Database name |
Table name
|
table | True | string |
Name of MySQL 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
When an item is modified
Triggers a flow when an item is modified/inserted in MySQL
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Server name
|
server | True | string |
Name of MySQL server |
Database name
|
database | True | string |
Database name |
Table name
|
table | True | string |
Name of MySQL 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
Definitions
Procedure
Procedure.
Name | Path | Type | Description |
---|---|---|---|
Name
|
Name | string |
Procedure name. |
DisplayName
|
DisplayName | string |
Procedure display name. |
ProceduresList
Represents a list of procedures.
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of Procedure |
List of Procedures. |
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. |
TablesList
Represents a list of tables.
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of Table |
List of Tables |