JSON date and time string to DateTime with smart values?

Sam Lander_96utza

I'm using Jira automation.

The incoming JSON on a webhook has "2021-11-23 23:45" in it.

I'd like to splat it into a customfield as a DateTime

So far, my attempts have yielded either a action failure or no data.

Best-guess I have is this, but that results in an empty field...

{{webhookData."Date and Time of Incident".toDateTime("yyyy-MM-dd HH:mm")}}

 

Nir Haimov

Hi @Sam Lander 

Try ".toDateTime.as("yyyy-MM-dd HH:mm")

Try first to print it to the automation log, see if you get the result you want, then try to set it to a field.

Note that in order to set it to a field the format must be exactly as your dateTime customfields look like, make sure if you need use "-" or "/"