Dela via

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

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

Execute a MySQL query

Operation ID:
ExecutePassThroughNativeQuery

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

The outputs of this operation are dynamic.

Execute Stored Procedure

Operation ID:
ExecuteProcedure

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

The outputs of this operation are dynamic.

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

Operation ID:
GetStoredProcedures

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

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.

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

Operation ID:
GetOnNewItems

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

The outputs of this operation are dynamic.

When an item is modified

Operation ID:
GetOnUpdatedItems

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

The outputs of this operation are dynamic.

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