Game news from Steam YQL table

I’m going to illustrate a use of the previously posted Steam YQL Open Table. We’re going to create an RSS feed that has the content of this page about Braid. Here’s the result: Braid news.

YQL

First, we get the appid of Braid, which from the url is 26800. Then, we put the following query in YQL:
use 'https://github.com/disavian/yql-tables/raw/master/steam/steam.news.xml' as steam.news; select * from steam.news where appid='26800' which generates a URL that we then put into feed43.

Data extraction

Inside feed43, we’ll use the following simple extraction rule, which pulls out most of the important data:
<newsitem>{*}<title>{%}</title>{*}<url>{%}</url>{*}<author>{%}</author>{*}<contents>{%}</contents>{*}<feedlabel>{%}</feedlabel>{*}<date>{%}</date>{*}</newsitem>

Item format

Title: {%1}
Link: {%2}
Content: {%5} - {%3}<br/>{%4}<br/>