Load data to one table from multiple RSS feeds

Mon, 11 Jul 2016 20:01:34 GMT

I want to load data from these 3 RSS feeds into QV through a loop and variables, and I can't figure out why it isn't working. I've looked up a ton of community posts, but I'm having trouble adapting them to this data. It either errors out or loads nothing for everything I've tried. Can someone help?

(note: I could easily hard code them, but this is just an example & I need to load a lot more than just these)

feed urls:

http://rssfeeds.azcentral.com/phoenix/local

http://rssfeeds.azcentral.com/phoenix/nation

http://rssfeeds.azcentral.com/phoenix/business

load statement:

LOAD origLink,

title,

link,

description,

pubDate,

guid,

encoded,

[guid/isPermaLink] as isPermaLink,

[enclosure/url] as url,

[enclosure/length] as length,

[enclosure/type] as type,

'http://rssfeeds.azcentral.com/phoenix/business' as feed

FROM [http://rssfeeds.azcentral.com/phoenix/business] (XmlSimple, Table is [rss/channel/item]);

Re: Load data to one table from multiple RSS feeds

stevedark — Wed, 15 Jul 2020 20:05:15 GMT

Appreciate that this is an old post, but just in case anyone arrives here looking for an answer, I have recently posted a blog article on doing just this:

https://www.quickintelligence.co.uk/reading-rss-feeds-with-qlik-rest-connector/

Hope it helps someone.

When loading with the REST connector I would always recommend doing the REST load into a temporary table and then doing a RESIDENT load from that. You can then use a CONCATENATE statement when bringing in subsequent tables - or ensure all tables have exactly the same columns.

Hope that helps someone.

Steve

topic Load data to one table from multiple RSS feeds in QlikView

Load data to one table from multiple RSS feeds

Re: Load data to one table from multiple RSS feeds