Chapter 7. Updates Tables

Updates are a stream of recent events and activites that help users stay in touch with their connections (friends). Examples of updates are posting to a blog, uploading photos, and adding users to the list of connections.

The Updates Tables consists of two tables for accessing updates from Yahoo! users. The Updates Table allows you to get, create, and remove Yahoo! Updates and is similar to the Updates REST API. The Updates Search Table, also known as the "Firehose Table," offers read access to all of the public updates on Yahoo!.

Updates Table

Description

The Updates Table supports both read and write statements. Use SELECT to read updates, INSERT to post updates, and DELETE to delete updates.

Table

social.updates

Allowed Statements

  • DELETE
  • INSERT
  • SELECT

Keys

Key Name Data Type Allowed for Statements Required for Statements Default Value Description
description string INSERT INSERT None A brief description of the update.
guid string DELETE, INSERT, SELECT DELETE, INSERT, SELECT None The GUID of the user.
imgHeight string INSERT None None The height of the image associated with the update.
imgURL string INSERT None None The URL of the image associated with the image.
imgWidth string INSERT None None The width of the image associated with the update.
link string INSERT None http://developer.yahoo.com/yql The URL where the user will land when they click on the update.
pubDate string INSERT None None The timestamp, in standard Unix timestamp format (RFC 3339), represents the UGC time for when the update was first published.
source string DELETE DELETE APP.-QUERY58 Identifies the application or Yahoo! site (property) that generated the update.
suid string DELETE DELETE YQLUpdate For a given application (source) and GUID (collectionID), the suid uniquely identifies the update. See also SUID Identifier.
title string INSERT INSERT None The name of the object or event associated with the update.
transform string SELECT None (sort "pubDate" numeric descending (all)) The transform statement used to filter a set of updates. See Transform for details.
type string INSERT None appActivity The update type. The meaning of the chosen value is up to the application or website that creates the update. See Update Types for a list of possible values for type.

Example Statements

DELETE

This example statement deletes the signed-in user's update identified by the SUID "9.3341" and the source "y.presence".

DELETE FROM social.updates WHERE guid=me AND suid="9.3341" AND source="y.presence"

INSERT

This example statement creates a new update for the signed-in user.

INSERT INTO social.updates (guid, title, description) VALUES (me, 'Created a Foursquare account.', 'John has joined Foursquare and will start sharing his favorite places with his friends.')

SELECT

This example statement returns the last ten updates for the signed-in user. Run the query in the YQL Console.

SELECT * FROM social.updates WHERE guid=me

Elements of the Single Update

See the Elements of the Updates Object.

Example Responses

JSON Example Response Body for SELECT Updates
XML Example Response Body for SELECT Updates

Table of Contents