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.
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.
