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.
An new alternative to YQL is sqall.co
ReplyDeleteIt 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.
Yahoo finance API is not available anymore. I have moved to MarketXLS after this change, much more reliable data.
ReplyDelete