working with arrays in Jira automation

[Yahyaa Bham]

Hi, 

Im looking to update a Jira issue when a new joiners start date is changed in the HRIS. I have a webhook that goes into Jira whenever an employees record is changed. My approach is to:

1. filter if its actually a profile update
2. filter by updates to start date
3. take the new start date and use this to update the jira issue

my issue is that the response comes in as an array and Im not too sure how to extract the info. Example: 

{
"companyId": 123,
"employee": {
"id": "321",
"companyId": 123,
"firstName": "bob",
"surname": "bob",
"email": "bob",
"displayName": "bob bob",
"site": "London",
"siteId": 456
},
"changedBy": {
"id": "123",
"companyId": 456,
"firstName": "bella",
"surname": "bellllllla",
"email": "bella",
"displayName": "Bella",
"site": "London",
"siteId": 2123
},
"type": "employee.updated",
"data": {
"fieldUpdates": [
{
"path": "/work/activeEffectiveDate",
"originalValue": "2023-05-30",
"newValue": "2023-07-01"
},
{
"path": "/work/customColumns/column_1673975628811",
"originalValue": "255135210",
"newValue": "255135209"
}
]
},
"previous": null,
"creationDate": "2023-06-30T23:07:00.93048"
}

Im trying to filter by {{webhookData.fieldUpdates.path}} = /work/activeEffectiveDate
if true

take {{webhookData.newValue}}

I dont know how to arrange this in the ui. 

To add, the path /work/activeEffectiveDate may not always be the first object :) 

[Bill Sheboy]

Hi @Yahyaa Bham -- Welcome to the Atlassian Community!

Do you get a rule trigger for each update, or do you get several in a batch?

I believe there are at least two ways to solve this, based on your answer to above...

• Try smart value, list filtering to select the record(s) meeting your criteria, and then process them.  Please look here to learn more about that technique: https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588
• Use a series of conditions to find and test each condition, and if all pass the result would be a record you want to process

Kind regards,
Bill

[Yahyaa Bham]

I get a rule trigger for each batch of updates per user.

I will give list filtering a go, I haven't used these before so will need to wrap my head around it.

Ill also potentially combine with a series of conditions.

Thanks!