Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

connection qlik sense to twitter

Hi community

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

rest.PNGfailed .PNG

11 Replies
rkondaveti
Contributor III
Contributor III

Hi Steve,

We are working on  REST API Connector and Web connector

REST Connector :

I am able to pull followers data from Twitter  using GET POSTMAN generated Authorization value, but it is gives me only 20 rows,using next cursor value i could get next batch of rows but oauth_signature and oauth_nonce need to be updated for each query to fetch more data however i struck at this point. i am not sure how to generate these values.


Tried your approach:


let vBASE64Key = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';

tmpBearerKey:

    SQL SELECT

"tokem_type",

        "access_token"

    FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION (

      URL "https://api.twitter.com/oauth2/token",

      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;

but it is throwing connection error.

Is there any way or script to generate unique values for these in a loop ?

WEB Connector:

it is fairly easy easy to pull the data using Twitter web connector. I could pull only 3000 row, not sure we could pull next set of data any idea on this ?

Cheers,

Raghav

rkondaveti
Contributor III
Contributor III

Would like to implement this in Qlik

Creating a signature — Twitter Developers