Open Data Table Examples

Welcome, guest Sign In

My Projects
Tools & Services
APIs and Services
- Flickr
- Geo
- Mail
- Search
- Social
- Updates
- YAP
- YQL
Developer Tools
- Hadoop
- YUI
- YSlow
- View all »
Resources
- Blog
- YDN Theater
- Hack U

YDN Open Data Table Examples

Prev — Open Data Tables Reference

Open Data Tables Security and Access Control — Next

Open Data Table Examples

This section includes a few examples of Open Data Tables that showcase the ability of YQL to gather data from external APIs.

Tip

For a much larger list of publicly available Open Data Tables, refer to datatables.org.

Flickr Photo Search

This Open Data Table definition ties into the Flickr API and allows YQL to retrieve data from a Flickr photo search:

<?xml version="1.0" encoding="UTF-8"?>
<table xlmn="http://query.yahooapis.com/v1/schema/table.xsd">
  <meta>
    <author>Yahoo! Inc.</author>
    <documentationURL>http://www.flickr.com/services/api/flickr.photos.search.html</documentationURL>
    <sampleQuery>select * from {table} where has_geo="true" and text="san francisco"</sampleQuery>
  </meta>
  <bindings>
   <select itemPath="rsp.photos.photo" produces="XML">
      <urls>
        <url env="all">http://api.flickr.com/services/rest/?method=flickr.photos.search</url>
      </urls>
      <paging model="page">
        <start id="page" default="0" />
        <pagesize id="per_page" max="250" />
        <total default="10" />
      </paging>
      <inputs>
        <key id="woe_id" type="xs:string" paramType="query" />
        <key id="user_id" type="xs:string" paramType="query" />
        <key id="tags" type="xs:string" paramType="query" />
        <key id="tag_mode" type="xs:string" paramType="query" />
        <key id="text" type="xs:string" paramType="query" />
        <key id="min_upload_date" type="xs:string" paramType="query" />
        <key id="max_upload_date" type="xs:string" paramType="query" />
        <key id="min_taken_date" type="xs:string" paramType="query" />
        <key id="max_taken_date" type="xs:string" paramType="query" />
        <key id="license" type="xs:string" paramType="query" />
        <key id="privacy_filter" type="xs:string" paramType="query" />
        <key id="bbox" type="xs:string" paramType="query" />
        <key id="accuracy" type="xs:string" paramType="query" />
        <key id="safe_search" type="xs:string" paramType="query" />
        <key id="content_type" type="xs:string" paramType="query" />
        <key id="machine_tags" type="xs:string" paramType="query" />
        <key id="machine_tag_mode" type="xs:string" paramType="query" />
        <key id="group_id" type="xs:string" paramType="query" />
        <key id="contacts" type="xs:string" paramType="query" />
        <key id="place_id" type="xs:string" paramType="query" />
        <key id="media" type="xs:string" paramType="query" />
        <key id="has_geo" type="xs:string" paramType="query" />
        <key id="lat" type="xs:string" paramType="query" />
        <key id="lon" type="xs:string" paramType="query" />
        <key id="radius" type="xs:string" paramType="query" />
        <key id="radius_units" type="xs:string" paramType="query" />
        <key id="extras" type="xs:string" paramType="query" />
        <key id="api_key" type="xs:string" const="true" private="true" paramType="query" default="45c53f8...d5f645"/>
      </inputs>
    </select>
  </bindings>
</table>

Run this example in the YQL console.

Tip

To get a better understanding of how bindings work within YQL Open Data Tables, compare the Open Data Table definition above to photo.search on the Flickr API.

Digg Events via Gnip

The following example ties into the Gnip API to retrieve activities from a Publisher, which in this case is Digg.

<?xml version="1.0" encoding="UTF-8"?>
<table xmlns="http://query.yahooapis.com/v1/schema/table.xsd">
  <meta>
    <sampleQuery>select * from {table} where publisher='digg' and action='dugg'</sampleQuery>
  </meta>
  <bindings>
    <select itemPath="activities.activity" produces="XML" >
      <urls>
        <url env="all">https://prod.gnipcentral.com/publishers/{publisher}/notification/{bucket}.xml</url>
      </urls>
      <inputs>
        <key id="publisher" type="xs:string" paramType="path" required="true" />
        <key id="bucket" type="xs:string" paramType="path" required="true" />
        <key id="Authorization" type="xs:string" paramType="header" const="true" default="Basic eXFsLXF1ZXN...BpcGVz" />
      </inputs>
    </select>
    <select itemPath="activities.activity" produces="XML" useProxy="true" auth="callback">
      <urls>
        <url env="all">https://prod.gnipcentral.com/publishers/{publisher}/notification/current.xml</url>
      </urls>
      <inputs>
        <key id="publisher" type="xs:string" paramType="path" required="true" />
        <key id="Authorization" type="xs:string" paramType="header" const="true" default="Basic eXFsLXF1ZXN0a...BpcGVz" />
      </inputs>
    </select>
  </bindings>
</table>

Run this example in the YQL console.

Open Data Table Examples

Tip

Flickr Photo Search

Tip

Digg Events via Gnip

Table of Contents