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

Chanthawat Rattanapongphan 1

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?

Mike Urnun 9,761 Reputation points Microsoft Employee

2022-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 Row action 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?
Mike Urnun 9,761 Reputation points Microsoft Employee

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?