Chapter 3. Connections Tables
A connection is a mutually confirmed relationship between two users. The connection between the two users allows them to share a higher degree of information.
The Connections Tables include two tables for accessing a user's connections and the updates of the user's connections.
Connections Table
Description
The Connections Table only supports read statements. Use SELECT to get the Yahoo! user's connections.
Table
social.connections
Allowed Statements
SELECT
Keys
| Key Name | Data Type | Allowed in Statements | Required in Statements | Default Value | Description |
|---|---|---|---|---|---|
owner_guid
|
string |
SELECT
|
SELECT
|
None | The GUID of the Yahoo! user. |
Example Statements
SELECT
This example statement returns ten connections of the signed-in user. Run the query in the YQL Console.
SELECT * FROM social.connections WHERE owner_guid=me
This example statement returns the profiles for then of the signed-in user's connections. Run the query in the YQL Console.
SELECT * FROM social.profile WHERE guid IN (SELECT guid FROM social.connections WHERE owner_guid=me)
Elements of the Connections Object
See the Elements of the Connections Object.