topic Re: Attempting to pull data, SOAP WSDL which returns one record but mapping processes 0 records in Talend Studio

Attempting to pull data, SOAP WSDL which returns one record but mapping processes 0 records

Anonymous — Mon, 05 Nov 2018 16:34:12 GMT

I am pulling WSDL from an endpoint (report action with specific id). The data is returned in a single record in the soap body.
But as expected is multiple records within. I am trying to pull those records out and place them into a CSV to put into an s3 bucket.
I've tried tSOAP-->tXMLMap-->tFileOutputXML-->tMap-->FileOutputDelimited 1 row is retrieved in tSOAP and then 0 records are processed after that. We are able to save the file locally with tSOAP --> tFileOutputRaw and on that file I've tried processing it with tFileInputXML but I get an error that the XPath query lost.

I am new to Talend and would appreciate any help and suggestions on the best way to get this working.

Thanks,

Re: Attempting to pull data, SOAP WSDL which returns one record but mapping processes 0 records

Anonymous — Mon, 05 Nov 2018 16:44:17 GMT

The correct job design here is:

tESBConsumer or tSOAP--row-->tXMLMap--row-->tFileOutputDelimited

in the tXMLMap, you'll need to correctly set the loop element(s) and then simply drag and drop elements you want to write to the flat file. This can be tricky, and sometimes you may need to stack the tXMLMaps together to process multiple conflicting loop elements.

Re: Attempting to pull data, SOAP WSDL which returns one record but mapping processes 0 records

Anonymous — Mon, 05 Nov 2018 20:10:41 GMT

Thanks for the response. It looks like I'm possibly close. I've gone back to the tSOAP--row-->tXMLMap--row-->tFileOutputDelimited as you suggested.
In the tXMLMap I've set it up as in the attached image with additional columns below (I'm essentially grabbing all of the data in all of the tags).
Everything is sync'd through to the tFileOutputDelimited and in there the other image shows the schema mapping. The only output I get is the headings with no data.
I'm thinking that I need to do some finagling in the tXMLMap but I am not sure what. It almost seems to me that my schema should be defined within the Soap-root (loop) in the tXMLMap but I'm not sure how that is accomplished.

2018-11-05_14-59-32.png
2018-11-05_15-05-00.png