BusinessObjects Board

Parsing XML returned from a web service?

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 :us: (BOB member since 2011-08-10)

Hi,
please share the structure of the webservice response.
and what do you exactly mean by " XML is returned"?

if the response is a nested structure then try to Un-Nest it and then load it in the table.


Jay_mKumar :india: (BOB member since 2016-03-24)