MySQL
MySQL is an open-source relational database management system. Connect to on-premise MySQL database to read and write data.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - China Cloud operated by 21Vianet |
| Power Apps | Premium | All Power Apps regions except the following: - China Cloud operated by 21Vianet |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://www.mysql.com/ |
| Privacy policy | https://www.oracle.com/legal/privacy/ |
Prerequisites
MySQL database 5.1 or later
Connector/NET 6.6.5 or later. Download and install the relevant release from the Connector/NET General Availability Releases page.
The 32-bit provider is built with platform "ANY CPU", so you can use the provider on any architecture (32-bit or 64-bit) of the product where you plan to use the connector.
General known issues and limitations
Not supported: Azure Database for MySQL, JSON types
Get rows action: If you don't use the
Order Byparameter, MySQL uses primary keys. This behavior produces non-deterministic results in the action's output that might cause issues, such as duplicating records in the action's output when pagination is enabled.To get deterministic results in the action's output, make sure to use the
Order Byparameter.Insert row action: You must provide an explicit value for the primary key column, even though the default or autoincrement value is defined.
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Shareable |
Default
Applicable: All regions
Parameters for creating connection.
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 |
| Authentication Type [Select Basic] | 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 | True |
| Encrypt Connection | bool | Encrypt Connection |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 300 | 60 seconds |
Actions
| Delete row |
This operation deletes a row from a table. |
| Get row |
This operation gets a row from a table. |
| Get rows |
This operation gets rows from a table. |
| 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 |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of table |
|
Row id
|
id | True | string |
Primary key of the row to delete |
Get row
This operation gets a row from a table.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of MySql table |
|
Row id
|
id | True | string |
Primary key of the row to retrieve |
Returns
Get rows
This operation gets rows from a table.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
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 tables
Insert row
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
Update row
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 |
Primary key of the row to update |
|
Row
|
item | True | dynamic |
Row with updated values |
Returns
Definitions
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 |