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 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.


  1. An new alternative to YQL is

    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.

  2. Hey, what a blog you write,is such wonderful wrinting i never read this ind of stuff.
    Lets talk about one of the best senior care sevices all over Colorado or sarrounding areas. So i rescomand you the Gardens Care Homes Company who is top leading organization in the country for assisted living indutry. Dont worry about the prices, our cheap rates always suits your pocket.
    Arvada Assisted Living
    Lakewood Assisted Living
    Castle Rock Assisted Living
    Aurora Assisted Living
    Federal Heights Assisted Living
    Denver Assisted Living
    Colorado Assisted Living

  3. Take the guess work out of finding an in Redlands Electrician by using Fallon Solutions experienced electrical team. From the initial job booking through to completion of the work, our team maintain communication with the customer, ensuring you know when we'll be there, what's going on, how much it will cost and when the job will be done.

  4. Quickbooks is especially ravishing in assignments like following accounts, arranging deals, and helping with solicitations. We can see the brilliance of this software in each component it has. Notwithstanding its flawlessness, QB clients like you and me need to confront a few errors on occasion. It is once in a while frustrating as you need to keep down your significant works. One such issue that frequents Quickbooks is the quickbooks won't open error. It is a error that limits the client from opening the QB work area programming.

  5. Quickbooks is particularly bewitching in tasks like after accounts, masterminding arrangements, and assisting with requesting. We can see the brightness of this product in every part it has. Regardless its faultlessness, QB customers like you and me need to stand up to a couple of mistakes now and again
    quickbooks tool hub download

  6. quick book will help to maintain data, files and error free features . It is error that limits the conglomerates corporates from opening QB work station programmed.
    quickbooks tool hub download

  7. quickbooks error 15106 happens when you're attempting to place in the most up to date update and it can't open on the grounds that refreshed programming is defiled.

  8. managing finance was must. you can check it out quickbooks file doctor this is a software on which you can mange your finacial things like bookkeeping

  9. QuickBooks is a comprehensive accounting software application. It comes in a variety of product variants. It simplifies and simplifies operations for any organization simply because all users can now handle their essential transactions, GST invoices, tax e-payments, bank reconciliation, automatic payment reminders, filter reports, and so on, on any financial platform.

    Without a doubt, it is the world's best accounting software program designed specifically for small, medium, and large-sized businesses, but like any other software, there are times when QuickBooks fails to function properly and generates certain QuickBooks Error Codes that can be caused by a variety of factors that are difficult to resolve in real-time.
    quickbooks auto data recovery
    quickbooks error #15215
    quickbooks portable file
    quickbooks error 179
    quickbooks error 6144 82
    component repair tool quickbooks
    quickbooks error 1334
    quickbooks error 1328
    quickbooks runtime error
    quickbooks firewall error


  10. Thanks for sharing the wonderful article I am glad after coming on this site! It has the information that I was searching for so long. if you want to like the article and want to search more check on quickbooks error #15215

  11. Good tools you have.
    here i also have some tools quicbooks and sage both are accounting software but the features are differentof both softwares. the quickbooks are estimates of invoices, track inventory while sage are E-filling, inventory management quickbooks vs sage

  12. download QuickBooks tool hub is equipped with multiple functionalities to help you to resolve common QuickBooks errors. So, if you’re new, inexperienced, or facing difficulties while using QuickBooks, worry no more. This article will guide you through how to use the QuickBooks Desktop Tool Hub to get rid of common errors.


  13. Your content is very commendable i really liked your work personally as it contain all the necessary detail which a reader is searching for and its really nice experience to go through your page . and if anyone of you were facing quickbooks error #15215 to resolve this issue
    quickbooks unexpected error 5: A QBs Repairing Guide

  14. You might come across an error message reading “Printer not responding” while trying to print something. Multiple reasons cause this problem such as improper configuration, bad hardware status, faulty drivers, etc.

  15. Hey nice blog,
    your posts are so simple and nice. Keep going on.

    By the way I was facing Quickbook error ps033
    in the popular tool, QuickBooks. Hope this helps.

  16. Good information given by u thank u for it. Few days back i use a software name Quickbook it is Awesome really it is good for using in account and taxes and many more work one error i found on that quickbooks error 404 but now it resolved so u can go through that.

  17. nice informative site.
    Quickbooks won't open i used this software at last 6-months and it was has easy user interface and easy to handle all data related to banking sector.

  18. Hey thanks for this informative post, if you by any chance face QuickBooks Pro Error 1334 in your Quickbooks accounting software, any types of network issues or company file issues make sure to visit ebetterbooks.

  19. Hey nice blog, thanks for this informative post.
    its very Beneficial for me, YQL as a free alternative to Google Translate, Google Finance and Google Weather API.
    I have recently corrected
    QuickBooks License Error with the help of QuickBooks tools.

  20. This post is great. I really admire your post. Your post was awesome. If you need any support for QuickBooks then get immediate help from our QuickBooks Experts.

    QuickBooks Error 3371 Status Code 11118

  21. If you're looking for someone who specialises in QuickBooks Online, look no further. Now, I will warn you that Intuit does not distinguish between regular and so you may have to ask a few on there. Alternatively, you can conduct a simple Google search (include your virtual bookkeeper ustry and you may even find someone who specialises in it!). system.