nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Convert date from automation response to date in Assets

Svante Gustafsson Björkegren

Hey community,

I have an automation that gets all my automations via REST. In the response from the REST API call the date is formatted like this:
"created": 1727255448.771000000

My automation is creating Asset objects for each automation and I would like to have the attribute "Rule created" in my object type as a DateTime attribute.

I have tried to convert the value provided in the rest response to a format that goes into an Assets DateTime attribute but so far no luck.

Any tips or tricks how I can format my smart value in my automation to be accepted as a DateTime attribute in Assets?

Cheers,
// Svante

Accepted answers

Bill Sheboy

Hi @Svante Gustafsson Björkegren

The value is the number of seconds since the start of Unix time: the start of day on 1 January 1970.

To convert that for use as a date / time, the number could be multiplied by 1000 to convert to milliseconds and added to 1 Jan 1970. For example:

action: create variable
- name: varStartOfTime
- smart value: {{now.withYear(1970).withDayOfYear(1).toDateTimeAtStartOfDay}}
action: create variable
- name: varMyMillis
- smart value: {{#=}}ROUND(1727255448.771000000 * 1000, 0){{/}}
get the value for some action...
- {{varStartOfTime.toDate.plusMillis(varMyMillis.asNumber)}}

When I tested your amount, I got: 2024-09-25T09:10:48.7+0000

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Svante Gustafsson Björkegren

The value is the number of seconds since the start of Unix time: the start of day on 1 January 1970.

To convert that for use as a date / time, the number could be multiplied by 1000 to convert to milliseconds and added to 1 Jan 1970. For example:

action: create variable
- name: varStartOfTime
- smart value: {{now.withYear(1970).withDayOfYear(1).toDateTimeAtStartOfDay}}
action: create variable
- name: varMyMillis
- smart value: {{#=}}ROUND(1727255448.771000000 * 1000, 0){{/}}
get the value for some action...
- {{varStartOfTime.toDate.plusMillis(varMyMillis.asNumber)}}

When I tested your amount, I got: 2024-09-25T09:10:48.7+0000

Kind regards,
Bill

Svante Gustafsson Björkegren

Hey Bill,

Thnx for your solution, that worked perfect! I have a followup question on these DateTime values.

When I have converted the Unix time value from the REST response I would like to compare that DateTime with the DateTime stored in my Assets object. I have tried a number of different approaches but I can't get it right. Maybe you can identify what I am doing wrong here. I have attached two screenshots, one with the actions I have come up with and one from the audit log.

I think it is tricky to get the formats right.

Looking forward to hear back from you.

Cheers,
// Svante

Bill Sheboy

Hi @Svante Gustafsson Björkegren

I am glad to learn that helped!

Regarding the date / time comparisons, you are formatting the values with asLongDateTime and that converts them to text...preventing the function isAfter() from working: it expects a date or date / time type.

Please try removing the formatting to leave the values as date / time types for the comparison.

Svante Gustafsson Björkegren

Hey @Bill Sheboy

I have removed the formattings as you suggested. Unfortunately, this didn't do the trick.

I have created a test automation for this where I convert a Unix timestamp to a DateTime, as you described. And then I lookup my Asset object and get the DateTime attribute.

When I try to compare these I only get empty strings as a result. Looking at the log it seems that they are of different formats. I am not sure if this is just a textual issue or if it is something else that makes them incompatible.

Do you have any idea why these two Dates cannot be compared?

Cheers,
// Svante

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

automation

jira-service-management-cloud

jira-service-management

assets