It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Unable to convert Opsgenie ack time from unix timefield to datetime field

I am struggling on converting opsgenie alert ack time from unix timestamp to datetimestamp. as it differ for each alerts differently.

Unix timestamp ranges from 8 to 10 character but in opsgenie it not consistent. Can you please help!

I am working on fetching data from opsgenie to PowerBI.  

1 answer

1 accepted

0 votes
Answer accepted

Hi @Ajaykumar Panchal !


The reporting fields of an alert (ackTime, closeTime, etc.) are relative and is measured in milliseconds since the alert was created. This is meant to agree with the unix-milliseconds timestamp used for absolute timestamps elsewhere in the application.


So an ackTime of 10000 would convert to 10s after the alert was created.


Hope this helps!

Thanks for your reply!! can you please help lets say I want to convert acktime into datetime format? How can I achieve it.

Robert Atlassian Team Sep 15, 2020

@Ajaykumar Panchal You would want to add that ackTime duration to the createdAt value returned in the API.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Opsgenie

Incident Responders, Incident Commanders, Stakeholders! I want to hear from YOU!

Hello there friendly community! I'm currently working on a guide for folks who are new to Incident Management, or want to improve their current Incident Management process. The TL;DR  I'd...

175 views 5 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you