Need to fetch the history details (mainly below mentioned fields) from RTC and upload the same to Jira history fields.
Problem statement : Need to fetch the history details (mainly below mentioned fields) from RTC and upload the same to Jira history fields.
We are using below URL to fetch the history details.
Reportable Rest API : https://ServerName/ccm/rpt/repository/workitem?size=10&fields=workitem/workItem[id=22647]/(itemHistory//)
5 fields/attributes :
1. Modified Date
2. Modified By
3. Attribute Modified
4. New/Modified value
5. Old/previous value
For Modified Date, Modified By we can fetch using xpaths. Issue with fetching the other fields.
Issue :
1. How to identify which attribute or field was modified in the recent modification and what was the previous and updated value of it.
Comparing 2 itemHistory tags of payload wont work as the xpaths are not gonna work on it.
Ex. ItemHistory Node 2 – ItemHistory Node 1. (Base on Predecessor and State ID tag)
2. How can we identify the RTC attribute in the history payload for mapping the same to Jira fields.
Ex. “Planned For” field was updated, which is mapped against name tag. (Xpath : <workItem> -> <itemHistory> -> <target> -> <name>)
This we figured out ,searching with the field value in XML for the given workitem.