Getting "'IDENT_CURRENT' is not a recognized built-in function name." error when using Logic App with Synapse

Question

Hi team,

I have an error log table in Synapse (Dedicated SQL pool). I want to send an email to the desired destination whenever a new record is inserted into the log table.

For this purpose, I have created a Logic App with "When an item is created (V2)" trigger and "Send an email (V2)" action.

When I insert a new record into the log table, the logic App doesn't run. When I look at the trigger history, it fails with the below error:

            "code": 502,             "source": "logic-apis-australiaeast.azure-apim.net",             "clientRequestId": "AAAAA",             "message": "BadGateway",             "innerError": {                 "status": 502,                 "message": "'IDENT_CURRENT' is not a recognized built-in function name.\r\nclientRequestId: AAAAA",                 "error": {                     "message": "'IDENT_CURRENT' is not a recognized built-in function name."                 },

I didn't add any query in the logic app.

I found that Synapse doesn't support IDENT_CURRENT function.

Is there any other trigger or action I can use to achieve my goal.

Answer 1

@Mohammad Saber Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

As called out in the public documentation of Synapse Analytics function IDENT_CURRENT is not support in dedicated SQL pools

From the shared workflow image, I can understand that you are using the Sql Server connector in your workflow which is not supported for dedicated sql pools.

Currently SQL server connector in Logic app supported for Azure SQL DB, Azure SQL server, Azure Managed Instance. Refer to this documentation for more information.

Alternatively, you can leverage the existing REST API of Azure Synapse Analytics and try to call them using the Http action in your logic app.

Rest API reference document: https://learn.microsoft.com/en-us/rest/api/synapse/?view=rest-synapse-data-plane-2021-04-01

If none of the existing rest api's are suitable for your scenario, I would suggest you to raise a feedback request here. So that our engineering team will actively monitor this forum and work them based on their feasibility.

Also, I see an active feedback request related to bring Synapse Analytics connector in Logic apps. I would suggest to upvote and comment there as well.

Hope this helps, let me know if you have any further questions on this.