Passing values from SCSM to SCORCH can be a rewarding yet challenging endeavor. One of the challenges is to parse the XML data. In the method below I will show two “types” of XML that is escaped from the Service Request. One a manual input and the other a query.
Manual input data can be passed from SCSM to SCORCH by querying XML text or files using XPath activity. Simply select the published data of the “User Input” from the SCSM Object (Service Request in this example) and make sure the XPath Query contains the question asked on the Request Offering.
Well we get the data but it still contains the XML. Now you can copy it to a file and manipulate the data with find and replace, etc, or you can add another Query XML activity which will grab the display name value which is what you initially selected (Service Request Ticket in this example).
Now that the XML has been removed, the value you selected is available. This method can be used in any query scenario in SCSM. Instead of adding the second XML activity you could utilize PowerShell and script it, but I have found this method to work every time.
-End of Line-