# Webhooks ## Documentation The webhooks: addresses Pipedrive notifies of changes. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Settings` - Primary Keys: `id` - Retrieve: True - Insert: True - Update: False - Delete: True ## Table Columns The columns of the table `Webhooks` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `add_time` | `datetime` | | ☐ | The date when the Webhook was added. | | `admin_id` | `int64` | | ☐ | The ID of the admin of the Webhook. | | `company_id` | `int64` | | ☐ | The ID of the company related to the Webhook. | | `event_action` | `varchar2` | | ☐ | The Webhook action. | | `event_object` | `varchar2` | | ☐ | The Webhook object. | | `http_auth_password` | `varchar2` | | ☐ | The password of the subscription_url of the Webhook. | | `http_auth_user` | `varchar2` | | ☐ | The username of the subscription_url of the Webhook. | | `id` | `int64` | | ☑ | The ID of the Webhook. | | `is_active` | `varchar2` | | ☐ | The is active. | | `last_delivery_time` | `datetime` | | ☐ | The last delivery time of the Webhook. | | `last_http_status` | `int64` | | ☐ | The last delivery HTTP status of the Webhook. | | `name` | `varchar2` | | ☐ | The Webhook name. | | `owner_id` | `int64` | | ☐ | The ID of the user who owns the Webhook. | | `remove_reason` | `varchar2` | | ☐ | The removal reason of the Webhook (if removed). | | `remove_time` | `datetime` | | ☐ | The date when the Webhook was removed (if removed). | | `subscription_url` | `varchar2` | | ☐ | The subscription URL of the Webhook. | | `type` | `varchar2` | | ☐ | The type of the Webhook. | | `user_id` | `int64` | | ☐ | The ID of the user related to the Webhook. | | `version` | `varchar2` | | ☐ | The Webhook version. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `owner_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `user_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform |