2 Replies Latest reply: Mar 29, 2017 7:01 AM by Ricardo Santos RSS

    Qliksense Dynamic call to rest connect

    Ricardo Santos

      hi,

       

      In qlikview I could make http call with the dynamic address, how to do the same in Qliksense?

       

      in qlikview:

      from [http://api.wunderground.com/api/My-key/history_$(vGetDate_char)/q/$(VCountryInstall)/$(VCityInstall).xml]

       

       

      best regards

      Ricardo

       

       

       

       

        • Re: Qliksense Dynamic call to rest connect
          S�lvia Ganh�o

          Try change that form of yours to this:

           

          CUSTOM CONNECT TO

          "Provider=QvRestConnector.exe;

          url=YOUR_URL;

          timeout=30;

          method=GET;

          autoDetectResponseType=true;

          keyGenerationStrategy=0;

          useWindowsAuthentication=false;

          useCertificate=No;

          certificateStoreLocation=CurrentUser;

          certificateStoreName=My;

          queryParameters=id%21;

          queryHeaders=Authorization%2Bearer $(vAccessToken2);

          PaginationType=None;";

           

           

          But please note that you have to go to C:\Users\YOUR_USERNAME\Documents\Qlik\Sense (in case it is desktop version), edit the file Settings.ini with this:

           

          [Settings 7]

          StandardReload=0


          Restart QlikSense Desktop.

           

          then you can use this:

           

          LET vURL = 'YOUR_URL';

           

          [YOUR_TABLE]:

          LOAD

            [YOURFIEDLS];

           

           

          SQL SELECT

            "__KEY_root",

            (SELECT

          YOUR FIELDS)

          WITH CONNECTION (

            URL "$(vURL)"

          );

           

           

          Sílvia