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
join clause for all queries.
Basic channel info
selecttitle,link,descriptionfromrss_channelwherefeed_link = 'https://steampipe.io/blog/feed.xml'
Basic channel info for multiple feeds
selecttitle,link,descriptionfromrss_channelwherefeed_link in ('https://steampipe.io/blog/feed.xml','https://www.podcastinsights.com/feed/');
Get the type of the channel
selecttitle,feed_type,feed_versionfromrss_channelwherefeed_link = 'https://steampipe.io/blog/feed.xml'
Get categories for the channel
selecttitle,categoriesfromrss_itemwherefeed_link = 'https://www.podcastinsights.com/feed/'
Information about the RSS channel or Atom feed.
|author_email||text||Email of the author.|
|author_name||text||Name of the author.|
|categories||jsonb||Specify one or more categories that the channel belongs to.|
|copyright||text||Copyright notice for content in the channel.|
|description||text||Phrase or sentence describing the channel.|
|extensions||jsonb||Extension data (e.g. Dublin Core, ITunes) for the channel.|
|feed_link||text||URL of the feed itself.|
|feed_type||text||Type of the feed: rss, atom or json.|
|feed_version||text||Version of the feed type, e.g. 2.0|
|generator||text||A string indicating the program used to generate the channel.|
|image_title||text||The title of a GIF, JPEG or PNG image that can be displayed with the channel.|
|image_url||text||The URL of a GIF, JPEG or PNG image that can be displayed with the channel.|
|language||text||The 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.|
|link||text||The URL to the HTML website corresponding to the channel.|
|published||timestamp without time zone||Timestamp when the feed was published.|
|title||text||The 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.|
|updated||timestamp without time zone||Timestamp when the feed was updated.|