SOAP batch (iteration/loop) call

Anonymous — Mon, 20 Feb 2017 07:17:18 GMT

Hello, guys. I'm a new to Talend (previously I worked in SSIS) and I'm trying to create job for iteration (loop) call SOAP webservice (force.com for FAIRSAIL) with next algorithm

1. First I need to call query() method that returns XML with specified batch size (500 rows), <done> false <done> and number of batch "01g2400002yVgFeAAK-500"
2. Store batch number and <done> status in context variable
3. Create loop while <done> = "true"
4. Call new SOAP method queryMore() with passing context variable "batch_number" into SOAP message
5. And store results into OracleOutput

Maybe I'll need to catch a sessionid in step =0 and pass it to all SOAP components via context variable.

Please, help me how to implement this logic in Talend. I would be so kind for any suggestions.
Thanks for responce.

Re: SOAP batch (iteration/loop) call

Anonymous — Tue, 21 Feb 2017 09:35:06 GMT

Which steps have you done? Are you able to call the webservice using tSOAP component? To me, the job design looks like:
tSoap-main-tExtractXMLFiled--main--tjavaRow-main-tFlowToIterate-iterate--tSOAP--main--tOracleOutput

tExtractXMLFiled:extract data which you want from the return XML string.
tjavaRow: store the result to context variables if needed.
tFlowToIterate: iterate each row data extracted from the return xml string.

topic SOAP batch (iteration/loop) call in Talend Studio

SOAP batch (iteration/loop) call

Re: SOAP batch (iteration/loop) call