In this Chapter:
While YQL SELECT statements allow you to read structured data from almost any source on the Web, their expressed purpose is only to read data.
To perform data manipulation, YQL provides three other SQL-like keywords for writing, updating, and deleting data mapped using a YQL Open Data Table, namely INSERT, UPDATE, and DELETE (I/U/D).
The INSERT statement inserts or adds new data to YQL tables, while the UPDATE statement updates or modifies existing data. DELETE, as the name implies, removes data.
Most sources that provide write capability need authentication. Examples of authentication include username/password combinations or secret API tokens.
If your table requires input that is deemed "private", such as any passwords,
authentication keys, or other "secrets", you MUST ensure the
https attribute within the
tables element is set to
For more information on about securing private data in Open Data Tables, refer to Ensuring the Security of Private Information.