JDBC Driver for Twitter

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462