Following
Create, delete, and query a list of users that the current Twitter account is following, otherwise known as friends.
Table Specific Information
Users whom the authenticated user is following will appear here. Additionally, users whom a specified user is following may be viewed from Following.
Select
By default, Following will return users whom the authenticated user is following. By specifying a Following_User_Id or Following_Screen_Name, users whom the specified user is following will be returned.
LookUpUsers refers to looking up additional information on the users returned from Twitter. Normally, only the Ids of users someone is following are returned from Twitter. If LookUpUsers is set to true, additional queries will be made to Twitter to retrieve user details, such as a Screen_Name. LookUpUsers is true by default.
MaxUserLookup refers to the maximum number of users to additionally look up information on. A maximum of 100 user details may be returned from Twitter per request. Setting this value higher will cause details for more users to be returned, but at the cost of additional requests. MaxUserLookup defaults to 100.
Insert
The authenticated user may follow another user by performing an insert based on either the User_Id or the Screen_Name.
Update
The UPDATE operation is not available on this table.
Delete
The authenticated user may stop following another user by performing a delete based on the Id.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The Id of the user. |
| Name | String | True |
The name of the user. |
| User_Id | String | False |
The Id of the user. |
| Screen_Name | String | False |
The screen name of the user. |
| Following_User_Id | String | False |
Use this in the WHERE clause to retrieve the users a specific user is following other than the authenticated user. |
| Following_Screen_Name | String | False |
Use this in the WHERE clause to retrieve the users a specific user is following other than the authenticated user. |
| Location | String | True |
The location of the user. |
| Profile_URL | String | True |
The URL for the user's profile. |
| Profile_Image_URL | String | True |
The URL for the image of the user. |
| Protected | Boolean | True |
The privacy flag of the user. If true, then the user's account is private and only their approved followers can read their tweets or see extended information about them. |
| Lang | String | True |
The ISO language code of the user. |
| Created_At | Datetime | True |
When the user account was created. |
| Friends_Count | Integer | True |
The number of people this user is following. |
| Followers_Count | Integer | True |
The number of followers the user has. |
| Favourites_Count | Integer | True |
The number of favorites the user has. |
| Statuses_Count | Integer | True |
The number of status updates or tweets the user has made. |
| UTC_Offset | Integer | True |
The Coordinated Universal Time offset for the user in seconds. |
| Time_Zone | String | True |
The time zone of the user. |
| Notifications | Boolean | True |
Boolean indicating if the user has notifications enabled. |
| Geo_Enabled | Boolean | True |
Boolean indicating if the user has geo-enabled turned on in their profile. |
| Verified | Boolean | True |
Boolean indicating if the user account has been verified. |
| Following | Boolean | True |
Boolean indicating if the user is following you. |
| Contributors_Enabled | Boolean | True |
Boolean indicating if contributors are enabled for the account. Typically used in multiuser accounts. |
| Follow_Request_Sent | Boolean | True |
If the user is a protected user, this column indicates if the authenticated user has sent a request to follow them. |
| Listed_Count | Integer | True |
The number of public lists a user is listed in. -1 if unknown. |
| Is_Translator | Boolean | True |
Boolean indicating if the user contributes to translating Twitter in other languages. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| NextPageToken | String |
An identifier to retrieve the next page of results. Specify only if an error occurs during the original request. Make sure any criteria specified in the original request are still specified when using the NextPageToken. |
| LookUpUsers | String |
A boolean indicating if you would like to additionally look up details about the user Ids returned. Normally only Ids will be returned from Twitter, but additional requests can be made to Twitter to retrieve user details. The default value is true. |
| MaxUserLookup | String |
The maximum number of users to perform a lookup on. Each user lookup is limited to a maximum of 100 Ids per request. The default value is 100. |