Table: heroku_app_webhook - Query Heroku App Webhooks using SQL

Heroku App Webhooks is a feature within Heroku that allows you to set up HTTP callbacks to notify you about events happening in your applications. It provides a way to configure and manage webhooks for various Heroku resources, including applications, dynos, and add-ons. Webhooks in Heroku help you stay informed about the operations and performance of your Heroku resources, triggering HTTP callbacks when predefined conditions are met.

Table Usage Guide

The heroku_app_webhook table provides insights into webhook configurations within Heroku applications. As a DevOps engineer, explore webhook-specific details through this table, including webhook URLs, event types, and associated metadata. Utilize it to uncover information about webhooks, such as their current status, the events they are configured to respond to, and the verification of their settings.

Important Notes

List queries require an app_name.
Get queries require an app_name and webhook id.
Pagination is not currently supported for this resource type in the SDK.

Examples

List all webhooks

Discover the segments that have been created within a specific application by analyzing the settings of each webhook. This can help you understand the configuration for each webhook, allowing you to assess the elements within your application and make necessary changes.

select
  id,
  url,
  level,
  created_at
from
  heroku_app_webhook
where
  app_name = 'steampipe';

select
  id,
  url,
  level,
  created_at
from
  heroku_app_webhook
where
  app_name = 'steampipe';

List all notify level webhooks

Explore which webhooks have been set to the 'notify' level within a specific application. This can help in understanding the extent of notifications you're receiving from that application.

select
  id,
  url,
  level,
  created_at
from
  heroku_app_webhook
where
  app_name = 'steampipe'
  and level = 'notify';

select
  id,
  url,
  level,
  created_at
from
  heroku_app_webhook
where
  app_name = 'steampipe'
  and level = 'notify';

Schema for heroku_app_webhook

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of an account.
app	jsonb		Identity of app. Only used for customer webhooks.
app_name	text	=	The app name .
created_at	timestamp with time zone		When the webhook was created.
id	text	=	The webhook's unique identifier.
include	jsonb		The entities that the subscription provides notifications for.
level	text		If `notify`, Heroku makes a single, fire-and-forget delivery attempt.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
updated_at	timestamp with time zone		When the webhook was updated.
url	text		The URL where the webhook's notification requests are sent.

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)" -- heroku

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

steampipe_export_heroku --config '<your_config>' heroku_app_webhook