Using Records within YQL

If your record contains an environment file, an Open Data Table, or JavaScript, YQL can "execute" or run it in a read-only manner.

Using Hosted Environment Files

When a record contains a YQL environment file, use the corresponding execute access key in YQL calls as you would any environment file. The following example uses URL encoding for the execute access key and appends it to the YQL console URL:

https://developer.yahoo.com/yql/console?env=store%3A%2F%2Fopendatatables

Using Hosted YQL Open Data Tables

When a record contains an Open Data Table, use the corresponding execute access key in YQL calls as you would any Open Data File. In the following example, the USE keyword invokes the access key, which is then used as mytable:

use "store://35ad2c72-e353-41c4-9d21-4a7e5a1ec92" as mytable; select * from mytable;

Including Hosted JavaScript

When a record contains JavaScript, use the select access key in YQL to include it in an Open Data Table.

Note

You do not use the execute access key with JavaScript includes using y.include because parsing JavaScript is done in the same manner as reading it.

To do a JavaScript include, first insert the JavaScript into a record in the following manner:

insert into yql.storage.admin (name, url) values ('testjs', 'http://javarants.com/yql/test.js')

The response from YQL contains the following URLs:

Use the select URL in the select element of the Open Data Table in the following manner:

Table of Contents