![\"\"](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/02\/yql.jpg\")
<\/a><\/p>\n- \n
- Yahoo Query Language(YQL<\/strong><\/em> ) is a query language like SQL.<\/li>\n
- Using YQL we can <\/strong>query<\/strong><\/em>, filter<\/strong><\/em>, and join <\/strong><\/em>data across Web services<\/strong><\/em>.<\/li>\n
- YQL can also read RSS feed too.<\/li>\n
- The Response can be JSON or XML.<\/li>\n
- Yahoo provides a YQL console for debugging <\/strong><\/em>, testing <\/strong><\/em>and diagnostics <\/strong><\/em>the YQL statements.<\/li>\n
- The Link for YQL CONSOLE<\/strong><\/em> is http:\/\/developer.yahoo.com\/yql\/console\/<\/a><\/li>\n
- This Demo shows:<\/li>\n
- \n
- Reading my blog RSS Feed ( http:\/\/www.tutorialsavvy.com\/feeds\/posts\/default) using YQL.<\/li>\n
- Getting the feed in JSON format.<\/li>\n
- Displaying the Data in YUI3 Data table.<\/li>\n<\/ul>\n
- The Project structure<\/li>\n
![\"\"](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/02\/yql-project.jpg\")
<\/a><\/p>\n- This Demo uses the following yui3 modules ‘node<\/strong><\/em>‘, ‘yql<\/strong><\/em>‘, ‘datatable<\/strong><\/em>‘, ‘datatable-scroll<\/strong><\/em>‘, ‘datatype-date<\/strong><\/em>‘.<\/li>\n
- The YQL statement used is : select title, pubDate, link from rss where url=’http:\/\/www.tutorialsavvy.com\/feeds\/posts\/default?alt=rss&format=json&diagnostics=true’<\/strong><\/em><\/li>\n
- The YQL Console output is :<\/li>\n
![\"\"](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/02\/yql-console-tutorial-savvy-feed-test.jpg\")
<\/a><\/p>\n- The HTML markup for the YQL <\/strong><\/em>demo script yql-demo.html<\/strong><\/em><\/li>\n
<!DOCTYPE html>\r\n<html>\r\n\r\n <head>\r\n <title>YQL Query Reading RSS Feed Demo<\/title>\r\n <script src='http:\/\/yui.yahooapis.com\/3.8.1\/build\/yui\/yui-min.js'><\/script>\r\n <style>\r\n .response-status {\r\n font-weight: bold;\r\n color:grey;\r\n list-style: none;\r\n }\r\n .response-text {\r\n font-size:16px;\r\n color : orange;\r\n }\r\n #yui-blogger-rss-feed-table {\r\n width:650px;\r\n }\r\n .yui3-skin-sam #yui-blogger-rss-feed-table .yui3-datatable-cell {\r\n font-size:11px;\r\n }\r\n .blogger-post-title {\r\n color: Green;\r\n font-style: italic;\r\n font-weight: bold;\r\n }\r\n .blogger-post-link {\r\n text-decoration: none;\r\n font-style: italic;\r\n font-weight:bold;\r\n }\r\n .blogger-post-link:hover {\r\n color:orange;\r\n text-decoration: underline;\r\n font-weight:bold;\r\n }\r\n <\/style>\r\n <\/head>\r\n\r\n <body class='yui3-skin-sam'>\r\n <!-- This DIV Element is for displaying posts from the YQL QUERY RESPONSE(JSON)\r\n details in YUI3 DATATABLE -->\r\n <div id='yui-blogger-rss-feed-table'><\/div>\r\n <!-- This UL Element is for displaying post count, created date,\r\n language -->\r\n <ul class='response-status'><\/ul>\r\n <script>\r\n YUI().use('node', 'yql', 'datatable', 'datatable-scroll', 'datatype-date', function (Y) {\r\n\r\n var resultItems,\r\n\r\n results, postTable,\r\n\r\n \/*This YQL query is for my Blogger's RSS feed.*\/\r\n yqlRssUrl = 'select title, pubDate, link from rss where ' +\r\n 'url='http:\/\/www.tutorialsavvy.com\/feeds\/posts\/default?alt=rss&format=json&diagnostics=true'',\r\n\r\n responseStatus = Y.one('.response-status'),\r\n\r\n rssYqlFeedTable = Y.one('#yui-blogger-rss-feed-table'),\r\n\r\n \/*HTML template for LINK of the post*\/\r\n formatLink = '<td class='yui3-datatable-cell'><a class='blogger-post-link' href='{content}'>{content}<\/a><\/td>',\r\n\r\n \/*HTML template for TITLE of the post*\/\r\n formatTitle = '<td class='yui3-datatable-cell blogger-post-title'>{content}<\/td>',\r\n\r\n \/*Formatter function for formatting a date, pubDate*\/\r\n formatPubDate = function (o) {\r\n\r\n return Y.DataType.Date.format(Y.DataType.Date.parse(o.value), {\r\n format: '%Y-%m-%d'\r\n });\r\n\r\n }\r\n\r\n \/* This will return 25 results As Blogger return 25 posts by DEFAULT.\r\n * This can be changed to some other number using\r\n * LIMIT parameter.\r\n *\/\r\n Y.YQL(yqlRssUrl, function (feed) {\r\n\r\n results = feed.query;\r\n\r\n resultItems = feed.query.results.item;\r\n\r\n responseStatus.appendChild('<li> Count of Posts (in response) : <span class='response-text'>' + results.count + '<\/span><\/li>');\r\n\r\n responseStatus.appendChild('<li>Created Date : <span class='response-text'>' + results.created + '<\/span><\/li>');\r\n\r\n responseStatus.appendChild('<li>Post Language : <span class='response-text'>' + results.lang + '<\/span><\/li>');\r\n\r\n postTable = new Y.DataTable({\r\n\r\n columns: [{\r\n key: 'title',\r\n label: 'POST TITLE',\r\n cellTemplate: formatTitle\r\n },\r\n\r\n {\r\n key: 'pubDate',\r\n label: 'PUBLICATION DATE',\r\n formatter: formatPubDate\r\n },\r\n\r\n {\r\n key: 'link',\r\n label: 'POST LINK',\r\n cellTemplate: formatLink\r\n }],\r\n\r\n data: resultItems,\r\n\r\n scrollable: 'y',\r\n\r\n height: '250px',\r\n\r\n caption: '[ YQL READING RSS FEED FROM TUTORIAL SAVVY(http:\/\/www.tutorialsavvy.com\/feeds\/posts\/default)' + 'AND DISPLAYING IN DATATABLE]'\r\n\r\n }).render(rssYqlFeedTable);\r\n\r\n })\r\n\r\n });\r\n <\/script>\r\n <\/body>\r\n\r\n<\/html><\/pre>\n- Fire Bug Inspection<\/li>\n
![\"\"](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/02\/yql-inspection-firebug.jpg\")
<\/a><\/div> <\/div><\/p>\n- The JS Fiddle<\/strong><\/em> Link for this demo is:<\/li>\n
- This Demo uses the following yui3 modules ‘node<\/strong><\/em>‘, ‘yql<\/strong><\/em>‘, ‘datatable<\/strong><\/em>‘, ‘datatable-scroll<\/strong><\/em>‘, ‘datatype-date<\/strong><\/em>‘.<\/li>\n
- Using YQL we can <\/strong>query<\/strong><\/em>, filter<\/strong><\/em>, and join <\/strong><\/em>data across Web services<\/strong><\/em>.<\/li>\n