Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

rkondaveti
New Contributor II

Re: connection qlik sense to twitter

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
New Contributor II

Re: connection qlik sense to twitter

Would like to implement this in Qlik

Creating a signature — Twitter Developers