ODBC Driver for Twitter

Build 24.0.9060

Mentions

Query the most recent mentions (tweet containing @username) for the authenticating user.

Columns

Name Type Description
ID [KEY] String The Id of the status update or tweet. Set this value when inserting to instead retweet an existing tweet.
IDLong Long The long type Id of the status update or tweet.
Created_At Datetime When the tweet was made.
Text String The text of the tweet.
Source String Source of the tweet.
Favorited Boolean Boolean indicating if this tweet has been favorited.
Favorite_Count Integer The approximate number of times this tweet has been favorited.
Retweet_Count Integer The number of times the tweet has been retweeted.
Retweeted_Status_Id String Id of the tweet which was retweeted by this one. Empty if the current tweet is not a retweet.
User_Id String Id of the user who made the tweet.
User_Name String Name of the user who made the tweet.
User_Screen_Name String Screen name of the user who made the tweet.
User_Location String Location of the user who made the tweet.
User_Profile_URL String URL to the profile of the user who made the tweet.
User_Profile_Image_URL String URL to the user's profile image.
User_Mentions String Mentions of other users in the tweet, returned as an XML aggregate.
URLs String URLs in the tweet, returned as an XML aggregate.
Hashtags String 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.

Include_Retweets Boolean Boolean indicating whether or not to include retweets in the result set.

The default value is true.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060