TDV Adapter for Twitter

Build 21.0.8137

Users

Query a list of users based on the SearchTerms, Id, or Screen_Name.

View Specific Information

Users may be obtained via a search or specified in a list of Ids or screen names.

SearchTerms may be used to search for users in a method that is similar to the Find People search on Twitter.com. Up to the first 1000 matches will be available using SearchTerms.

You can specify either the Screen_Name or User_Id pseudo columns to perform a lookup. Up to 100 screen names or Ids may be specified by using a comma-separated list. Id may also be specified using a comma-separated list and will perform the same lookup.

The Min_Id and Max_Id pseudo columns may be used to narrow down a range of users to return, or to return only recently created users. Ids are created in increasing numerical order on Twitter. Specifying a Min_Id returns only results with a greater Id or tweets that were created more recently than the specified one. Setting a Max_Id returns only tweets that are older than the creation date of the specified Id to return. Note that while these values must be valid, non-negative numbers, they do not have to be Ids that exist.

Columns

Name Type Description
ID [KEY] String The Id of the user. A comma-separated list of user Ids may be used in the WHERE clause to get data about multiple users.
SearchTerms String A SearchTerms to use while searching users. This can return up to 1000 results.
Name String The name of the user.
Screen_Name String The screen name of the user. A comma-separated list of screen names may be used in the WHERE clause to get data about multiple users.
Location String The location of the user.
Profile_URL String The URL for the user's profile.
Profile_Image_URL String The URL for the image of the user.
Protected Boolean 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 The ISO language code of the user.
Created_At Datetime When the user account was created.
Friends_Count Integer The number of people this user is following.
Followers_Count Integer The number of followers the user has.
Favourites_Count Integer The number of favorites the user has.
Statuses_Count Integer The number of status updates or tweets the user has made.
UTC_Offset Integer The Coordinated Universal Time offset for the user in seconds.
Time_Zone String The time zone of the user.
Notifications Boolean Boolean indicating if the user has notifications enabled.
Geo_Enabled Boolean Boolean indicating if the user has geo-enabled turned on in their profile.
Verified Boolean Boolean indicating if the user account has been verified.
Following Boolean Boolean indicating if the user is following you.
Contributors_Enabled Boolean Boolean indicating if contributors are enabled for the account. Typically used in multiuser accounts.
Follow_Request_Sent Boolean If the user is a protected user, this column indicates if the authenticated user has sent a request to follow them.
Listed_Count Integer The number of public lists a user is listed in. -1 if unknown.
Is_Translator Boolean Boolean indicating if the user contributes to translating Twitter in other languages.
Description String The description of the user.
Url String A URL to the user page on Twitter.
Default_Profile Boolean Boolean indicating if the user is using the default profile design/theme.
Default_Profile_Image Boolean Boolean indicating if the user is using the default Twitter profile image.
Profile_Background_Color String Background color for the user's theme.
Profile_Background_Image_Url String HTTP URL for the user's background image in their theme settings.
Profile_Background_Image_Url_Https String HTTPS URL for the user's background image in their theme settings.
Profile_Background_Tile Boolean Boolean indicating if the user has used the Tile Background checkbox in their theme settings.
Profile_Image_Url_Https String HTTPS URL for the user's profile image.
Profile_Link_Color String Hexadecimal color code for the user's links.
Profile_Sidebar_Border_Color String The sidebar border color for the user.
Profile_Sidebar_Fill_Color String The sidebar fill color for the user.
Profile_Text_Color String The hexadecimal color code for text in the user's settings.
Profile_Use_Background_Image String Boolean indicating if the user is using the background image.
Show_All_Inline_Media String Boolean indicating if the user has enabled viewing all in-line media (pictures, videos, etc).

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.
User_ID String The Id of the user to return results for. This can be used in the WHERE clause of an SQL statement as a comma-separated list. Only up to 100 user Ids can be submitted per request.
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 users 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 user 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 users 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 user Id.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137