{"id":10613,"date":"2014-11-16T05:06:19","date_gmt":"2014-11-15T18:06:19","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=10613"},"modified":"2014-11-16T05:06:19","modified_gmt":"2014-11-15T18:06:19","slug":"yahoo-yql-web-service-json-winter-olympics-game-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/yahoo-yql-web-service-json-winter-olympics-game-tutorial\/","title":{"rendered":"Yahoo YQL Web Service Winter Olympics Game Tutorial"},"content":{"rendered":"
\"Yahoo<\/a>

Yahoo YQL Web Service Winter Olympics Game Tutorial<\/p><\/div>\n

Here is a tutorial that reminds you again about the Yahoo Web Services called YQL, building on previous YQL tutorials<\/a> on this blog, building on yesterday’s Yahoo YQL Web Service JSON First Name 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’m really supportive of this concept. You don’t have to output in JSON, as other data forms like XML are acceptable. Let’s see what Wikipedia says about YQL below. <\/p>\n

\n

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

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’s servers for free.[3]<\/p>\n<\/blockquote>\n

So this tutorial uses a YQL web service into the data emanating from its links to a Winter Olympics database of the http:\/\/isithackday.com website (where they have a useful CSV file called medals.csv) … thanks. You fill in a Medal Presentation (secret) number of interest to get presented with 5\/8 of the information required to score a point … your job, should you decide to take it on, Jim<\/i><\/a>, is to pick those other 3\/8 of the information.<\/p>\n

The two big PHP functions of use for this are (normally):<\/p>\n