Azure Database for MySQL

  • Reference

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, at no extra cost. Connect to Azure database for MySQL Flexible Server databases 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
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 connection20060 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
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

Get row

Operation ID:
GetItem

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

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

The outputs of this operation are dynamic.

Get tables

Operation ID:
GetTables

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

Operation ID:
PostItem

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

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

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