Cycle insert - Second Insert waiting for response from first Insert
hello,
I'm not sure how to solve the following situation in Talend.
I insert a category via Webservice, getting the new ID for this category as response. Then I insert the next category with the new ID received as parent_ID.
How can I make sure that I received the previous inserted new ID bevor inserting the next category.
"I need some information at the start of job from the end of the job"
thank you!
Robert
Break your job into two pieces connected with onSubJobOK. 1st piece will call the web service and save the response in a context var. A tJavaRow after your tWebService is probably the easy way to do this. 2nd piece will check that context var to assign the ID and insert.
I think my explanation was not clear enough.
I'm getting the categories from a local table writting them to a remote table with a webservice, receiving an "remote" ID for the category
After each insert I do an update to the local category table inserting the remote_ID.
The remote_ID is the parent_ID on the remote table for the following categories.
I can not see how to solve that with splitting the job.
Thank you very much!
regards,
robert