Favorites
Create, delete, and query a list of favorite tweets of the authenticated user and allow the user to favorite new tweets or remove existing favorites.
Table Specific Information
The authenticated user's favorites may be viewed from Favorites.
Select
The Min_Id and Max_Id pseudo columns may be used to narrow down a range of tweets to return, or to return only recent tweets. Additionally, the Include_Entities pseudo column may be specified, which can reduce the size of the response if it is set to false.
Insert
New tweets may be favorited by performing an insert and specifying the Id of the tweet.
Update
The UPDATE operation is not available on this table.
Delete
Favorites may be removed by performing a DELETE operation and specifying the Id of the tweet to remove from Favorites.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The Id of the status update or tweet. Set this value when inserting to retweet an existing tweet. |
| IDLong | Long | False |
The long type Id of the status update or tweet. |
| Created_At | Datetime | True |
When the tweet was made. |
| Text | String | False |
The text of the tweet. |
| Source | String | True |
Source of the tweet. |
| Favorited | Boolean | True |
Boolean indicating if this tweet has been favorited. |
| Retweet_Count | Integer | True |
The number of times the tweet has been retweeted. |
| From_User_Id | String | True |
Id of the user who made the tweet. |
| From_User | String | True |
Screen name of the user who made the tweet. |
| From_User_Name | String | True |
Name of the user who made the tweet. |
| From_User_Lang | String | True |
Language code the from user is using. |
| From_User_Profile_URL | String | True |
URL to the user who made the tweet. |
| From_User_Profile_Image_URL | String | True |
URL to the profile image for the from user. |
| From_User_Location | String | True |
The location of the user. |
| To_User_Id | String | True |
Id of the user whom the tweet was sent to. |
| To_User_Screen_Name | String | True |
Screen name of the user whom the tweet was sent to. |
| User_Mentions | String | True |
Mentions of other users in the tweet, returned as an XML aggregate. |
| URLs | String | True |
URLs in the tweet, returned as an XML aggregate. |
| Hashtags | String | True |
Hashtags in the tweet, returned as an XML aggregate. |
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. |
| Min_ID | String |
Specifies the lowest Id to return results for. Ids are stored in increasing numerical order, so specifying this value means that only tweets that are equal to or newer than the creation date of the specified Id will be returned. The Min_Id must be a valid number but does not need to be a valid tweet Id. |
| Max_ID | String |
Specifies the highest Id to return results for. Ids are stored in increasing numerical order, so specifying this value means that only tweets that are equal to or older than the creation date of the specified Id will be returned. The Max_Id must be a valid number but does not need to be a valid tweet Id. |
| Include_Entities | Boolean |
Boolean indicating whether or not to include entities such as URLs, hashtags, and user mentions in the response. The default value is false. |