Cannon update Synapse Triger via Rest API

Viktor Bakayov 0 Reputation points
2023-02-02T13:00:31.1433333+00:00

Hi Team

I am trying to create and update a synapse trigger via the REST API as described in this documentation link

Creating a trigger works just perfectly, but updating an existing trigger does not happen. The request is received with status 203, but as viewed from the Synapse UI the parameters of the trigger are not updated (for example any of the properties -> recurrence fields)

I did try sending the

'If-Match': '*'

condition as described here in the header of the request but this did not help.

Any guidance on how to successfully update an existing trigger or is this a bug?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,362 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Viktor Bakayov 0 Reputation points
    2023-02-03T10:58:55.0033333+00:00

    Hi Team,

    The trigger has to be stopped first, however, this is not clear by the API response, since the request is accepted (203)

    Using an update with the azure cli did make the hint :)


  2. Viktor Bakayov 0 Reputation points
    2023-02-03T11:02:08.66+00:00

    Hi Team

    The trigger has to be stopped first, however, this is not clear by the API call since it returns a status of accepted (203)

    0 comments No comments