I want to connect to my twitter account with qlik sense; I followed the steps to fill in all the identifiers; I created a connection with REST connector; I filled in all the fields but when I test the connection; it does not work . I have an error
When I have an Authorization key it has the quotes shown as quotes, rather than URL encoded, as "
I use PostMan ( https://www.getpostman.com/ ) to generate the Authorization string and then paste it in.
Note that the start of the oauth_consumer_key is a " symbol.
Watch that the Authorization key changes with the slightest change to the end point. Even changing a search parameter or number of rows returned will change this.
You may also like to look at this blog post by catalystmichael which talks about the Spotify API. It's a different API, but the techniques are very similar:
I'm hoping to polish my app, document it and upload it sometime soon. In the meantime here are some snippets from my load script that may help...
// To use this application you first need a valid Twitter acccount
// Log in to this and then go to https://apps.twitter.com and create a new API app
// Enter all the required information for a read only API application
// Go to the Keys and Application Keys tab and copy the Consumer Key and Secret into a new string separated by :
// Ensure that there are no rogue spaces or characters in this key
// Go to the site https://www.base64encode.org and paste your string in the top box
// Press the Encode button and a new string will be generated and appear in the bottom box
// Copy and pasted this string into the vBASE64 variable below
let vBASE64Key = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
HTTPHEADER "content-type" "application/x-www-form-urlencoded",
HTTPHEADER "Authorization" "Basic $(vBASE64Key)",
QUERY "grant_type" "client_credentials"
let vBearerKey = peek('access_token', -1, 'tmpBearerKey');
DROP TABLE tmpBearerKey;
FROM JSON (wrap off) "statuses" PK "__KEY_statuses"
WITH CONNECTION (
HTTPHEADER "Authorization" "Bearer $(vBearerKey)"
Did you get a chance to polish your app ? i am trying to extract data from Twitter but i struck at generating Oauth Signature and Oauth nonce. How did you generate them in your app ?
The Base64 key was created using an online Base 64 converter - is that what you are stuck at?
Another way of looking at Twitter in Sense is to sign up for a Cloud account at http://www.qlikcloud.com/ and then look in the Qlik Cloud Resources stream. There is a Twitter app you can copy and amend.
Hope that helps,