Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]);
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