TDV Adapter for Twitter

Build 21.0.8137

Following

Create, delete, and query a list of users that the current Twitter account is following, otherwise known as friends.

Table Specific Information

Users whom the authenticated user is following will appear here. Additionally, users whom a specified user is following may be viewed from Following.

Select

By default, Following will return users whom the authenticated user is following. By specifying a Following_User_Id or Following_Screen_Name, users whom the specified user is following will be returned.

LookUpUsers refers to looking up additional information on the users returned from Twitter. Normally, only the Ids of users someone is following are returned from Twitter. If LookUpUsers is set to true, additional queries will be made to Twitter to retrieve user details, such as a 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.

Insert

The authenticated user may follow another user by performing an insert based on either the User_Id or the Screen_Name.

Update

The UPDATE operation is not available on this table.

Delete

The authenticated user may stop following another user by performing a delete based on the Id.

Columns

Name Type ReadOnly Description
ID [KEY] String False

The Id of the user.

Name String True

The name of the user.

User_Id String False

The Id of the user.

Screen_Name String False

The screen name of the user.

Following_User_Id String False

Use this in the WHERE clause to retrieve the users a specific user is following other than the authenticated user.

Following_Screen_Name String False

Use this in the WHERE clause to retrieve the users a specific user is following other than the authenticated user.

Location String True

The location of the user.

Profile_URL String True

The URL for the user's profile.

Profile_Image_URL String True

The URL for the image of the user.

Protected Boolean True

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 True

The ISO language code of the user.

Created_At Datetime True

When the user account was created.

Friends_Count Integer True

The number of people this user is following.

Followers_Count Integer True

The number of followers the user has.

Favourites_Count Integer True

The number of favorites the user has.

Statuses_Count Integer True

The number of status updates or tweets the user has made.

UTC_Offset Integer True

The Coordinated Universal Time offset for the user in seconds.

Time_Zone String True

The time zone of the user.

Notifications Boolean True

Boolean indicating if the user has notifications enabled.

Geo_Enabled Boolean True

Boolean indicating if the user has geo-enabled turned on in their profile.

Verified Boolean True

Boolean indicating if the user account has been verified.

Following Boolean True

Boolean indicating if the user is following you.

Contributors_Enabled Boolean True

Boolean indicating if contributors are enabled for the account. Typically used in multiuser accounts.

Follow_Request_Sent Boolean True

If the user is a protected user, this column indicates if the authenticated user has sent a request to follow them.

Listed_Count Integer True

The number of public lists a user is listed in. -1 if unknown.

Is_Translator Boolean True

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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137