Include RSS in QlikView Application

volcore79 — Mon, 07 Feb 2011 14:17:38 GMT

Hi,

i would like to load an RSS Feed into a QVD. How can i do this ?

Regards

Volker

Include RSS in QlikView Application

Mon, 07 Feb 2011 14:39:37 GMT

Hi,

If you know the address of the feed, you can use the Web Files option in the script editor to load it.

i.e. http://itunes.apple.com/gb/rss/topalbums/limit=10/explicit=true/xml

As long as it is a valid feed, the wizard should recognize the format of the data returned.

I hope this helps.

Thanks

Nick

AW:Re: Include RSS in QlikView Application

volcore79 — Mon, 07 Feb 2011 14:46:59 GMT

Thanks 🙂

Where do i fond this Web Files option exactly ?

AW:Re: Include RSS in QlikView Application

hector — Mon, 07 Feb 2011 15:21:20 GMT

You can find this option in the script editor (Ctrl + E) middle section "Data from files"

Rgds

Re: AW:Re: Include RSS in QlikView Application

stevedark — Fri, 10 Jul 2020 21:47:47 GMT

I know this is a really old thread, but just in case anyone is finding it, I've just done this using the REST connector.

This code works for WP RSS feeds:

let sWPSite = 'https://www.quickintelligence.co.uk/'; // To load from blog RSS feeds you will need to create a REST connection // Name this GenericGET and point it to a placeholder, e.g. https://jsonplaceholder.typicode.com/posts // Ensure that the method for the connection is set to GET, leave everything else as defaults LIB CONNECT TO 'GenericGET'; // Set some paging variables let iDone = 0; let iPage = 1; // And loop for each page - the 500 is a back-stop increast this if you need do while iDone = 0 and iPage <= 500; // Set the paging URL - asking for paged=1 fails let sPage = if(iPage = 1, '', '?paged=$(iPage)'); // Cheeky error mode setting - if number of posts is divisible by 10 (the default page size) a crash can occur set errormode = 0; // Pull the raw data from the feed RawData: SQL SELECT "__KEY_rss", (SELECT "__KEY_channel", "__FK_channel", (SELECT "title" AS "title_u0", "link" AS "link_u0", "creator", "pubDate", "description", // "encoded", // "commentRss", "__KEY_item", "__FK_item" FROM "item" PK "__KEY_item" FK "__FK_item") FROM "channel" PK "__KEY_channel" FK "__FK_channel") FROM XML "rss" PK "__KEY_rss" WITH CONNECTION ( URL "$(sWPSite)feed/$(sPage)" ); set errormode = 1; // Check if we need another page and clean up let iDone = if(alt(NoOfRows('RawData'), 0) < 10, 1, iDone); let iPage = iPage + 1; DROP TABLE RawData; loop next

I've included this, and code for loading from other RSS feeds and APIs in the zip file for my Instant Sense App. This Sense application allows you to load a set of data and some metadata and then visualise it straight away.

Find out more here: https://www.quickintelligence.co.uk/isa

Steve

topic AW:Re: Include RSS in QlikView Application in QlikView

Include RSS in QlikView Application

Include RSS in QlikView Application

AW:Re: Include RSS in QlikView Application

AW:Re: Include RSS in QlikView Application

Re: AW:Re: Include RSS in QlikView Application