Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
0683p000009MEKq.png
Labels (2)
2 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

thank you for your answer!

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
0683p000009MEVp.png