Products My Apps

Yahoo Query Language (YQL)

The YQL (Yahoo! Query Language) platform enables you to query, filter, and combine data across the web through a single interface. It exposes a SQL-like syntax that is both familiar to developers and expressive enough for getting the right data.

Try YQL Console

Access Data Across the Web

Select, filter, sort and join data across web services. You can even insert, update and delete from YQL.

Easily Scrape HTML

Scrape HTML from the web and turn it into data to reuse. Create an API where one doesn’t exist.

Transform XML to JSON

Use YQL to convert XML to JSON & vice versa. Access atom, rss, micro formats and more. You can even load CSV files from anywhere.

Speed up Your App

With YQL, apps run faster with fewer lines of code and a smaller network footprint. Batch multiple HTTP requests into a single request.

Mashup Data Sources

Mix and match data from disparate sources using YQL sub-selects.

Extend it

Define Open Data Tables to access any data sources other than Yahoo Web Services

Sample YQL Response

Examples

Responses

+
YQL (Yahoo Query Language) is a SQL-like language that lets you query, filter, and join data from Web services. With YQL, you can access data across the Internet through simple REST requests, eliminating the need to learn how to use different APIs.

Who's using YQL

Attribution Guidelines

Thank you for being a part of Yahoo Developer Network community, that helps Yahoo to be part of your users’ daily habits. Please follow our Attribution Guidelines for Yahoo APIs wherever you use YQL.

Rate Limits

Use of the YQL should not exceed reasonable request volume. Access is limited as below:

  • Per application limit (identified by your Access Key): 100,000 calls per day
  • Per IP limits: /v1/public/*: 2,000 calls per hour; /v1/yql/*: 20,000 calls per hour

Get Started

Check out YQL Console

Explore the YQL platform directly in your browser. Build and test your YQL queries easily.
Try YQL Console

Get your API Keys

Create an application. This will give you Consumer Key and Secret which are needed for using the API.

Copy Example Code

We have code examples in different languages below to get you up and running as quickly as possible. Replace your key and secret in the code below.

Build and Launch

When your app is ready to use, tell other developers what you have built in our Forums.

What's Next?

Using YQL for Commercial and Non-Commercial Applications

Our goal is to make it easy for you to use YQL in the widest possible range of applications. Please read the notice and usage limits described below for more information. If you have additional questions, please read the YQL Terms of Service.

Notice

  • The YQL Service can be used for commercial purposes without prior approval from Yahoo.
  • Developers using the YQL Service fetching data from a content provider need to conform to the Terms of Service of the content provider.
  • Data available on the Yahoo! network (e.g., Finance, Weather) is not approved for commercial usage via YQL, unless mentioned otherwise in the Terms of Service.

Additional Notes

  • All rates and terms of service are subject to change.
  • You may also be subject to the underlying rate limits of other Yahoo and 3rd party web services.
  • YQL relies on the correct operation of the web services and content providers it accesses.
  • Open Source content/data tables are not certified by Yahoo.
  • Please remember that it is your responsibility to obtain the necessary permissions from the content or API providers to use their content or services, separate from your use of YQL: neither Yahoo nor your use of YQL cover those permissions.
  • Content or API providers can opt out or restrict YQL access to their data by following the instructions in YQL for Content and API Providers.

Please use the YQL Forum for additional information or questions.