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 a 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
|DirectMessages||Returns direct messages sent and received within the past 30 days by the authenticated user, sorted in reverse chronological order.|
|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
|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”.|
|list:NASA/astronauts-in-space-now||sent from an account on the
sent to person
|politics filter:safe||containing "politics" and
|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
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
Working with the Twitter Search API quota limits
To learn more about the
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
Wait a short while and then try again.
You receive an error message when trying to preview data with direct message tables
Do the following:
- From your
- Find the Qlik Web Connectors and verify your permissions.
You receive an error message when trying to verify your account
You try to verify a connection to your
You did not use the right password when trying to authenticate the connection to your
Send an authorization request again by clicking on Authenticate. Copy the provided PIN and retry the verification process.