steampipe plugin install rss

Table: rss_item - Query RSS Feed Items using SQL

An RSS Feed Item is an individual content piece from an RSS feed. These items contain the actual content of the feed, including titles, descriptions, and links to the original content. Each item also carries metadata such as publishing dates, authorship, and categories.

Table Usage Guide

The rss_item table provides insights into individual items within an RSS feed. As a content manager or data analyst, explore item-specific details through this table, including content, metadata, and associated links. Utilize it to uncover information about items, such as their publishing timeline, authorship details, and categorization.

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

Query items from a channel, newest first

Explore the latest items from a specific RSS feed to stay updated with the most recent content. This is especially useful for keeping track of the latest updates on frequently updated websites or blogs.

select
title,
published,
link
from
rss_item
where
feed_link = 'https://www.hardcorehumanism.com/feed/'
order by
published desc;
select
title,
published,
link
from
rss_item
where
feed_link = 'https://www.hardcorehumanism.com/feed/'
order by
published desc;

Count items by category

Explore the distribution of podcast topics from a specific feed. This query helps you understand the most frequent themes or categories in the chosen podcast, providing insights into its content focus.

select
category,
count(*)
from
rss_item,
jsonb_array_elements_text(categories) as category
where
feed_link = 'https://www.podcastinsights.com/feed/'
group by
category
order by
count desc;
select
category,
count(*)
from
rss_item,
json_each(categories) as category
where
feed_link = 'https://www.podcastinsights.com/feed/'
group by
category.value
order by
count(*) desc;

Schema for rss_item

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
author_emailtextEmail address of the author of the item.
author_nametextName of the author of the item.
categoriesjsonbSpecify one or more categories that the item belongs to.
contenttextContent of the item.
descriptiontextThe item synopsis.
enclosuresjsonbMedia objects attached to the item.
extensionsjsonbExtension data (e.g. Dublin Core, ITunes) for the item.
feed_linktext=URL of the feed itself.
guidtextA string that uniquely identifies the item.
image_titletext
image_urltext
linktextThe URL of the item.
publishedtimestamp with time zoneTimestamp when the feed was published.
titletextThe title of the item.
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_item