Dela via


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 By parameter, 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 By parameter.

  • 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

The outputs of this operation are dynamic.

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

The outputs of this operation are dynamic.

Get tables

This operation gets tables from a database.

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
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

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