Logic App Standard Workflow Built-in Insert Row(SQL Connector) not working/error
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.
"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?
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?
@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