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';