Yes, the closest built-in thing you can get here are the string functions in workflow. If you’re XML document is fairly simple (as in, appears flat as name/value pairs), then you can easily use SUBSTR etc functions and extract out your data.
However, if your document is fairly complex, deeply nested, with repeated node names, arbitrary # of /optional nodes etc – then the above style of data extraction could easily turn out to be a painful process. In those cases, I would suggest to go into a plug-in land. Well, you got to write Java code in this approach. It is fairly easy to create a Filter API Java plug-in that provided you with XML processing API (creating/parsing/data extraction etc), which you could use in Filter SetFields[FromFilterApi] action by passing in your xml content and an indicator (say XPATH string) for which specific node data you want to retrieve. Is there a built-in plug-in like this, you ask? I am not aware of any, but it is a nice little plug-in if one were to produce and share with the community. Another avenue- if your XML is originating on the front-end (by user submission, or, user edited, or, client side integration etc) – then maybe you could have the xml parsing done on the client side itself perhaps. Even there you’re better off doing it via JavaScript. Don’t know if that were an acceptable alternative for you. If I were to do something like this - depending on the simplicity/complexity of your XML structure – I will start off with built-in string functions workflow. If the doc is complex, or, have a variety of data retrieval requirements – I will prefer creating a Java FilterAPI plugin. HTH Appajee From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Friday, October 07, 2011 2:45 PM To: [email protected] Subject: Re: Parsing XML in a filter ** Anne, If you are saying that a character field in a Remedy form stores some data in an XML format, it is possible to substring the contents of the field and read what is between the the opening and closing tag of the value you are looking for using substring and then L and R trim it to get rid of any tabs or spaces before and after that value.. Joe From: Ramey, Anne<mailto:[email protected]> Sent: Friday, October 07, 2011 5:12 PM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Parsing XML in a filter ** Is there a good way to parse XML in a filter? I need to get certain data out of a field that is stored a character field in XML format… Anne Ramey E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
