Table: trello_webhook - Query Trello Webhooks using SQL

Trello Webhooks are used to receive immediate updates for events that occur in a Trello Board. They are triggered by events, such as creating a card, updating a list, and other board activities. Webhooks provide a way for applications to get real-time information, making them essential for interactive applications.

Table Usage Guide

The trello_webhook table provides insights into Webhooks within Trello. As a project manager or team lead, explore webhook-specific details through this table, including associated board, list, and card activities. Utilize it to uncover information about events, such as card creation, list updates, and other board activities, helping you track task progress and team activities in real-time.

Important Notes

You must specify Token ID, id_token, in the where clause to query this table.

Examples

Basic info

Explore active webhooks in Trello by identifying their unique IDs and descriptions. This is particularly useful for understanding the context and purpose of each webhook, especially when managing multiple webhooks tied to a specific token.

select
  id,
  active,
  description,
  callback_url,
  id_model
from
  trello_webhook
where
  id_token = '1234ace54605094aa59b02c4b';

select
  id,
  active,
  description,
  callback_url,
  id_model
from
  trello_webhook
where
  id_token = '1234ace54605094aa59b02c4b';

List all active webhooks

Explore which webhooks are currently active in your Trello account. This can help in managing and monitoring the operations triggered by these webhooks.

select
  id,
  active,
  description,
  callback_url,
  id_model
from
  trello_webhook
where
  active
  and id_token = '1234ace54605094aa59b02c4b';

select
  id,
  active,
  description,
  callback_url,
  id_model
from
  trello_webhook
where
  active = 1
  and id_token = '1234ace54605094aa59b02c4b';

Get details of a particular webhook

Analyze the settings of a specific webhook to understand its active status, purpose, and associated model. This is particularly useful when you need to troubleshoot or verify the functionality of a particular webhook.

select
  id,
  active,
  description,
  callback_url,
  id_model
from
  trello_webhook
where
  id = '1234ace54605094aa59b02c4b';

select
  id,
  active,
  description,
  callback_url,
  id_model
from
  trello_webhook
where
  id = '1234ace54605094aa59b02c4b';

Schema for trello_webhook

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
active	boolean		Indicates whether the webhook is active.
callback_url	text		The callback url for the webhook.
description	text		The description of the webhook.
id	text	=	The unique identifier for the webhook.
id_model	text		The id of the model of the webhook.
id_token	text	=	The id of the token the webhook belongs to.
member_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the member.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The title of the webhook.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- trello

You can pass the configuration to the command with the --config argument:

steampipe_export_trello --config '<your_config>' trello_webhook