turbot / steampipe-plugin-rss

Use SQL to instantly query RSS channels and Atom Feeds. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/rss
Apache License 2.0
11 stars 2 forks source link

Add support for feed link in config file. Closes #24 #25

Closed bigdatasourav closed 10 months ago

bigdatasourav commented 2 years ago

Example query results

Results ``` > select * from rss_channel +-------------------+---------------------------------+--------------+-------------+------------+-----------+----------------------------------------+---------------------------------------------------------------- | title | link | author_email | author_name | categories | copyright | description | extensions +-------------------+---------------------------------+--------------+-------------+------------+-----------+----------------------------------------+---------------------------------------------------------------- | Steampipe Blog | https://steampipe.io/blog | | | | | Blog and Resource Center for Steampipe | {"atom":{"link":[{"attrs":{"href":"https://steampipe.io/blog/fe | Podcast Insights® | https://www.podcastinsights.com | | | | | | {"atom":{"link":[{"attrs":{"href":"https://www.podcastinsights. +-------------------+---------------------------------+--------------+-------------+------------+-----------+----------------------------------------+---------------------------------------------------------------- > select * from rss_channel where feed_link = 'https://www.online-tech-tips.com/feed/' +------------------+----------------------------------+--------------+-------------+------------+-----------+-----------------------------------+--------------------------------------------------------------------- | title | link | author_email | author_name | categories | copyright | description | extensions +------------------+----------------------------------+--------------+-------------+------------+-----------+-----------------------------------+--------------------------------------------------------------------- | Online Tech Tips | https://www.online-tech-tips.com | | | | | Computer Tips from a Computer Guy | {"atom":{"link":[{"attrs":{"href":"https://www.online-tech-tips.com/ +------------------+----------------------------------+--------------+-------------+------------+-----------+-----------------------------------+--------------------------------------------------------------------- > select title,feed_link from rss_channel +-------------------+---------------------------------------+ | title | feed_link | +-------------------+---------------------------------------+ | Steampipe Blog | https://steampipe.io/blog/feed.xml | | Podcast Insights® | https://www.podcastinsights.com/feed/ | +-------------------+---------------------------------------+ > select title,feed_link from rss_channel where feed_link = 'https://steampipe.io/blog/feed.xml' +----------------+------------------------------------+ | title | feed_link | +----------------+------------------------------------+ | Steampipe Blog | https://steampipe.io/blog/feed.xml | +----------------+------------------------------------+ > select title,feed_link from rss_item +--------------------------------------------------------------------------------------+---------------------------------------+ | title | feed_link | +--------------------------------------------------------------------------------------+---------------------------------------+ | Steampipe: select * from cloud; | https://steampipe.io/blog/feed.xml | | v0.15.0: Improved usability, telemetry, 9 new plugins | https://steampipe.io/blog/feed.xml | | Dashboards as Code with HCL + SQL | https://steampipe.io/blog/feed.xml | | Shift Left Join: Where are those IP addresses coming from? | https://steampipe.io/blog/feed.xml | | SQL queries + compliance checks for Terraform files | https://steampipe.io/blog/feed.xml | | v0.14.0: Benchmark dashboards, Postgres 14, ARM64 | https://steampipe.io/blog/feed.xml | | v0.12.0: Templates for control outputs, two new formats | https://steampipe.io/blog/feed.xml | | Top 7 AWS cost-saving strategies | https://steampipe.io/blog/feed.xml | | Use Steampipe to identify cost savings in AWS | https://steampipe.io/blog/feed.xml | | v0.5.0: Controls, compliance benchmarks (CIS + PCI + custom) and lots of Hub updates | https://steampipe.io/blog/feed.xml | | v0.11.0: Faster startup and composable mods | https://steampipe.io/blog/feed.xml | | v0.10.0: Better concurrency and caching | https://steampipe.io/blog/feed.xml | | SQL for Google Sheets | https://steampipe.io/blog/feed.xml | | The Hitchhiker's Guide to IAM Policy Wildcards | https://steampipe.io/blog/feed.xml | | Find secrets everywhere | https://steampipe.io/blog/feed.xml | | Analysis of Cloud Provider Market Share – 2021 | https://steampipe.io/blog/feed.xml | | Monitor compliance of the AWS CIS 1.15 benchmark. | https://steampipe.io/blog/feed.xml | | Using SQL to check spreadsheet integrity | https://steampipe.io/blog/feed.xml | | New: Caching, Config and Improved Quals Handling | https://steampipe.io/blog/feed.xml | | Corral your untagged cloud cattle | https://steampipe.io/blog/feed.xml | | Adding a column to a Steampipe table | https://steampipe.io/blog/feed.xml | | Using Shodan to test AWS Public IPs | https://steampipe.io/blog/feed.xml | | A portrait of VSCode's external contributors | https://steampipe.io/blog/feed.xml | | Steampipe ❤ Parliament | https://steampipe.io/blog/feed.xml | | When not to SELECT * | https://steampipe.io/blog/feed.xml | | v0.8.0: Mod Variables, Tags & Syntax Highlighting | https://steampipe.io/blog/feed.xml | | v0.13.0: Dashboards, ltree, 6 new plugins | https://steampipe.io/blog/feed.xml | | Gruntwork partners with Steampipe to deliver continuous compliance as a service | https://steampipe.io/blog/feed.xml | | New! Named Queries, Search Paths and Workspaces | https://steampipe.io/blog/feed.xml | | Using Steampipe's GitHub plugin to connect with your open source community | https://steampipe.io/blog/feed.xml | | v0.9.0: Dynamic tables & improved control outputs | https://steampipe.io/blog/feed.xml | | Normalizing AWS IAM Policies for Automation | https://steampipe.io/blog/feed.xml | | What's new in the CIS v1.4 benchmark for AWS | https://steampipe.io/blog/feed.xml | | Shift Left Join: Find all AWS EC2 instances not using IMDSv2 | https://steampipe.io/blog/feed.xml | | Top 10 Checks: IAM Credential Report | https://steampipe.io/blog/feed.xml | | v0.7.0: AWS multi-account queries & Docker support | https://steampipe.io/blog/feed.xml | | New: AWS Multi-Region Queries and Query Caching | https://steampipe.io/blog/feed.xml | | v0.6.0: Export and Filter Controls | https://steampipe.io/blog/feed.xml | | A deep dive into AWS Cloud Control for asset inventory | https://steampipe.io/blog/feed.xml | | Amazon Prime Day 2022: The Best Podcasting Deals Of The Year | https://www.podcastinsights.com/feed/ | | Best Podcast Interview Software To Record Remotely | https://www.podcastinsights.com/feed/ | | How To Make Money Podcasting:💰11 Ways To Monetize A Podcast | https://www.podcastinsights.com/feed/ | | Cyber Monday Deals For Podcasters & Gamers (2021 Edition) | https://www.podcastinsights.com/feed/ | | How To Start A Video Podcast (On YouTube) | https://www.podcastinsights.com/feed/ | | Black Friday Deals For Podcasters, Gamers & YouTubers (2021 Edition) | https://www.podcastinsights.com/feed/ | | Best Podcast Microphones For Great Audio (All Budgets) | https://www.podcastinsights.com/feed/ | | Gifts For Podcast Lovers & Listeners (& Audiobook Lovers) | https://www.podcastinsights.com/feed/ | | Best Webinar Software: Platforms To Teach or Sell | https://www.podcastinsights.com/feed/ | | How To Create Narrative Podcasts: Writing Story-Driven Shows | https://www.podcastinsights.com/feed/ | +--------------------------------------------------------------------------------------+---------------------------------------+ > select title,feed_link from rss_item where feed_link = 'https://steampipe.io/blog/feed.xml' +--------------------------------------------------------------------------------------+------------------------------------+ | title | feed_link | +--------------------------------------------------------------------------------------+------------------------------------+ | v0.13.0: Dashboards, ltree, 6 new plugins | https://steampipe.io/blog/feed.xml | | Dashboards as Code with HCL + SQL | https://steampipe.io/blog/feed.xml | | SQL queries + compliance checks for Terraform files | https://steampipe.io/blog/feed.xml | | Gruntwork partners with Steampipe to deliver continuous compliance as a service | https://steampipe.io/blog/feed.xml | | v0.12.0: Templates for control outputs, two new formats | https://steampipe.io/blog/feed.xml | | v0.15.0: Improved usability, telemetry, 9 new plugins | https://steampipe.io/blog/feed.xml | | v0.11.0: Faster startup and composable mods | https://steampipe.io/blog/feed.xml | | Shift Left Join: Where are those IP addresses coming from? | https://steampipe.io/blog/feed.xml | | v0.10.0: Better concurrency and caching | https://steampipe.io/blog/feed.xml | | v0.14.0: Benchmark dashboards, Postgres 14, ARM64 | https://steampipe.io/blog/feed.xml | | Find secrets everywhere | https://steampipe.io/blog/feed.xml | | Top 7 AWS cost-saving strategies | https://steampipe.io/blog/feed.xml | | Using SQL to check spreadsheet integrity | https://steampipe.io/blog/feed.xml | | SQL for Google Sheets | https://steampipe.io/blog/feed.xml | | New! Named Queries, Search Paths and Workspaces | https://steampipe.io/blog/feed.xml | | Shift Left Join: Find all AWS EC2 instances not using IMDSv2 | https://steampipe.io/blog/feed.xml | | Use Steampipe to identify cost savings in AWS | https://steampipe.io/blog/feed.xml | | Adding a column to a Steampipe table | https://steampipe.io/blog/feed.xml | | v0.8.0: Mod Variables, Tags & Syntax Highlighting | https://steampipe.io/blog/feed.xml | | v0.6.0: Export and Filter Controls | https://steampipe.io/blog/feed.xml | | When not to SELECT * | https://steampipe.io/blog/feed.xml | | What's new in the CIS v1.4 benchmark for AWS | https://steampipe.io/blog/feed.xml | | v0.7.0: AWS multi-account queries & Docker support | https://steampipe.io/blog/feed.xml | | Using Shodan to test AWS Public IPs | https://steampipe.io/blog/feed.xml | | A portrait of VSCode's external contributors | https://steampipe.io/blog/feed.xml | | v0.5.0: Controls, compliance benchmarks (CIS + PCI + custom) and lots of Hub updates | https://steampipe.io/blog/feed.xml | | Normalizing AWS IAM Policies for Automation | https://steampipe.io/blog/feed.xml | | v0.9.0: Dynamic tables & improved control outputs | https://steampipe.io/blog/feed.xml | | The Hitchhiker's Guide to IAM Policy Wildcards | https://steampipe.io/blog/feed.xml | | New: AWS Multi-Region Queries and Query Caching | https://steampipe.io/blog/feed.xml | | New: Caching, Config and Improved Quals Handling | https://steampipe.io/blog/feed.xml | | A deep dive into AWS Cloud Control for asset inventory | https://steampipe.io/blog/feed.xml | | Steampipe ❤ Parliament | https://steampipe.io/blog/feed.xml | | Using Steampipe's GitHub plugin to connect with your open source community | https://steampipe.io/blog/feed.xml | | Steampipe: select * from cloud; | https://steampipe.io/blog/feed.xml | | Monitor compliance of the AWS CIS 1.15 benchmark. | https://steampipe.io/blog/feed.xml | | Corral your untagged cloud cattle | https://steampipe.io/blog/feed.xml | | Top 10 Checks: IAM Credential Report | https://steampipe.io/blog/feed.xml | | Analysis of Cloud Provider Market Share – 2021 | https://steampipe.io/blog/feed.xml | +--------------------------------------------------------------------------------------+------------------------------------+ ```
github-actions[bot] commented 2 years ago

This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

github-actions[bot] commented 2 years ago

'This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

github-actions[bot] commented 1 year ago

'This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

github-actions[bot] commented 1 year ago

'This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

github-actions[bot] commented 1 year ago

This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

github-actions[bot] commented 1 year ago

This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

github-actions[bot] commented 11 months ago

This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

github-actions[bot] commented 10 months ago

This PR was closed because it has been stalled for 90 days with no activity.