My requirement is I have 3000 records in my DB for each ‘custID’ I wanted to call webcatity and the response I parse and update in the table by using lookup city there is also a case where I am calling one more tenacity as it depends on the response of first tenacity?

I am facing issues of data mismatch and also it difficult because it takes too much time ??? what could be the optimum solution ???

WebActity1->Lookup (update the table) -> webActity2-> lookup Actity (update tables)

And all of these I am performing under forEachLoop Actity?? first I use lookup where I select cursive from temp_cust_tbl and then I iterate 2000 times to foEach and also pass as restapiurland id I am appending ??

htts://webactity?custid=1234

Does anyone have any idea how to deal with this ??? I also wanted to take the URL from the pipeline parameter as the security checker identifies it as Coverity and needs to remove the hardcode URL from JSON.