Chris_Powers Acclaimed Contributor.
Acclaimed Contributor.
404 views

Filter question (table or XML)

Got a question, hopefully this won't be too dissimilar to what others have done before....

I'm trying to take the output (from a HP WSDL) and stick it into a table using a filter so I can sort it.

I first tried a table filter, seemed like a good way to go but don't think it's possible with the output I'm working with.  Then moved to a XML Get Attribute filter and tried the table option, but I got a bunch of nothing, and not sure I can sort using that filter but might be able to sort afterwords.

Any suggestions?  

thanks in advance!
-Chris


Snipit of output below:
(for easy reading, I've broken the output up)

{document=<?xml version="1.0" encoding="utf-8" ?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><nas:list_taskResponse xmlns:nas="http://opsware.com/nas/90"><nas:Result><nas:Status>200</nas:Status><nas:ResultSet>

<nas:Row>
<nas:completeDate>2011-03-22 22:00:52.0</nas:completeDate>
<nas:scheduleTaskID>5228921</nas:scheduleTaskID>
</nas:Row>

repeat for other rows

or (if you prefer):
{document=<?xml version="1.0" encoding="utf-8" ?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><nas:list_taskResponse xmlns:nas="http://opsware.com/nas/90"><nas:Result><nas:Status>200</nas:Status><nas:ResultSet><nas:Row><nas:completeDate>2011-03-22 22:00:52.0</nas:completeDate><nas:scheduleTaskID>5228921</nas:scheduleTaskID></nas:Row>repeat for extra rows

Labels (1)
0 Likes
1 Reply
Michael Schratt Absent Member.
Absent Member.

Re: Filter question (table or XML)

Which entity do you want to sort on?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.