topic Re: REST connector with automatic date update in Connectivity & Data Prep

REST connector with automatic date update

Anonymous — Wed, 16 Aug 2017 14:40:12 GMT

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).

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

Re: REST connector with automatic date update

justinvchiang — Wed, 06 Sep 2017 16:07:00 GMT

Hey Max,

One solve for this is to use a variable for your to_date.

1. In your load script, set a variable

LET vToday = date(Today(),'YYYY-MM-DD');

2. Leave the connection query parameters as you have them and then change the query parameter in your load script by using the WITH CONNECTION function which will override what you have stored in your connection:

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION (

QUERY "to_date" "$(vToday)")

;

Re: REST connector with automatic date update

Anonymous — Thu, 07 Sep 2017 10:00:19 GMT

Hi Justin,

this is a great way of solving it!

I have just started to use, and learn how to handle, the WITH CONNECTION in other apps and forgot that I could use the same function here.

Thank you!

Re: REST connector with automatic date update

marjan_it — Thu, 23 Apr 2020 09:00:27 GMT

Hi.can you share a qww example file?

I have an api that give date in a range, but I want give it the date yesterday and the date two last day with the function date(now()-1) and date(now()-2).

I tried your answer but It does not work.

Re: REST connector with automatic date update

justinvchiang — Wed, 10 Jun 2020 21:21:03 GMT

Hi Marjan_it, did you figure it out?

If you haven't, I don't have any files to share but if your API is able to accept a range as two parameters you would have to list both in the WITH CONNECTION and ensure the date(now()-1) and date(now()-2) values are both in the expected format of the API. Without any formatting, you'll get MM/DD/YYYY which would fail if the API expected YYYY/MM/DD.