{"id":6741,"date":"2014-03-25T05:04:21","date_gmt":"2014-03-24T18:04:21","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=6741"},"modified":"2014-03-25T05:04:21","modified_gmt":"2014-03-24T18:04:21","slug":"yahoo-yql-yahoo-news-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/yahoo-yql-yahoo-news-tutorial\/","title":{"rendered":"Yahoo YQL Yahoo News Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/YQL\/YahooNews\/yahoonews_yql.html\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"Yahoo YQL Yahoo News Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/PHP\/YQL\/YahooNews\/YahooNewsRSSFeed.jpg\" title=\"Yahoo YQL Yahoo News Tutorial\" \/><\/a><p class=\"wp-caption-text\">Yahoo YQL Yahoo News Tutorial<\/p><\/div>\n<p>Here is a tutorial that may be introducing you to the Yahoo Web Services called YQL, building on the previous previous relevant YQL Server tutorials starting with <a target=_blank title='Yahoo YQL Web Service JSON Next Tutorial' href='#pyql'>Yahoo YQL Web Service JSON Next Tutorial<\/a> as shown below.  Today we show that you don&#8217;t have to use JSON for this work if you don&#8217;t want to, but it is advised for data with structural complication.   It is just that today&#8217;s data, the headlines of Yahoo News, has a very simple data structure.   In the case of a very simple data structure you can use the PHP <a target=_blank title='PHP explode' href='http:\/\/au1.php.net\/manual\/en\/function.explode.php'>explode<\/a> method to create a one dimensional array of headlines from the file_get_contents() YSQL url data.   The explode PHP function can become a very clever and close friend, but worry about if you are all rooming together and you have a roster for the washing up &#8230; &#8220;explode&#8221; might explode your regime &#8230; chortle, chortle.<\/p>\n<p>With programming, if there are several ways to solve things, and it is good to try other ways sometimes, so that you get the practice, and as a way to simplify code, sometimes.   <strike>Also, the cat, though skinned horizontally, will show you that little bit of extra attention.<\/strike> (don&#8217;t know what got into me)<\/p>\n<p>In the same mode of subject matter, it is also good to settle on good methods if they work, because, after all, what is most important is that the method works, and you try to have it work as &#8220;advertised&#8221; (sometimes this is a bit harder than you might think, with the rapidly changing software trends and arrangements with Web Services, in particular).<\/p>\n<p>Have we rabbitted on enough, or would you like some facts about <a target=_blank title='rabbits and hares' href='http:\/\/answers.yahoo.com\/question\/index?qid=20081201135719AA4nQB7'>hare<\/a>&#8220;<a target=_blank title='The Hare and the Heiress' href='http:\/\/www.elfinspell.com\/FolkloreCollections\/TalesFromTheFjeld\/TheHareAndTheHeiress.html#hare'>s<\/a>&#8220;? &#8230; chortle, chortle.<\/p>\n<p>Here is a link to some downloadable HTML programming source code which you may want to rename to <a target=_blank title='yahoonews_yql.html' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/YQL\/YahooNews\/yahoonews_yql.html_GETME\">yahoonews_yql.html<\/a> which calls some downloadable PHP programming source code which you may want to rename to <a target=_blank title='yahoonews_yql.php' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/YQL\/YahooNews\/yahoonews_yql.php_GETME\">yahoonews_yql.php<\/a><\/p>\n<p>The PHP function used is:<\/p>\n<ul>\n<li><a target=_blank title='file_get_contents' href='http:\/\/us1.php.net\/file_get_contents'>file_get_contents<\/a><\/li>\n<\/ul>\n<p>Good links for information regarding this tutorial (thanks) are:<\/p>\n<ul>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/guide\/two-minute-tutorial.html' title='YQL Two Minute Tutorial'>YQL Two Minute Tutorial<\/a> from Yahoo<\/li>\n<li><a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/Yahoo!_Query_Language' title='Yahoo! Query Language'>Yahoo! Query Language<\/a> from Wikipedia, as per quote above<\/li>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/' title='YQL Home Page'>YQL Home Page<\/a> from Yahoo<\/li>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/console\/?q=select%20*%20from%20flickr.photos.interestingness%2820%29&#038;env=store:\/\/datatables.org\/alltableswithkeys#h=select+title+from+rss+where+url%3D%22http%3A%2F%2Frss.news.yahoo.com%2Frss%2Ftopstories%22' title='YQL Yahoo News RSS Feed help'>YQL Yahoo News RSS Feed help<\/a> from Yahoo<\/li>\n<\/ul>\n<hr \/>\n<p id='pyql'>Previous relevant YQL Server tutorials starting with <a target=_blank title='Yahoo YQL Web Service JSON Next Tutorial' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=6360'>Yahoo YQL Web Service JSON Next Tutorial<\/a> are shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/blackcountryhistory_yql.html\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"Yahoo YQL Web Service JSON Next Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/Yql_BlackCountry_Search.jpg\" title=\"Yahoo YQL Web Service JSON Primer Tutorial\" \/><\/a><p class=\"wp-caption-text\">Yahoo YQL Web Service JSON Next Tutorial<\/p><\/div>\n<p>Here is a tutorial that introduces you to the Yahoo Web Services called YQL, building on the previous <a href='#yywsjft' title='Yahoo YQL Web Service JSON FollowUp Tutorial'>Yahoo YQL Web Service JSON FollowUp Tutorial<\/a> as shown below.   The name is the way it is because it simplified the API aspects of its functionality for the developer to concentrate on SQL, and I&#8217;m really supportive of this concept.  You don&#8217;t have to output in JSON, as other data forms like XML are acceptable.  Let&#8217;s see what Wikipedia says about YQL below. <\/p>\n<blockquote>\n<p>Yahoo! Query Language (YQL) is an SQL-like query language created by Yahoo! as part of their Developer Network. YQL is designed to retrieve and manipulate data from APIs through a single Web interface, thus allowing mashups that enable developers to create their own applications.[1]<\/p>\n<p>Initially launched in October 2008 with access to Yahoo APIs,[2] February 2009 saw the addition of open data tables from third parties such as Google Reader, the Guardian, and The New York Times.[3] Some of these APIs still require an API key to access them. On April 29th of 2009, Yahoo introduced the capability to execute the tables of data built through YQL using JavaScript run on the company&#8217;s servers for free.[3]<\/p>\n<\/blockquote>\n<p>So this tutorial uses a YQL web service into the data emanating from its links to the Black Country History artworks database.  You fill in search words to search for artworks of interest linked to the Yahoo YQL <a target=_blank title='Black Country History' href='http:\/\/www.blackcountry.org\/'>Black Country History<\/a> database tables.<\/p>\n<p>The two big PHP functions of use are:<\/p>\n<ul>\n<li><a target=_blank title='file_get_contents' href='http:\/\/us1.php.net\/file_get_contents'>file_get_contents<\/a><\/li>\n<li><a target=_blank title='json_decode' href='http:\/\/php.net\/manual\/en\/function.json-decode.php'>json_decode<\/a><\/li>\n<\/ul>\n<p>Good links for information regarding this tutorial (thanks) are:<\/p>\n<ul>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/guide\/two-minute-tutorial.html' title='YQL Two Minute Tutorial'>YQL Two Minute Tutorial<\/a> from Yahoo<\/li>\n<li><a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/Yahoo!_Query_Language' title='Yahoo! Query Language'>Yahoo! Query Language<\/a> from Wikipedia, as per quote above<\/li>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/' title='YQL Home Page'>YQL Home Page<\/a> from Yahoo<\/li>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/console\/?q=select%20*%20from%20flickr.photos.interestingness%2820%29&#038;env=store:\/\/datatables.org\/alltableswithkeys#h=select+*+from+blackcountryhistory.search+where+q%3D%22painting%22%3B' title='YQL Black Country History help'>YQL Black Country History help<\/a> from Yahoo<\/li>\n<li><a target=_blank title='YQL JSON Parsing Help' href='http:\/\/developer.yahoo.com\/forum\/YQL\/yql-query-intermittently-returns-no-results\/1374521623593-fa4a3519-10ae-4a17-8fd4-6de45a159d6f'>YQL JSON Parsing Help<\/a> from YQL forum<\/li>\n<\/ul>\n<p>Another tool you should have in your armoury for jobs like this is the online JSON validator <a target=_blank title='JSON validator online' href='http:\/\/jsonlint.com\/'>here<\/a>.  A generic JSON approach to issues could be:<\/p>\n<ol>\n<li>Type the URL you were given into a web browser address bar and have a look at it<\/li>\n<li>Type the URL you were given into http:\/\/jsonlint.com\/ and have it validated<\/li>\n<li>Understand in your own mind what would be different about 1. to make it suitable<\/li>\n<li>Incorporate findings of 3. into massaging of data between file_get_contents and json_decode<\/li>\n<\/ol>\n<p>Here is a link to some downloadable HTML programming source code which you may want to rename to <a target=_blank title='blackcountryhistory_yql.html' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/blackcountryhistory_yql.html_GETME\">blackcountryhistory_yql.html<\/a> which calls some downloadable PHP programming source code which you may want to rename to <a target=_blank title='blackcountryhistory_yql.php' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/blackcountryhistory_yql.php_GETME\">blackcountryhistory_yql.php<\/a><\/p>\n<hr \/>\n<p id='yywsjft'>Previous <a target=_blank href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=6304' title='Yahoo YQL Web Service JSON FollowUp Tutorial'>Yahoo YQL Web Service JSON FollowUp Tutorial<\/a> is shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/search_hansard.html\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"Yahoo YQL Web Service JSON FollowUp Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/Yql_Hansard_Search.jpg\" title=\"Yahoo YQL Web Service JSON Primer Tutorial\" \/><\/a><p class=\"wp-caption-text\">Yahoo YQL Web Service JSON FollowUp Tutorial<\/p><\/div>\n<p>Here is a tutorial that introduces you to the Yahoo Web Services called YQL, building on the previous <a href='#yywsjpt' title='Yahoo YQL Web Service JSON Primer Tutorial'>Yahoo YQL Web Service JSON Primer Tutorial<\/a> as shown below.   The name is the way it is because it simplified the API aspects of its functionality for the developer to concentrate on SQL, and I&#8217;m really supportive of this concept.  You don&#8217;t have to output in JSON, as other data forms like XML are acceptable.  Let&#8217;s see what Wikipedia says about YQL below. <\/p>\n<blockquote>\n<p>Yahoo! Query Language (YQL) is an SQL-like query language created by Yahoo! as part of their Developer Network. YQL is designed to retrieve and manipulate data from APIs through a single Web interface, thus allowing mashups that enable developers to create their own applications.[1]<\/p>\n<p>Initially launched in October 2008 with access to Yahoo APIs,[2] February 2009 saw the addition of open data tables from third parties such as Google Reader, the Guardian, and The New York Times.[3] Some of these APIs still require an API key to access them. On April 29th of 2009, Yahoo introduced the capability to execute the tables of data built through YQL using JavaScript run on the company&#8217;s servers for free.[3]<\/p>\n<\/blockquote>\n<p>So this tutorial uses a YQL web service into the data emanating from its links to the Hansard database of Australian federal Government business.  You fill in search words to search for in the Hansard data at the Yahoo YQL <a target=_blank title='OpenAustralia' href='http:\/\/www.openaustralia.org\/'>OpenAustralia<\/a> database tables.<\/p>\n<p>The two big PHP functions of use are:<\/p>\n<ul>\n<li><a target=_blank title='file_get_contents' href='http:\/\/us1.php.net\/file_get_contents'>file_get_contents<\/a><\/li>\n<li><a target=_blank title='json_decode' href='http:\/\/php.net\/manual\/en\/function.json-decode.php'>json_decode<\/a><\/li>\n<\/ul>\n<p>Good links for information regarding this tutorial (thanks) are:<\/p>\n<ul>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/guide\/two-minute-tutorial.html' title='YQL Two Minute Tutorial'>YQL Two Minute Tutorial<\/a> from Yahoo<\/li>\n<li><a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/Yahoo!_Query_Language' title='Yahoo! Query Language'>Yahoo! Query Language<\/a> from Wikipedia, as per quote above<\/li>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/' title='YQL Home Page'>YQL Home Page<\/a> from Yahoo<\/li>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/console\/?q=select%20*%20from%20flickr.photos.interestingness%2820%29&#038;env=store:\/\/datatables.org\/alltableswithkeys&#038;debug=true#h=select+*+from+openaustralia.getHansard+where+search%3D%27Gillard%27' title='YQL OpenAustralia help'>YQL OpenAustralia help<\/a> from Yahoo<\/li>\n<li><a target=_blank title='YQL JSON Parsing Help' href='http:\/\/developer.yahoo.com\/forum\/YQL\/yql-query-intermittently-returns-no-results\/1374521623593-fa4a3519-10ae-4a17-8fd4-6de45a159d6f'>YQL JSON Parsing Help<\/a> from YQL forum<\/li>\n<\/ul>\n<p>Another tool you should have in your armoury for jobs like this is the online JSON validator <a target=_blank title='JSON validator online' href='http:\/\/jsonlint.com\/'>here<\/a>.  A generic JSON approach to issues could be:<\/p>\n<ol>\n<li>Type the URL you were given into a web browser address bar and have a look at it<\/li>\n<li>Type the URL you were given into http:\/\/jsonlint.com\/ and have it validated<\/li>\n<li>Understand in your own mind what would be different about 1. to make it suitable<\/li>\n<li>Incorporate findings of 3. into massaging of data between file_get_contents and json_decode<\/li>\n<\/ol>\n<p>Here is a link to some downloadable HTML programming source code which you may want to rename to <a target=_blank title='search_hansard.html' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/search_hansard.html_GETME\">search_hansard.html<\/a> which calls some downloadable PHP programming source code which you may want to rename to <a target=_blank title='search_hansard.php' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/search_hansard.php_GETME\">search_hansard.php<\/a><\/p>\n<hr \/>\n<p id='yywsjpt'>Previous relevant <a target=_blank href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=6194' title='Yahoo YQL Web Service JSON Primer Tutorial'>Yahoo YQL Web Service JSON Primer Tutorial<\/a> is shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/getyqlanswersdata.html\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"Yahoo YQL Web Service JSON Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/Yql_primer.jpg\" title=\"Yahoo YQL Web Service JSON Primer Tutorial\" \/><\/a><p class=\"wp-caption-text\">Yahoo YQL Web Service JSON Primer Tutorial<\/p><\/div>\n<p>Here is a tutorial that introduces you to the Yahoo Web Services called YQL.   The name is the way it is because it simplified the API aspects of its functionality for the developer to concentrate on SQL, and I&#8217;m really supportive of this concept.  You don&#8217;t have to output in JSON, as other data forms like XML are acceptable.  Let&#8217;s see what Wikipedia says about YQL below. <\/p>\n<blockquote>\n<p>Yahoo! Query Language (YQL) is an SQL-like query language created by Yahoo! as part of their Developer Network. YQL is designed to retrieve and manipulate data from APIs through a single Web interface, thus allowing mashups that enable developers to create their own applications.[1]<\/p>\n<p>Initially launched in October 2008 with access to Yahoo APIs,[2] February 2009 saw the addition of open data tables from third parties such as Google Reader, the Guardian, and The New York Times.[3] Some of these APIs still require an API key to access them. On April 29th of 2009, Yahoo introduced the capability to execute the tables of data built through YQL using JavaScript run on the company&#8217;s servers for free.[3]<\/p>\n<\/blockquote>\n<p>So this tutorial uses a YQL web service into the data emanating from the brilliant <a target=_blank title='Yahoo Answers' href='http:\/\/au.answers.yahoo.com\/'>Yahoo Answers<\/a> website.  You fill in a topic and see some Yahoo Answers questions and answers in regard to that topic.<\/p>\n<p>The two big PHP functions of use are:<\/p>\n<ul>\n<li><a target=_blank title='file_get_contents' href='http:\/\/us1.php.net\/file_get_contents'>file_get_contents<\/a><\/li>\n<li><a target=_blank title='json_decode' href='http:\/\/php.net\/manual\/en\/function.json-decode.php'>json_decode<\/a><\/li>\n<\/ul>\n<p>Good links for information regarding this tutorial (thanks) are:<\/p>\n<ul>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/guide\/two-minute-tutorial.html' title='YQL Two Minute Tutorial'>YQL Two Minute Tutorial<\/a> from Yahoo<\/li>\n<li><a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/Yahoo!_Query_Language' title='Yahoo! Query Language'>Yahoo! Query Language<\/a> from Wikipedia, as per quote above<\/li>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/' title='YQL Home Page'>YQL Home Page<\/a> from Yahoo<\/li>\n<li><a target=_blank href='http:\/\/developer.yahoo.com\/yql\/console\/?q=select%20*%20from%20flickr.photos.interestingness%2820%29&#038;env=store:\/\/datatables.org\/alltableswithkeys#h=select+*+from+answers.search+where+query%3D%22MySql%22++and+type%3D%22resolved%22' title='YQL Yahoo Answers help'>YQL Yahoo Answers help<\/a> from Yahoo<\/li>\n<li><a target=_blank title='YQL JSON Parsing Help' href='http:\/\/developer.yahoo.com\/forum\/YQL\/yql-query-intermittently-returns-no-results\/1374521623593-fa4a3519-10ae-4a17-8fd4-6de45a159d6f'>YQL JSON Parsing Help<\/a> from YQL forum<\/li>\n<\/ul>\n<p>Another tool you should have in your armoury for jobs like this is the online JSON validator <a target=_blank title='JSON validator online' href='http:\/\/jsonlint.com\/'>here<\/a>.  A generic JSON approach to issues could be:<\/p>\n<ol>\n<li>Type the URL you were given into a web browser address bar and have a look at it<\/li>\n<li>Type the URL you were given into http:\/\/jsonlint.com\/ and have it validated<\/li>\n<li>Understand in your own mind what would be different about 1. to make it suitable<\/li>\n<li>Incorporate findings of 3. into massaging of data between file_get_contents and json_decode<\/li>\n<\/ol>\n<p>Here is a link to some downloadable HTML programming source code which you may want to rename to <a target=_blank title='getyqlanswersdata.html' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/getyqlanswersdata.html_GETME\">getyqlanswersdata.html<\/a> which calls some downloadable PHP programming source code which you may want to rename to <a target=_blank title='getyqlanswersdata.php' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/JSON\/YQL\/getyqlanswersdata.php_GETME\">getyqlanswersdata.php<\/a><\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d6194' onclick='var dv=document.getElementById(\"d6194\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=JSON\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d6194' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr \/>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d6304' onclick='var dv=document.getElementById(\"d6304\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=JSON\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d6304' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr \/>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d6360' onclick='var dv=document.getElementById(\"d6360\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=JSON\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d6360' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr \/>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d6741' onclick='var dv=document.getElementById(\"d6741\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=YQL\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d6741' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Here is a tutorial that may be introducing you to the Yahoo Web Services called YQL, building on the previous previous relevant YQL Server tutorials starting with Yahoo YQL Web Service JSON Next Tutorial as shown below. Today we show &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/yahoo-yql-yahoo-news-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,37],"tags":[666,997,1186,1319,1412,1487,1490,1491,1494],"class_list":["post-6741","post","type-post","status-publish","format-standard","hentry","category-elearning","category-tutorials","tag-json_decode","tag-programming","tag-sql","tag-tutorial","tag-web-service","tag-yahoo","tag-yahoo-news","tag-yahoo-yql","tag-yql"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/6741"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=6741"}],"version-history":[{"count":0,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/6741\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=6741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=6741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=6741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}