Power Platform Community Forum Thread Details

Hello Everyone,

everytime i use the insert rows of both Azure Db for MySql and Mysql connectors they work and insert the rows into my table. But they end the flow with a BadRequest warning as it follows:

Azure Db for MySql error:

"status": 400,

"message": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1\r\nclientRequestId: XXXXXXXXXXXXXX",

"error": {

"message": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"

"source": "azuremysql-bs.azconn-bs-001.p.azurewebsites.net"

Mysql error:

"body": {

"status": 400,

"message": "We can't update the value. The operation or its arguments aren't supported by the value.\r\n inner exception: We can't update the value. The operation or its arguments aren't supported by the value.\r\nclientRequestId: 3983d5a5-1df4-4faf-a3d7-7fe4508546c8",

"error": {

"source": "mysql-bse.azconn-bse.p.azurewebsites.net"

Please, I need to figure it out ASAP.

Categories:

Using connectors