Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do I extract fields from Table=IssuesAsRawXml?
I can access the URL but I don't know how to load the fields from the XML format.
When I add (xml) after the link I get the columns "expand, id, self, key, fields".
Hello,
@Hallaien MGHwrote:
Hi,
How do I extract fields from Table=IssuesAsRawXml?
I can access the URL but I don't know how to load the fields from the XML format.
When I add (xml) after the link I get the columns "expand, id, self, key, fields".
Extracting data from Jira's IssuesAsRawXml table requires parsing the XML response. Use scripting languages like Python with libraries like xml.etree.ElementTree or Qlik's built-in XML functions to extract desired fields. Consider API limitations, data volume, and error handling. If XML structure is complex, explore third-party tools or libraries for efficient data extraction and transformation.
I have currently tried using xmlSimple, but depending on project I pull there are different amount of tables (xml meta data) and it is Super Slow. For the QVDs where it was implemented the loading time was 3 times more.. I will try Rest Api to get the fields I need.