2 Replies Latest reply: Sep 7, 2017 6:00 AM by Max Ålander RSS

    REST connector with automatic date update

    Max Ålander

      Hi,

       

      I'm using the REST connector in Qlik Sense to import data from Mixpanel to Qlik. This connection works fine and gives me the data I want but I have to specify a date range for the API to work properly. This means that I have to manually update the date range to include new data. I want this connection to always fetch the latest data.

       

      In my REST connector I have several parameters, which includes "from_date" and "to_date" (as seen in the picture below).

       

      Screen Shot 2017-08-16 at 16.27.01.png

       

      I'm wondering if it's possible to automatically have the current date in the "to_date" parameter value?

       

      If not, are there other ways do achieve this?

       

      Thanks!

      Max