YQL Blog

New feature highlights:

• set verb for configuring static variables
• yql.storage tables for storing tables, environments and more in YQL itself
• debug mode for table development (debug=true)
• multiple environment support

Core table changes:

• update for geo.placemaker table
• social.connections.updates results are sorted by date similar to social.updates
• csv table now has a charset key (if the source doesn’t provide one this can be used instead of the utf-8 default)

New core tables:

• meme.*

Open Data Table schema changes

• input key “as” attribute for renaming parameters

Execute changes

• y.env function so you can load up enviroments inside a YQL execute element.
• y.crypto, for cryptographic signing
• y.context (single value, table, contains the name used by the executor of this table)

Bug fixes, including:

• xpath and multiple IN url selects on HTML page no longer fails
• table name is now present in execute
• sanitize() can now take no params
• workaround to ruby/github client-ip bug
• update query without where clause returns error message instead return null
• const key values are no longer mutable by the keys in the YQL query
• add client-ip to outgoing header based on incoming authenticated IP address
• @variables other than urls now work on data tables
• trim whitespace around json responses to parse better (fixes itunes issue)
• post method reverse(field=”id”) displays correct method name in error message
• User-Agent sent via HTML fetches through YQL should indicate Yahoo Pipes 2.0 (now uses: Mozilla/5.0 (compatible; Yahoo Pipes 2.0; +http://developer.yahoo.com/yql/provider) Gecko/20090729 Firefox/3.5.2)

Bug fixes, including

• URI Template Handler now supports multiple -neg variables.
• Escaped values in literals such as ‘\\d’ are now correctly passed to YQL execute as ‘\d’
• Fixed uritemplate table example
• Better integration of Local Search: Added search parameters to local.seach namely listing_id, omit_category, minimum_rating, route and sort

Enhancements

• YQL Execute: y.rest(uri) now parses HTML documents and returns an E4X object if the accept header is set to “text/html”.

  
  y.rest("http://finance.yahoo.com/q?s=yhoo").accept('text/html').get().response
  

• YQL now supports the ‘Access-Control-Allow-Origin’ header for new Cross Domain XHR requests.
• Introduced new URL based paging model to support services which return a link to the next page.

• Console and web service now support an “env” query parameter. This is a url that points to an environment/shell file that YQL will load. Currently this enables multiple tables to be used at once.
• “Use” table no longer requires the “as” clause. When “as” is absent it will default to the final path segment filename minus the extension. e.g. use 'http://somewhere/service.api.xml; select * from service.api;
• Show tables now shows where the open data definition was defined
• Desc table format tweaked
• Open data table paging fixes, including better support for none paging but flexible result sized services and fixed page models. Moved “matrix” to the paging parent element.
• Offset bug fixed in table(offset,number) processing

New tables

• upcoming.user
• microformats
• flickr.photos.sizes

Table updates

• local.search “location” key is now optional
• mybloglog user by service
• fixed typo in mybloglog.members.find
• “charset” is now an optional key in html table, to enable developers to force a particular charset to be used when parsing the web page

Bug fixes, including:

• more html and xhtml and i18n issues fixed for html table
• subselect fix for optional keys

Other:

• publiclyCallable element in diagnostics is set to true if the query can work across the public entrypoint
• show tables response format changed

Note: future releases will more strictly apply robots.txt to html table fetches