Populate an "Employee" asset with Jira account ID

[Hofer, Johan]

Dear Community,

I created an Object type Employee in Assests (was Insight some days ago :-))

In this Object type, I want to add the Jira account ID

Before I was making an export of all Jira users with there IDs, Add these IDs in a list of users in csv (corresponding of course) and re-import them in Insight (Assets).

As it's manual I wanted to automatize this task when we receive an "Onboarding employee request".

When request created, I create the object of the employee with automation and all is fine, without JiraID as some task need to be done on operation team side to have the new Jira account of this user.

Then I run an automation once a day to update all Employee that don't have "JiraID" with a boolean value, then have another automation who is triggered when there's an object update (with condition of the previously automation value change) to update the Jira ID.

Basically I want to compare {{Object.Email}} (attribute of Employee Object type) to Jira "User".EmailAdress to return "User".Key (or accountID)

Here I used reporter but as there's no Issue behing this automation but Object... I'm searching the right smart value for Jira users... (I made other tests but this one was the most easy to read :-))

{{if(equals(object.email, reporter.emailAddress)),reporter.key}}

Of course I used logs to see what kind of value I get (for Object.email in example)

Thank you in advance for your help and support