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

[Ajaykumar Panchal]

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.  

[Robert · Accepted solution]

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!

[Ajaykumar Panchal]

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

[Robert]

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

[Ajaykumar Panchal]

thanks Robert