Calendly + JIRA Integration (formatting date/time) - Need Help!

[Randy Elias]

We just migrated to Calendly API v2 and are having issues with formatting the date/time fields.

In particular, I’m using the start_time api field. There is no more “pretty” version of the start_time api field, so we need to format it in JIRA automation. 

I noticed, we get the date/time value in the start_time field as “2025-06-25T05:00:00.000000Z” (for example). However, in the JIRA documentation, JIRA is expecting the date/time field as “2020-08-18T02:40:37.0+0000” (for example). 

Because of this, the smart value format operations in JIRA automation do not recognize the date/time format therefore will not work. 

Has anyone found a solution to this issue?

Here's the JIRA Automation smart value I'm using:

{{webhookData.payload.scheduled_event.start_time.convertToTimeZone("EST5EDT").format("hh:mm a - EEEE, MMM dd, yyyy")}}

[Jorge Cammarota]

DEFINITIVE SOLUTION Jira Automation

Use: {{webhookData.payload.scheduled_event.start_time.substring(0,19)}}Z

This command cuts the timestamp down to the seconds and removes the .000000.

Final result:

Calendar input:

2025-06-25T05:00:00.000000Z

Adjusted output:

2025-06-25T05:00:00Z
Now Jira can interpret it.