wpp hackday presentation - yql

YQLSriram Iyer

YQL Engineering

SELECT * FROM INTERNET

WHAT IS YQL

•Query, filter, and join data across web services•Merge multiple data sources

•Expressive SQL-like language•Uniform access •No need to call different APIs

•Execute JS code to mutate request/response•Decorate, annotate, create own data model

•Tools and documentation for rapid development•Console, Table Editor, Guide, Blog, and Forum

XML JSON CSV

XML JSONPJSON

HTML

YQL FORMATS

•Accepts JSON, XML, HTML, CSV

•Outputs XML, JSON, JSONP

•Provides data type transformers and mutators

•Tidies up data sources for you

•Lets you spend more time building your app

FAST, GLOBALLY AVAILABLE

•Deployed across the globe

•Both front and back facing caches

•Developers can control cache behavior•_maxage parameter•_stalewhilerevalidate parameter

•Rate limited for external developers•2000 calls per hour per IP on public endpoint•20000 on OAuth protected endpoint

APP DEVELOPMENT USING YQL

•Pick the open tables to build your app

•Build new ones for your API if needed

•Test the tables in the YQL console

•Use the YUI-YQL module to get data

•Or just call the REST query endpoint

DATA SECURITY USING YQL

•Public endpoint - /v1/public/yql•Non-personalized data – securityLevel=“any”

•OAuth endpoint – v1/yql•2-legged – securityLevel=“app”•3-legged – securityLevel = “user”

YQL CONSOLE

CONSOLE PARAMETERS - DIAGNOSTICS

CONSOLE PARAMETERS - DEBUG

CONSOLE PARAMETERS – DEBUG CONTD.

CONSOLE TIPS – REST QUERY

http://hackevent.yql.yahooapis.com/v1/public/yql?q=select%20*%20from%20answer.search%20where…

CONSOLE TIPS – COMMUNITY TABLES

CONSOLE TIPS – PERMALINK & ALIAS

TABLE EDITOR

•Rapid YQL table prototyping•Create YQL tables•Create YQL Environment files•Create YQL Javascript execute files

•Sample templates for all three

•Nifty drag & drop support

•All the above stored in the Yahoo! cloud

TABLE EDITOR – SAMPLE TABLE

http://hackevent.yql.yahooapis.com/v1/public/yql?q=use%20%22store%3A%2F%2FJBICskKfvKMhO3ddy3f0Wk%22%20as%20crunchbase.company%3B%20select%20*%20from%20crunchbase.company%20where%20name%3D%27yahoo%27&diagnostics=true

TABLE EDITOR – SAMPLE JAVASCRIPT

TABLE EDITOR – SAMPLE ENVIRONMENT

DEMO

QUESTIONS

THANKS

Console: http://developer.yahoo.com/yql/console

Endpoint: hackevent.yql.yahooapis.com

Community: http://www.yqlblog.net/ http://www.datatables.org/ https://github.com/yql/yql-tables

Email: yql-questions@yahoo-inc.com

Twitter: @yql

Slides: http://www.slideshare.net/sriramiyer2007/presentatio

ns