MySQL

Reference

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 connector requires Connector/Net 6.6.5+ to be installed. To install Connector/Net, go to release page and download the relevant release. The provider is 32-bit and built with platform ANY CPU so it can be used on any architecture (32-bit or 64-bit) of the product where you intent to use the connector. The minimun supported MySQL database version is version 5.1.

Known issues and limitations

The followings are some of the known limitations of using MySQL connector:

This connector does not support JSON types.
When using Get rows action usage of Order By parameter is recommended to get deterministic results in action output. If Order By is not specified, primary keys are used by MySQL by default. Non-deterministic results may cause issues, such as duplicating records in the action output when pagination is enabled.
Insert row operation requires to provide explicit value for Primary Key column, even though default/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

Operation ID:: DeleteItem

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

Operation ID:: GetItem

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

The outputs of this operation are dynamic.

Get rows

Operation ID:: GetItems

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

The outputs of this operation are dynamic.

Get tables

Operation ID:: GetTables

This operation gets tables from a database.

Returns

Represents a list of tables.

Body: TablesList

Insert row

Operation ID:: PostItem

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.

Update row

Operation ID:: PatchItem

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

The outputs of this operation are dynamic.

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