Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,102 questions
Logic App Standard Workflow Built-in Insert Row(SQL Connector) not working/error
Chanthawat Rattanapongphan
1
Reputation point
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?
{count} votes
-
MikeUrnun 5,756 Reputation points2022-11-17T00:38:07.067+00:00 Hi @Chanthawat Rattanapongphan - Thanks for posting on the MS Q&A, and I'm sorry to hear that you've encountered this issue. It looks like the
Insert Rowaction is in Preview so I wouldn't rule out the possibility that there may be an underlying problem with the connector. However, in order to isolate the root cause, I think that we should dig deeper into the issue and try to troubleshoot. Have you tried a simpler Insert operation with the action to determine if it's working as expected?The error message suggests that the action was not able to parse the response which originated from a syntax error. Have you tried capturing the entire SQL query being sent to your SQL server and investigating what exactly might be the specific syntax error?
-
MikeUrnun 5,756 Reputation points
2022-11-18T02:36:37.533+00:00 @Chanthawat Rattanapongphan Just following up here, were you able to drill down into the troubleshooting steps based on the error message?
Sign in to comment