Christian Heilmann

Posts Tagged ‘table’

TTMMHTM: Scuba attacks in Norway,safer internet, mouse tracking and SMS API

Wednesday, February 10th, 2010

Things that made me happy this morning:

Turning a web folder with data into an API using YQL execute

Monday, November 30th, 2009

Yesterday Johan Bouveng challenged me on Facebook with another brain teaser. Johan had found a nice resource for weather forecasts for airports. The data came back in TAF or METAR formats and he already had a parser for this (thank f*** – what a mess these formats). Now, what he wanted to have is an API to get the weather forecast data from the following resources:

Using YQL and YQL execute this was pretty easy. All I had to do was to write an open table that reads the correct file.

// check if taf or metar was requested or return an error
if(datatype 'taf' || datatype ‘metar’){
var returnobj,url;

// get the correct url using the airport ID and format
url = ‘’ +
‘metar/stations/’ + airportid + ‘.TXT’
} else {
url = ‘’+
‘taf/stations/’ + airportid +’.TXT’;

// do a REST call and get the response back
var out =;

// if there is no data returned, return an error.
if(out == ‘’){
returnobj = Airport {airportid} not found.;

// otherwise return the data in the TXT file
} else {
returnobj = {out};

} else{
// error condition for wrong datatype
returnobj = Datatype must be either taf or metar.;

// give back the data to YQL
response.object = returnobj;

Having done this you can now use it as a table in YQL:

use “” as aw;
select * from aw where airportid=”AAXX” and datatype=”taf”;

As you can see, you don’t have to be a genius to build your own API :)