Tuple lookup date is null

[heppener_anker]

Hi,

I’m using the Tuple Lookup Extension for POST’ing a claim where I look up a DateOfIncident field (json) to check if it’s not in the future. These are the parameters in the Tuple Lookup:

This is the return value:

Where I use this Json as input: “DateOfIncident”: “2024-08-04”

And this is the error that I get in Postman:

Where I think it is due to the internal formatting of the lookup value to a Date type.

If this is the case, is there a way to format the date string to a format the Date type can understand?

Thanks in advance.

[gweijman]

Hi!

In the past I used the Tuple Extension Lookup in a similar way to get a date like this “publishDate”: “2021-08-14T10:03:59” from a JSON and convert it to a DateTime value (see screenshots below). So it could be that the internal formatting is not the problem.

As a result I am interested to learn more about the configuration of the ‘deserializeobjectv2’ step that is used as input for the tuplelist. Thanks in advance!

[heppener_anker]

Hi Geertjan,

This is the setup for the deserializeobjectv2:

Where trigger.json is a textarea where we input the json with escaped quotes like this:

This way we can use it later in the import engine.

This has been working perfectly, including the DateOfIncident, but with the lookup step in between it doesn’t work.

It could also be the format of the datetime string we provide?

[heppener_anker]

Formatting the date like this:

@gweijman

2021-08-14T10:03:59

Solved it for me.