I have a SOAP Web Service API call via the Download tool issue that I have not seen addressed.
I correctly POST to the service and expect a return of XML data which I want to handle via the XML Parse tool. My issue is that SOAP is returning the XML data in an encoded embedded fragment. As I understand it SOAP must return XML this way to prevent an error from making the SOAP envelope/body invalid.
My issue is that the Download Tool's DownloadData field does not decode this embedded data. W hen sent to the XML Parse tool it errors due to it finding "<" and ">" instead of "<" and ">". I have tried using a Find Replace to convert in between with no luck.
I have validated the Header, Payload string and Result with SOAPui tool. That tool automatically decodes and handles the <return> tag as a complete XML document.
Is there a way to handle this in Alteryx?
Thanks
Rich
Solved! Go to Solution.
I finally got this working and I wanted to share what I ended up doing to handle the CDATA.
First I Concatenated the rows using the Summarize tool. Then to extract the <return> data used Formula: REGEX_Replace([Concat_DownloadData], ".*<return>(.*?)</return>", '$1') Then finally I used Find Replace to convert the ascii chars to "<" and ">".
Thanks to all of the various past responses I was able to piece together what I needed.
-Rich