Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

custom connect to with variable

Hi all,

im using the REST API to connect to twitter and download tweets relating to a key word. the keyword can change therefore I've set it to be a variable. when i use the variable inside the URL it doesn't use the calculated value (in this case Traffic), instead it uses the only expression leading to a failure.

ive tried using several variable i.e

URL1 = pre keyword

URL2 = post keyword

URL = URL1 & vKeyword & URL2

but when i do this if use set i get the same URL as described above.

when i use set i get a script error

grateful of any help.

Let vKeyword = '=only({< KeyWord_id = {1} >} KeyWord)'

"Provider=QvRestConnector.exe;url=https://api.twitter.com/1.1/search/tweets.json?q%2$(vKeyword)&geocode%250.724489%%2C-3.783319%%2C100mi;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;queryHeaders=Authorization%2OAuth oauth_consumer_key%%2%%3DC0sePOBbQ8bYdC8r4Smg%%3,oauth_signature_method%%2%%3HMAC-SHA1%%3,oauth_timestamp%%2%%31484232435%%3,oauth_nonce%%2%%3651918257%%3,oauth_version%%2%%31.0%%3,oauth_token%%2%%33295659582-eFPWd4R0cRAUkZqgGBhUl3l1jAMdzPtQsA8Sg0A%%3,oauth_signature%%2%%30lkAd4jam2cqhjRs0Rcp%%%%2BYHY%%%%2FOA%%%%3D%%3%1Host%2api.twitter.com%1X-Target-URL%2https://api.twitter.com;PaginationType=None;XUserId=JUFfaGFMObYeVJFMNLMSDcEHIF;XPassword=cLMGYSUEQLY...";

2 Replies
ni_avoss
Creator
Creator

I got the same issue, any idea  what to do ?

ni_avoss
Creator
Creator

ok, found out: make sure to have no word wrap or no other special characters in your connect string. everything needs to be in one line