Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I was wondering if somebody encountered an issue with the timestamps that Qlik supports?
I am currently trying to load data from a REST connection and I am trying to limit the data that I want to load by date, otherwise as there are too many rows, I am experiencing other issues.
I am using WITH CONNECTION and looks as follows:
WITH CONNECTION (
URL "https://api-sample.url.com/sample/name",
QUERY "filter" "Name eq 'Company'",
QUERY "filter" "start gt '2022-01-01T00:00:00.000Z'",
HTTPHEADER "Authorization" "Bearer $(vToken)"
);
Everything works perfectly except the part where I want the loaded data to be greater than a specific time:
QUERY "filter" "start gt '2022-01-01T00:00:00.000Z'",
It seems that Qlik doesn't recognize this timestamp. I tried to change it in the 'Main' section of my script as below:
SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff] TT';
But it still doesn't understand that I want the date to be greater than the specified one above.
Does anyone have any ideas?
Thanks!
I have had success in the past with this timestamp format used directly in a header: yyyy-MM-dd HH:mm:ssZ, eg. "2014-09-28 16:25:09Z"
Thanks for the response! 🙂
Do you mean in a header like the ones above, inside the WITH CONNECTION? Can you please give me an example as I am not sure where exactly to add it?
Thanks!