Converting date/time from Datastore

david

When using the WA "Retrieve all items from a JSON array", a JSON array I retrieved from the Datastore - I get an error when trying to map a date/time field.

The data was saved to the Datastore as date/time, so it would make sense that I can retrieve and map it into a date/time field.

Here is a sample and reference to the error:

System Error: Retrieve all items from a JSON array caused an error: Failed to convert 'HS last meeting date' key value: to date-time. Job 7708b356-6cd8-4733-9787-c70e83b8cd50

david

After spending more time on this - this error is happening because I have some rows with an empty field instead of the date.

So I first need to extract that field into a text, then verify if it is not empty before converting it to a date/time format using Copy Content. I want the date/time type to ensure the dates are handled properly down the line.

My suggestion here is that empty field should be treated as such when retrieving date/time from a source.

Nick

Agreed. Raising the ticket and will work on a fix for this.

https://wrk-technologies.atlassian.net/browse/SUP-1685