Fetch twitter¶
social • 3rd party API • integration
Enriches a dataset containing tweets with information about their authors.
In addition to author information also adds the location the tweet was send from (if available), and indicates whether a tweet was retweeted or favourited at least once. See below for a detailed list of the enrichment columns.
API integration
To use this step you will need to create an app associated to your Twitter account, and obtain four items: the consumer_key, the consumer_secret, the token and the token_secret.
To do so you can follow the steps here, and then add them to a Graphext integration.
Usage¶
The following are the step's expected inputs and outputs and their specific types.
fetch_twitter(tweet_ids: category|number, {"param": value}) -> (
user_created_at: date,
user_description: text,
user_favourites_count: number,
user_followers_count: number,
user_following_count: number,
user_listed_count: number,
user_profile_image_url_https: url,
user_protected: boolean,
user_tweets_count: number,
user_profile_url: url,
user_verified: boolean,
user_location: category,
lat: number,
long: number,
retweeted: boolean,
favorited: boolean,
source: category
)
where the object {"param": value}
is optional in most cases and if present may contain any of the parameters described in the
corresponding section below.
Example¶
This step doesn't have any configuration parameters. Hence simply:
fetch_twitter(ds.id) -> (
ds.user_created_at,
ds.user_description,
ds.user_favourites_count,
ds.user_followers_count,
ds.user_following_count,
ds.user_listed_count,
ds.user_profile_image_url_https,
ds.user_protected,
ds.user_tweets_count,
ds.user_profile_url,
ds.user_verified,
ds.user_location,
ds.lat,
ds.long,
ds.retweeted,
ds.favorited,
ds.source
)
Inputs¶
tweet_ids: column:category|number
Twitter's unique identifier for each tweet.
Outputs¶
user_created_at: column:date
Time the user who tweeted this tweet was created.
user_description: column:text
Self-description of the user.
user_favourites_count: column:number
How many tweets the user has favorited.
user_followers_count: column:number
How many followers the user has.
user_following_count: column:number
How many users the user is following.
user_listed_count: column:number
How many times the user has been listed in public listings.
user_profile_image_url_https: column:url
User's picture.
user_protected: column:boolean
Whether this user has protected their tweets or not.
user_tweets_count: column:number
How many times this user has tweeted.
user_profile_url: column:url
User's profile url.
user_verified: column:boolean
Whether this user is verified or not.
user_location: column:category
Location extracted from the author profile.
lat: column:number
Latitude this tweet was tweeted from.
long: column:number
Longitude this tweet was tweeted from.
retweeted: column:boolean
Whether you have retweeted this tweet.
favorited: column:boolean
Whether you have favorited this tweet.
source: column:category
Where this tweet was tweeted from as a HTML string.
Parameters¶
integration: string
ID of the integration you'd like to use.