turbot/rss

steampipe plugin install rsssteampipe plugin install rss

Table: rss_channel

View RSS channel or Atom feed information including title, link, description and metadata.

Note: 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

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

Basic channel info for multiple feeds

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

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

Get categories for the channel

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

.inspect rss_channel

Information about the RSS channel or Atom feed.

NameTypeDescription
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_linktextURL 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 without 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 without time zoneTimestamp when the feed was updated.