Sep 12, 2012

YQL as a free alternative to Google Translate, Google Finance and Google Weather API

Google has closed its free Google Translate API, Google Finance API and the unofficial Google Weather API, which many websites were dependent on. Fortunately, the Yahoo Query Language comes to their rescue. It takes SQL-like statements and provides data from many web services (like SQL tables) in JSON or XML format. You can use the following alternatives for Google APIs:

select * from yahoo.finance.quotes where symbol in ("YHOO","GOOG"); for Yahoo! Finance

select * from weather.bylocation where location='Chicago' and unit='f'; for Yahoo! Weather

select * from wunderground.forecast where location='Chicago'; for Weather Underground

select * from google.translate where q="This is a test" and target="de"; for Google Translate

Tutorials and examples of consuming YQL are provided on Yahoo! website.

2 comments:

  1. An new alternative to YQL is sqall.co

    It lets you run SQL queries on APIs just like YQL but also lets you send the data to a database table or a CSV file. It's closer to a database management tool.

    ReplyDelete
  2. Yahoo finance API is not available anymore. I have moved to MarketXLS after this change, much more reliable data.

    ReplyDelete