A call with a prospect this week took an interesting turn when the prospect expressed an interest in integrating the content from an RSS feed with other information that they had available through the XIP platform. For pure WOW Factor, what happened next should make our marketing folks very happy.
Over the next three minutes (we timed it), we pulled in our prospect’s favorite RSS feed and showed how they can use XQuery to filter and transform its content and make it available to their queries. For a bonus, we rustled up an Ipedo commander script that would automate the process for the future (so it would take seconds to repeat the demo). With RSS feeds gaining importance as a means of syndicating and distributing content, this could be of general interest for XIP users. So here is a synopsis of how to integrate RSS content into your information architecture.
The primary construct through which information is made available to the XIP platform is the View. So we start off by creating a view that represents the RSS feed. This is as simple as typing the URL and clicking a button. The snapshot along side illustrates this.
That done, you can use the view in any XQuery query (or in a SQL query through the use of the XMLTABLE operator that can transform XML to a tabular structure). For instance the following query:
|
{-- filter headlines, returning all
with a given keyword in the title --} let $key := "AMERICAN" for $xbrlItem in view("publicWS/xbrlrss")//:item where contains($xbrlItem/title, $key) return $xbrlItem |
Would return a result such as:
|
<item rdf:about="http://www.sec.gov/Archives/edgar/data/808013/000119312508005373/0001193125-08-005373-index.htm"
xmlns:edgar="http://www.sec.gov/Archives/edgar"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
xmlns:edgar="http://www.sec.gov/Archives/edgar">
description="FORM 8-K" file="d8k.htm"
sequence="1"
size="15621" type="8-K"
url="http://www.sec.gov/Archives/edgar/data/808013/000119312508005373/d8k.htm"/>
description="XBRL INSTANCE DOCUMENT"
file="namc-20070930.xml" sequence="2"
size="37002"
type="EX-100.INS"
url="http://www.sec.gov/Archives/edgar/data/808013/000119312508005373/namc-20070930.xml"/>
description="XBRL TAXONOMY EXTENSION SCHEMA"
file="namc-20070930.xsd" sequence="3"
size="193491"
type="EX-100.SCH"
url="http://www.sec.gov/Archives/edgar/data/808013/000119312508005373/namc-20070930.xsd"/>
description="XBRL TAXONOMY EXTENSION CALCULATION LINKBASE"
file="namc-20070930_cal.xml" sequence="4"
size="938968"
type="EX-100.CAL"
url="http://www.sec.gov/Archives/edgar/data/808013/000119312508005373/namc-20070930_cal.xml"/>
description="XBRL TAXONOMY EXTENSION LABEL LINKBASE"
file="namc-20070930_lab.xml" sequence="5"
size="1154367"
type="EX-100.LAB"
url="http://www.sec.gov/Archives/edgar/data/808013/000119312508005373/namc-20070930_lab.xml"/>
description="XBRL TAXONOMY EXTENSION PRESENTATION LINKBASE"
file="namc-20070930_pre.xml" sequence="6"
size="1576867"
type="EX-100.PRE" url="http://www.sec.gov/Archives/edgar/data/808013/000119312508005373/namc-20070930_pre.xml"/> |
Since it can be queried using XQuery or SQL, this content can also be integrated into other views that access related content. The view can also be cached and the content indexed so that the performance of queries over the content can be fast. Yet another example of how a variety of data sources can be integrated and made available in different ways to consuming applications.
very informational...I find this educative as well, i've been a very good follower of your blog... all am gonna say is good job!
Posted by: Acai Optimum | March 29, 2010 at 05:52 PM
That's not his. Steve's is black*_*
Posted by: air jordan | November 16, 2010 at 05:27 PM
I can imagine TONS of uses for this*_*
Posted by: air jordan | November 16, 2010 at 06:50 PM
this could be of general interest for XIP users. So here is a synopsis of how to integrate RSS content into your information architecture.
Posted by: ugg sale | November 22, 2010 at 01:14 AM
To my mind it is a great article*.*
Posted by: Air Jordan Basket | December 01, 2010 at 11:49 PM
I came to your article from another article and am really interested in this learning about this. , I feel strongly about information and love learning more on this. If possible, as you gain expertise, It is extremely helpful for me. would you mind updating your blog with more information?
http://www.jerseysonline.co
Posted by: leiqiong | December 27, 2010 at 12:42 AM
nous allons louer une voiture pour le week-end*_*
Posted by: Buy from taobao | January 03, 2011 at 07:03 PM
Thanks for sharing the important information on RSS and XIP Platform. The quotes specially, helped me a lot.
Posted by: ooma review | March 11, 2011 at 03:41 AM
The view can also be cached and the content indexed so that the performance of queries over the content can be fast.
Posted by: ClubPenguinCheats | May 25, 2011 at 11:10 PM
There are many people searching about that and now they will find enough resources from your post. Thank you!
Posted by: Lester, the adult tricycle man | June 06, 2011 at 08:29 PM
Super cute! My little man would look so stylin' in those!
Posted by: red bottom shoes | October 06, 2011 at 05:52 AM
Ban on women driving should be considered world wide... :-) I would never allow my wife driving my car.. :-)
Posted by: manolo blahnik shoes | October 08, 2011 at 06:11 AM
In order to maintain a good site you need to prioritize the golas you have in order to satisfy the users of it. Your site is like that and I really like that there is the both sieds of it. One because of you and the other one for the users.
Posted by: Carpet Cleaning | October 20, 2011 at 05:52 PM
Thanks for sharing. This website is to I too have to help. Very good.
http://www.nfljerseysmalls.com
Posted by: nfl jerseys | November 20, 2011 at 08:28 PM
I am very much enjoyed for the great services in this blog and the latest info is visible in this blog. Thanks a lot for using the great info and utilize the nice services in this blog.
http://www.bestuggaustralia.com
Posted by: Ugg Boots On Sale | November 20, 2011 at 09:23 PM
XIP is something new for me. I am familiar with RSS, but don`t know how this is related with it.
Posted by: inventory services london | December 06, 2011 at 12:57 AM
online pharmacy worldwide shipping BUY SUPER CHEAP Israel without a prescription and cod delivery cataracts or impaired eyesight Levitra Low for prices severe allergies online, Without prescription.Alesse Free Shipping,Get central nervous system disease Levitra USA online no script spasm in fingers or toes, or unusual muscle movements Unbeliveable cheap New Mexico No prescription.Online pharmacy back pain Glucotrol xl Fedex overnight
buy generic viagra buy generic viagra
Posted by: online pharmacy no prescription canada | December 23, 2011 at 12:08 AM
How does a gate-keeper on the creation of communities solve this? A formal approval chain for communities does not imply activity will occur there once created.
Posted by: belstaff jacket | December 27, 2011 at 05:04 PM
zjkiian http://www.hoganscarpe-sito-ufficiale.net hogan sito ufficiale zmillkv hogan bpqusge hogan snbdt
Posted by: Joisguccigh | January 03, 2012 at 01:13 AM