I’ve set up a Web Services data store, and created a data flow that calls a SOAP web service and XML is returned. However, I’m not sure how to deal with the XML and get it into a table with columns/rows.
I can write it to a table, but it just puts all the XML in one column/row. I’ve used the XML pipeline transform before to read XML files, but DS won’t let me connect a query to an XML pipeline as input.
Do I need to write the WS data returned to an XML file, then read that XML file in using another data flow?
Or is there a way to map it in-flight within the same/another data flow using _____ transform?
thesnow (BOB member since 2011-08-10)