custom connect to with variable

samuel_brierley — Wed, 25 Nov 2020 16:16:04 GMT

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=cLMGYSUEQLYGXZdOPTcIWSIGEKaCGRRNPLMETSEGIC;";

Re: custom connect to with variable

ni_avoss — Wed, 11 Oct 2017 09:33:16 GMT

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

Re: custom connect to with variable

ni_avoss — Wed, 11 Oct 2017 11:12:48 GMT

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

topic custom connect to with variable in QlikView

custom connect to with variable

Re: custom connect to with variable

Re: custom connect to with variable