Logic App Standard Workflow Built-in Insert Row(SQL Connector) not working/error

Chanthawat Rattanapongphan 1 Reputation point
2022-11-14T10:42:58.327+00:00

Hi, I'm trying to build standard workflow in logic app utilizing built-in SQL-Connector. I always get BadGateway Error from Insert Row Action with the following error code.

{
"code": "ServiceProviderActionFailed",
"message": "The service provider action failed with error code 'ServiceOperationFailed' and error message 'Parse error at line: 1, column: 61: Incorrect syntax near 'OUTPUT'.'."
}

I then try to use Execute Query Action with the same connection and it's working properly.
So my question is How can I make Insert Row Action work? What is the required parameter? Are there any documentation on SQL-Server Built-in Connector Action?

260132-screen-shot-2022-11-14-at-53751-pm.png

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,994 questions
{count} votes