get last history changed of field by web request

Shani Levi_110rec

hello,

 

I need to get last history changed of field "Target Sprint" from automation with web request.

the web request work good, when I display this log {{webResponse.body.changelog.histories.items.field}}

I get this result: 

 

 [Target Sprint], [Feature End Date], [Target Sprint], [Feature End Date], [Target Sprint], [Feature End Date]

but when I try to get last update of "Target Sprint" with this:

{{webResponse.body.changelog.histories.reverse().items.filter(it => it.field == "Target Sprint").first.to}}

I get empty result.

how can I get last value in history of "Target Sprint" field?

 

Thanks Shani

Bill Sheboy

Hi @Shani Levi 

Short answer: you may use smart value, list filtering and created variables to get the information you are seeking; or, you could use a rule triggered on a change to the field and save the changes in a custom field...which could be reviewed later, as needed.

 

More information...

First, I do not believe there is a reverse() or a filter() function for smart value lists.

 

The REST API endpoints for the changelog use paging, and thus even if those above functions existed, you would not necessarily get a result unless the automation rule performed paging of the changelog results using multiple calls with Send Web Request.  https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-issueidorkey-changelog-get

For the remainder of my suggestions, I will assume there is a change to the Target Sprint field in the first page of results from the changelog lookup...which by default are returned with the most recent one first.

 

You could use list iteration and conditional filtering to extract the entries for Target Sprint changes, adding a delimiter, and saving the result in a created variable.  Then, split the variable on the delimiter and grab the first entry.

Here are some references to help you do that:

• List iteration: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/#Combined-function-examples
• Conditional list filtering: https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588
• Additional conditional functions to help: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-conditional-logic/
• Create Variable action: https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Create-variable
• Split() and other text functions to parse the result from the variable: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#split-String-separator-

 

Kind regards,
Bill