The following JQuery script will fetch the RSS feed from multiple sources and then save the data into the SharePoint 2007 list via lists.asmx:
<script src="/Scripts/jquery-1.8.0.min.js" type="text/javascript"></script>
<script type="text/javascript">
function LoadFeed()
{
var varFeedURL = new Array();
varFeedURL[0] = "http://feeds.bbci.co.uk/news/business/rss.xml";
varFeedURL[1] = "http://www.ft.com/rss/home/uk";
varFeedURL[2] = "http://www.ft.com/rss/home/us";
for (i = 0; i < varFeedURL.length; i++)
{
$.get(varFeedURL[i], function(data) {
var $xml = $(data);
$xml.find("item").each(function() {
var $this = $(this),
item = {
title: $this.find("title").text(),
link: $this.find("link").text(),
description: $this.find("description").text(),
pubDate: $this.find("pubDate").text()
}
//Show only Today's Items
var a = new Date(item.pubDate);
var b = new Date(); //Today's Date
var msDateA = Date.UTC(a.getFullYear(), a.getMonth()+1, a.getDate());
var msDateB = Date.UTC(b.getFullYear(), b.getMonth()+1, b.getDate());
if (parseFloat(msDateA) == parseFloat(msDateB))
{
var content = document.getElementById('content');
content.appendChild(document.createTextNode(item.title));
content.appendChild(document.createElement('br'));
content.appendChild(document.createTextNode(item.description));
content.appendChild(document.createElement('br'));
content.appendChild(document.createTextNode(item.link));
content.appendChild(document.createElement('br'));
content.appendChild(document.createElement('hr'));
CreateNewItem(item.title, item.description, item.link);
}
});
});
}
alert('Done');
}
function CreateNewItem(varTitle, varDescription, varLink)
{
var batch =
"<Batch OnError=\"Continue\"> \
<Method ID=\"1\" Cmd=\"New\"> \
<Field Name=\"Title\">" + varTitle + "</Field> \
<Field Name=\"Description\">" + varDescription + "</Field> \
<Field Name=\"Link\">" + varLink + "</Field> \
</Method> \
</Batch>";
var soapEnv =
"<?xml version=\"1.0\" encoding=\"utf-8\"?> \
<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" \
xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" \
xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"> \
<soap:Body> \
<UpdateListItems xmlns=\"http://schemas.microsoft.com/sharepoint/soap/\"> \
<listName>RSSData</listName> \
<updates> \
" + batch + "</updates> \
</UpdateListItems> \
</soap:Body> \
</soap:Envelope>";
$.ajax({
url: "http://portalstg.amr.kworld.kpmg.com/_vti_bin/lists.asmx",
beforeSend: function(xhr) {
xhr.setRequestHeader("SOAPAction",
"http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");
},
type: "POST",
dataType: "xml",
data: soapEnv,
complete: processResult,
contentType: "text/xml; charset=utf-8"
});
}
function processResult(xData, status) {
//alert(status);
}
</script>
<input id="btnGo" onclick="LoadFeed()" type="button" value="Get RSS Data" />
Ref: http://weblogs.asp.net/jan/archive/2009/04/10/creating-list-items-with-jquery-and-the-sharepoint-web-services.aspx
