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

SilviyaK — Tue, 06 Dec 2022 14:58:52 GMT

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!

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

Qlik_Eric_Thomas — Tue, 06 Dec 2022 16:34:50 GMT

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"

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

SilviyaK — Wed, 07 Dec 2022 12:30:03 GMT

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!

topic Issue with timestamp 2020-01-01T00:00:00.000Z in App Development

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

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

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