Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Would like to implement this in Qlik