Web Service Client - All data on one row
Posted: Tue Oct 28, 2014 11:44 am
I am creating a parallel job that calls a web service. The service developer provided me the WSDL which I successfully imported into DataStage using the Web Service Meta Data Importer. I then created my job, using the Web Services Client stage as my input. I was able to select the web service operation and load the Input and Output Arguments and message information.
When I run the job, instead of gettng the expected 100 rows, I get one row. All values for each column are concatenated together.
For example:
Expected:
Any ideas of how I can correctly parse the data? It is coming in in XML format which appears to me to be formatted correctly. The columns tab correctly displays the XML mapping.
When I run the job, instead of gettng the expected 100 rows, I get one row. All values for each column are concatenated together.
For example:
Code: Select all
Customer Number MonthYear
100200300... 201410201410201410201410...
Code: Select all
Customer Number MonthYear
100 201410
200 201410
300 201410