steampipe plugin install rss

Table: rss_channel - Query RSS Channel using SQL

RSS (Really Simple Syndication) Channel is a web feed that allows users to access updates to online content in a standardized, computer-readable format. These feeds can, for example, allow a user to keep track of many different websites in a single news aggregator. The news aggregator will automatically check the RSS feed for new content, allowing the content to be automatically passed from website to user.

Table Usage Guide

The rss_channel table provides insights into RSS channels across various websites. As a content manager or a web developer, explore channel-specific details through this table, including title, description, link, language, and copyright. Utilize it to monitor the updates of different websites in an automated and efficient manner.

Important Notes

  • It's not possible to list all feeds in the world, so this table requires a feed_link qualifier to be passed in the where or join clause for all queries.

Examples

Basic channel info

Discover the segments of a specific RSS feed by analyzing the title, link, and description. This could be beneficial for understanding the content and structure of the feed for further analysis or content curation.

select
title,
link,
description
from
rss_channel
where
feed_link = 'https://steampipe.io/blog/feed.xml';
select
title,
link,
description
from
rss_channel
where
feed_link = 'https://steampipe.io/blog/feed.xml';

Basic channel info for multiple feeds

Explore multiple RSS feeds to uncover their basic channel information. This can be useful for comparing content across different sources or tracking updates from preferred feeds.

select
title,
link,
description
from
rss_channel
where
feed_link in (
'https://steampipe.io/blog/feed.xml',
'https://www.podcastinsights.com/feed/'
);
select
title,
link,
description
from
rss_channel
where
feed_link in (
'https://steampipe.io/blog/feed.xml',
'https://www.podcastinsights.com/feed/'
);

Get the type of the channel

Explore the type and version of a specific RSS feed to understand its format and compatibility. This is particularly useful when integrating or troubleshooting RSS feed readers.

select
title,
feed_type,
feed_version
from
rss_channel
where
feed_link = 'https://steampipe.io/blog/feed.xml';
select
title,
feed_type,
feed_version
from
rss_channel
where
feed_link = 'https://steampipe.io/blog/feed.xml';

Get categories for the channel

Discover the segments that categorize a specific podcast channel, which can be useful for understanding the content scope and audience interest areas of the channel.

select
title,
categories
from
rss_item
where
feed_link = 'https://www.podcastinsights.com/feed/';
select
title,
categories
from
rss_item
where
feed_link = 'https://www.podcastinsights.com/feed/';

Schema for rss_channel

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
author_emailtextEmail of the author.
author_nametextName of the author.
categoriesjsonbSpecify one or more categories that the channel belongs to.
copyrighttextCopyright notice for content in the channel.
descriptiontextPhrase or sentence describing the channel.
extensionsjsonbExtension data (e.g. Dublin Core, ITunes) for the channel.
feed_linktext=URL of the feed itself.
feed_typetextType of the feed: rss, atom or json.
feed_versiontextVersion of the feed type, e.g. 2.0
generatortextA string indicating the program used to generate the channel.
image_titletextThe title of a GIF, JPEG or PNG image that can be displayed with the channel.
image_urltextThe URL of a GIF, JPEG or PNG image that can be displayed with the channel.
languagetextThe language the channel is written in. This allows aggregators to group all Italian language sites, for example, on a single page. A list of allowable values for this element, as provided by Netscape, is here. You may also use values defined by the W3C.
linktextThe URL to the HTML website corresponding to the channel.
publishedtimestamp with time zoneTimestamp when the feed was published.
titletextThe name of the channel. It's how people refer to your service. If you have an HTML website that contains the same information as your RSS file, the title of your channel should be the same as the title of your website.
updatedtimestamp with time zoneTimestamp when the feed was updated.

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

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

steampipe_export_rss --config '<your_config>' rss_channel