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:
- filter if its actually a profile update
- filter by updates to start date
- 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 
