Using a query as a condition for an update query

[famousmag]

forgive me buddy but still can't understand exactly what you want to archieve...
All I can do is just pointing things that looks wrong to me

Here is one from your last post:
You search if provider_outcode exists IN {{final_oc_array}}
I CAN'T find any final_oc_array in your api steps, maybe you want final_prov_array

Since you referred to my post, i would recommend to read the steps explaining that I have given:

Filter a query on a JSON field

I have worked on my table “products” that contains a json column (prd_Tags). I pull all the records of my products table (NO OUTPUT) Create an arrayList and set the value to my step-1 query [image] Clear the arrayList (I just wanted to copy the schema, we don’t need the data) I add a repeat with expresion the step-1 query (loop throught the table’s products) Set Value tags_Array and gave it the current repeat’s prd_Tags column value I create a switch and set it to false (this is to check if …

But for your use case, it would be nice (at least for me) to know what exactly you have and what you want to achieve...
I see you create a few arrays, have a repeat step that you add ALL in provider_array in every repeat loop... Is that correct?

Can you just give us:

• the 2 APIs data schema
• the desired output that final_prov_array should have and on which condition