Include RSS in QlikView Application

[volcore79]

Hi,

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

Regards

Volker

[#2 · Accepted solution]

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

[volcore79]

Thanks 🙂

Where do i fond this Web Files option exactly ?

[hector]

Hi

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

Rgds

[stevedark]

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