SSIS Components for Monday

Build 24.0.9060

Webhooks

Get a collection of webhooks.

Table-Specific Information

Select

The component uses the Monday API to process WHERE clause conditions built with the following column and operator. The component processes other filters client-side within the component.

  • BoardId supports the '=' comparison operator.
For example, the following query isare processed server side:
SELECT * FROM Webhooks WHERE BoardId='5574930939'

INSERT

The following inputs can be used in INSERT statements:

BoardId, Config, Event, Url

INSERT INTO Webhooks (BoardId,Config,Event,Url) VALUES ('5574930939','{\"columnId\":\"status\", \"columnValue\":{\"$any$\":true}}','change_status_column_value','https://test.com/')

DELETE

You can delete entries by specifying the Id.

DELETE FROM Webhooks WHERE Id='242031214'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The webhooks's unique identifier.

BoardId String False

Board unique identifier.

Config String False

The webhooks's config.

Event String False

The event webhook will listen to.

The allowed values are change_column_value, create_column, change_status_column_value, change_subitem_column_value, change_specific_column_value, create_item, create_subitem, create_update, edit_update, delete_update, create_subitem_update, change_subitem_name, change_name, item_deleted, subitem_deleted, item_archived, subitem_archived, item_restored, item_moved_to_any_group, item_moved_to_specific_group, move_subitem.

AppWebhooksOnly Bool False

Filters webhooks that were created by the app initiating the request.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Url String

The webhook URL.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060