search

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

cannot see items for aws and talend status of services #14

Closed matteoredaelli closed 2 years ago

matteoredaelli commented 2 years ago

Describe the bug Cannot get teh list of itens

Steampipe version (steampipe -v) latest

Plugin version (steampipe plugin list) latest

To reproduce

No records for

select title from rss_channel where feed_link = 'http://status.aws.amazon.com/rss/all.rss' limit 1

I get only 1 record for

select * from rss_channel where feed_link = 'https://trust.talend.com/history.atom';
+----------------------------------------+--------------------------+--------------+--------------+------------+-----------+-------------+------------+---------------->
| title                                  | link                     | author_email | author_name  | categories | copyright | description | extensions | feed_link      >
+----------------------------------------+--------------------------+--------------+--------------+------------+-----------+-------------+------------+---------------->
| Talend Cloud Status - Incident History | https://trust.talend.com |              | Talend Cloud | <null>     | <null>    | <null>      | <null>     | https://trust.t>
+----------------------------------------+--------------------------+--------------+--------------+------------+-----------+-------------+------------+---------------->
e-gineer commented 2 years ago

Hey @matteoredaelli ... I think you need to try the rss_item table instead (not rss_channel)? https://hub.steampipe.io/plugins/turbot/rss/tables/rss_item

That seems to work for me:

> select published, title from rss_item where feed_link = 'https://trust.talend.com/history.atom';
+---------------------------+------------------------------------------------------------------------------------------------+
| published                 | title                                                                                          |
+---------------------------+------------------------------------------------------------------------------------------------+
| 2021-12-22T10:42:13-05:00 | Talend Cloud AWS (US) - Major Outage                                                           |
| 2022-02-03T11:04:15-05:00 | Talend Cloud AWS EU -- Partial Outage (publish artefacts)                                      |
| 2021-09-04T07:31:29-04:00 | Talend Cloud AWS (EU) - Remote Engines / Cloud Engines for Management Console                  |
| 2021-06-10T09:00:00-04:00 | Talend Cloud AWS (EU) - Talend Data Inventory, Data Preparation, Pipeline Designer             |
| 2021-07-13T12:28:02-04:00 | Talend Cloud AWS (EU) - Talend Data Stewardship                                                |
| 2021-06-10T20:45:11-04:00 | Talend Cloud AWS (US, EU, AP) and Azure (US West) - Talend Cloud Login Failures                |
| 2021-12-07T10:30:35-05:00 | Talend Cloud Azure (US) - Remote Engines / Cloud Engines for Management Console                |
| 2021-08-03T11:56:36-04:00 | Talend Cloud Cloud Engine Services for Design                                                  |
| 2021-11-28T18:30:00-05:00 | Talend Cloud Azure (West US) - Remote Engines for Management Console                           |
| 2021-06-16T07:47:20-04:00 | Talend Cloud AWS - Europe (Frankfurt) - Remote Engines for Management Console                  |
| 2021-10-08T04:08:07-04:00 | Talend Cloud AWS (US) - Remote Engines / Cloud Engines for Management Console                  |
| 2021-08-26T17:03:58-04:00 | Talend Cloud Azure (West US) - Talend Management Console Logging                               |
| 2021-08-19T04:52:59-04:00 | Talend Cloud AWS (US) - Remote Engines / Cloud Engines for Management Console                  |
| 2021-08-12T09:17:50-04:00 | Talend Cloud (AWS AU) Service Unavailability                                                   |
| 2021-10-28T08:14:51-04:00 | Talend Cloud AWS (EU Central) -- Remote Engines for Management Console -- Degraded Performance |
| 2021-12-07T22:14:16-05:00 | Talend Cloud AWS - US East (N. Virginia) - Cloud Engines for Management Console                |
| 2021-09-21T05:20:01-04:00 | Talend Cloud AWS (EU) - Talend Management Console Logging                                      |
| 2021-08-03T10:42:27-04:00 | Talend Cloud Azure (West US)                                                                   |
| 2021-12-20T09:24:14-05:00 | Talend Cloud AWS (EU) -- Degraded Performance                                                  |
| 2021-07-22T03:55:29-04:00 | Talend Cloud Login and execution failures                                                      |
| 2021-06-05T15:16:56-04:00 | Talend Cloud AWS US - Login Issue                                                              |
| 2021-11-29T05:42:20-05:00 | Talend Cloud AWS (AU) - Remote Engines / Cloud Engines for Management Console                  |
| 2021-09-10T18:17:54-04:00 | Talend Cloud AWS (US) - Talend Management Console Logging                                      |
| 2021-06-09T03:29:02-04:00 | Talend Cloud Azure (West US) - Talend Data Preparation                                         |
| 2021-11-30T04:20:32-05:00 | Talend Cloud AWS - Europe (Frankfurt) - Remote Engines for Management Console                  |
+---------------------------+------------------------------------------------------------------------------------------------+

Time: 16.599375ms
> 
> select published, title from rss_item where feed_link = 'http://status.aws.amazon.com/rss/all.rss';
+---------------------------+--------------------------------------------------------------------------------------------------------------------+
| published                 | title                                                                                                              |
+---------------------------+--------------------------------------------------------------------------------------------------------------------+
| 2022-01-17T02:15:00-05:00 | Informational message: [RESOLVED] Increased API Error Rates                                                        |
| 2022-01-14T05:39:56-05:00 | Informational message: [RESOLVED] Pinpoint Sending/Receiving Delays                                                |
| 2022-02-05T23:29:00-05:00 | Informational message: [RESOLVED] 네트워크 연결 | Network Connectivity                                             |
| 2022-01-14T09:44:00-05:00 | Service is operating normally: [RESOLVED] SMS Delivery Delays                                                      |
| 2022-01-14T06:42:55-05:00 | Informational message: [RESOLVED] Pinpoint Sending/Receiving Delays                                                |
| 2022-01-14T06:00:01-05:00 | Informational message: [RESOLVED] SMS Delivery Delays                                                              |
| 2022-01-14T06:38:02-05:00 | Informational message: [RESOLVED] SMS Delivery Delays                                                              |
| 2022-01-14T05:53:31-05:00 | Informational message: [RESOLVED] Pinpoint Sending/Receiving Delays                                                |
| 2021-12-22T12:57:40-05:00 | Service is operating normally: [RESOLVED] Increased Error Rates with Directory Services AD Connector or Managed AD |
| 2022-01-17T02:50:00-05:00 | Service is operating normally: [RESOLVED] Increased API Error Rates                                                |
| 2021-12-24T05:41:17-05:00 | Informational message: [RESOLVED] Internet connectivity                                                            |
| 2022-01-14T06:12:35-05:00 | Informational message: [RESOLVED] Pinpoint Sending/Receiving Delays                                                |
| 2022-01-14T06:12:26-05:00 | Informational message: [RESOLVED] SMS Delivery Delays                                                              |
| 2022-01-14T05:59:17-05:00 | Informational message: [RESOLVED] SMS Delivery Delays                                                              |
| 2022-01-14T09:43:00-05:00 | Service is operating normally: [RESOLVED] Pinpoint Sending/Receiving Delays                                        |
+---------------------------+--------------------------------------------------------------------------------------------------------------------+

Time: 13.561875ms
>

Our example on the overview / README should be improved though - I can see how it is confusing.

matteoredaelli commented 2 years ago

Many thanks!