Stagil Tables Changelog in Automation

[Patrick Schneider]

Hi,

i'm searching to have a way to access the Table History via Automation.
Is there any way to achieve this?

I tried {{#changelog.customfield_12345}}{{FromString}} - {{/changelog.customfield_12345}}{{toString}} but after Table change it fills nothing.
A Scriptrunner Solution via REST is working, but i cannot hand the Variables back into automation.

Any Hints how to achieve this?

Best,
Patrick

[Tuncay Senturk _Snapbytes_ · Accepted solution]

Hi @Patrick Schneider 

I think Stagil tables don't write cell diffs into Jira's native issue changelog. So you'll need to use their REST API and use the response inside Automation.

Checking their documentation, you can use the below REST service 

GET /rest/stj/1.0/api/table/history/customField/{customFieldId}/issue/{issueKey}

• Action: "send web request"
  URL: build with smart values  {{issue.key}}
• then read from response 
  {{webResponse.status}}
  {{webResponse.body}}
  {{webResponse.body.somevalue}} (depending on stagil's json structure)

[Patrick Schneider]

Hi @Tuncay Senturk _Snapbytes_ ,

thanks. Thats currently the way we have already in Script Runner and i wanted to "replace" this. I will try with the webhook and check how to proceed. Thank you.

[Tuncay Senturk _Snapbytes_]

No problem! Happy to help!

[Hari Krishna]

Hi @Patrick Schneider ,

This is not possible using Jira Automation.

Because
Stagil Tables are table-type custom fields, and Jira Automation does not expose their changelog data. Because of this limitation, smart values like
{{changelog.customfield_xxxxx}} will always return empty after a table update.