Issue with timestamp 2020-01-01T00:00:00.000Z

[SilviyaK]

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!

[Qlik_Eric_Thomas]

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"

[SilviyaK]

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!