You create new records in three ways using the
yql.storage.admin Open Data
executekey that you name and insert content from an existing URL.
Any data you store within a record cannot exceed 100KB.
Upon creating a new record, YQL responds with three access keys, each of which serves a different function, as seen in the following response snippet:
There are three access keys associated with each record in storage, each starting with
usestatements or referring to
envfiles. You can share this access key with other developers, who can use the Open Data Table or environment file but will be unable to “read” the table definition or environment details.
update access key
is sufficient to perform those operations on the stored record. You should only share with
others the access key that grants the desired permissions.
To create a new text record in storage for YQL, use the following statement format:
insert into yql.storage.admin (value) values ("example text content")
To copy the contents of an URL, such as an environment file or Open Data Tables, into a new record for YQL, use the following statement format:
insert into yql.storage.admin (url) values ("http://hostingdomain.com/mytable.xml")
To copy the contents of an URL, such as an environment file or Open Data Tables, into a
new record with a custom
execute access key, use the following statement
insert into yql.storage.admin (name,url) values ("newrecord","http://hostingdomain.com/mytable.xml")
When you create a record using the above format, the
execute access key
uses the name (
newrecord) and top-level domain of the URL
hostingdomain.com) that you supply, as seen in the following response
Using the SET keyword in conjunction with a storage record, you can set and hide values, such as passwords, API keys, and other required values independently of YQL statements and API calls . For more information, refer to Setting Key Values for Open Data Tables.