JDBC Driver for Twitter

Build 22.0.8462

ListSubscribers

Query the subscribers to a specified list.

View Specific Information

Subscribers of a specified list can be found under ListSubscribers.

The column List_Id can be used to specify the Id of a list you wish to obtain the members of.

Columns

Name Type Description
ID [KEY] String The Id of the user.
List_Id String Used to specify the list Id to retrieve tweets from.

The default value is 2031945.

Name String The name of the user.
Screen_Name String The screen name of the user.
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.

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.

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