Max Manders

I’ve updated my fork of the yql-tables repository to include a data table to wrap the Spotify meta-data API.  I’ve issued a pull-request to the yql-tables maintainers so hopefully soon it should be included in the YQL environment.  However, I  notice the last pull request from another user was made in November last year and still hasn’t been answered; not sure if this suggests the project has stalled in some way.

Until it’s included in the environment and therefore available via the console and the web service end-point, you can use the table via this site.

-- Artist Search
USE 'http://maxmanders.co.uk/lab/spotify/spotify.search.artist.xml';
SELECT * FROM spotify.search.artist where artist = 'The New Pornographers';
-- Album Search
USE 'http://maxmanders.co.uk/lab/spotify/spotify.search.album.xml';
SELECT * FROM spotify.search.album where album = 'Together';
-- Track Search
USE 'http://maxmanders.co.uk/lab/spotify/spotify.search.track.xml';
SELECT * FROM spotify.search.track where track = 'Crash Years';

What is YQL?

The Yahoo! Query Language (YQL) is a fantastic web service from the Yahoo! Developer Network (YDN) that can dramatically speed up development time if your application involves requesting data from multiple disparate web services and somehow combining that data.  You can think of YQL as a gateway API that allows you to quickly and easily select, filter and combine data from across the web.

Continue reading

I’ve updated the UK Geocoding site to provide better documentation, and a UI for geocoding, in addition to the XML API.