- Ways to access your data
- Working with the Twitter Search API quota limits
- Reference - Twitter Developer documentation
Ways to access your data
To access your
Loading data from tables
After you authenticate the connector with your account credentials, you can use the following tables to select and load data:
Shows information about an public Twitter account based on a search query.
|RateLimit||Shows the current rate limits for the different API end points.|
|TweetLookup||Shows the details for up to 100
Shows the user information for up to 100 users based on the
|UserLookupById||Shows the user information for up to 100 users based on the
|Mentions||Shows up to 800
|RetweetsOfMe||Shows the most recent tweets from the authenticated user that have been retweeted.|
|UserTimeline||Shows the most recent
|DirectMessagesSent||Shows the 20 most recent direct messages sent by the authenticated user.|
|DirectMessagesReceived||Shows the 20 most recent direct messages sent to the authenticated user|
|Favorites||Shows the liked
To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*). The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.
API Query Operators
The table below lists the official Twitter query operators.
|watching now||containing both “watching” and “now”. This is the default operator.|
|“happy hour”||containing the exact phrase “happy hour”.|
|love OR hate||containing either “love” or “hate” (or both).|
|beer -root||containing “beer” but not “root”.|
|#haiku||containing the hashtag “haiku”.|
|from:interior||sent from Twitter account "interior".|
|list:NASA/astronauts-in-space-now||sent from an account on the NASA list; account name: "astronauts-in-space-now"|
sent to person Twitter account "NASA".
|@NASA||mentioning Twitter account "NASA".|
|politics filter:safe||containing "politics" and Tweets marked as potentially sensitive removed.|
|puppy filter:media||containing "puppy" and an image or a video.|
|puppy filter:native_video||containing “puppy” and an uploaded video, Amplify video, Periscope, or Vine.|
|puppy filter:periscope||containing “puppy” and a Periscope video URL.|
|puppy filter:vine||containing “puppy” and a Vine.|
|puppy filter:images||containing “puppy” and links identified as photos, including third parties such as Instagram.|
|puppy filter:twimg||containing “puppy” and a pic.twitter.com link representing one or more photos.|
|hilarious filter:links||containing “hilarious” and linking to URL.|
|puppy url:amazon||containing “puppy” and a URL with the word “amazon” anywhere within it.|
|superhero since:2015-12-21||containing “superhero” and sent since date “2015-12-21” (year-month-day).|
|puppy until:2015-12-21||containing “puppy” and sent before the date “2015-12-21”.|
|movie -scary :)||containing “movie”, but not “scary”, and with a positive attitude.|
|flight :(||containing “flight” and with a negative attitude.|
|traffic ?||containing “traffic” and asking a question.|
To learn more about the Twitter Query Operators, refer to the search API documentation.
You can add RT or -RT to include or exclude retweets. For example, "Qlik RT" will search for retweets only and "Qlik -RT" will exclude retweets.
Twitter Action URLs (Web Intents)
You can respond to tweets or follow users from your Qlik Sense app by using
|Reply to a tweet||https://twitter.com/intent/tweet?in_reply_to=[TWEET_ID]|
|Retweet a tweet||https://twitter.com/intent/retweet?tweet_id=[TWEET_ID]|
|Favorite a tweet||https://twitter.com/intent/favorite?tweet_id=[TWEET_ID]|
|Short user profile, with option to Follow||https://twitter.com/intent/user?screen_name=[SCREEN_NAME]|
To learn more about use
The Qlik Web Connectors use the
To learn more about the
Reference - Twitter Developer documentation
You can refer to the Twitter Developer documentation to learn more about the requirements and restriction imposed by the Twitter API.
You receive an error message that you have reached the API rate limit
You have exceeded the API limits that are imposed on the Qlik Web Connectors by the
To reduce the impact of reaching the API rate limits, develop your app with the following in mind:
- Extract only the data you need.
- Reload one Twitter-based application at a time.
- Ensure that loops in your script that make API calls will not result in infinite loops.
- Select the Ignore Rate Limit Errors option to retrieve all data that is received before exceeding the rate limit.
You receive error code 130 - Twitter is over capacity
Twitter is temporarily over capacity.
Wait a short while and then try again.
You receive an error message when trying to preview data with direct message tables
The Twitter account that you are connected to does not have direct message permissions enabled. You can verify your permissions from your Twitter account.
Do the following:
- From your Twitter account, go to Settings and Privacy > Apps.
- Find the Qlik Web Connectors and verify your permissions.
From your Twitter account settings, click Revoke access. Then, from the Data load editor, click @ on your Twitter connection to update the connection. Click Update and then reauthenticate your connector with a new Twitter authentication token.