SSIS Components for Twitter

Build 24.0.9060

Followers

Query a list of users following the current Twitter account.

View Specific Information

The authenticated user's followers and a specified user's followers may be viewed from Followers.

By default, Followers will return the followers of the authenticated user. By specifying a Followers_Of_User_Id or Followers_Of_Screen_Name, the followers of the specified user will be returned.

LookUpUsers refers to looking up additional information about the followers returned from Twitter. Normally only the Ids of followers are returned from Twitter. If LookUpUsers is set to true, additional queries will be made to Twitter to retrieve user details, such as the Screen_Name. LookUpUsers is true by default.

MaxUserLookup refers to the maximum number of users to additionally look up information on. A maximum of 100 user details may be returned from Twitter per request. Setting this value higher will cause details for more users to be returned, but at the cost of additional requests. MaxUserLookup defaults to 100.

Columns

Name Type Description
ID [KEY] String The Id of the user.
Name String The name of the user.
User_Id String The Id of the user.
Screen_Name String The screen name of the user.
Followers_Of_User_Id String Use this in the WHERE clause to retrieve the users a specific user is following other than the authenticated user.
Followers_Of_Screen_Name String Use this in the WHERE clause to retrieve the users a specific user is following other than the authenticated 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, 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.
LookUpUsers String A boolean indicating if you would like to additionally look up details about the user Ids returned. Normally only Ids will be returned from Twitter, but additional requests can be made to Twitter to retrieve user details.

The default value is true.

MaxUserLookup String The maximum number of users to perform a lookup on. Each user lookup is limited to a maximum of 100 Ids per request.

The default value is 100.

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