Flow designer

[surya123]

Hi All,

I am doing an integration where I am receiving payload, parsing that to put it in a custom table. I am trying to check if my table have certain id which isnt present in payload and then I have to mark it.

In the flow designer , if I loop through each item in  table and then do foreach on payload to go through all items to see if that id is present else mark the record in my table. But assuming that table will have around 300k data, this will cause performance issue I assume.

How can I store the Id from the payload in a variable when using flow designer as I am anyways doing foreach to insert into table. Can I somehow store those id and use it for my purpose , if so, how Or if there are some better ways to do it

[JenniferRah]

I'm not sure I understand your process. Are you looping through the items in the payload? If so, why wouldn't you just look up the record to see if it exists first? Then if it doesn't exist, create it. If it does exist, mark it. Then go to the next item.

If I'm misunderstanding what you are trying to do, please let me know.

[ashishdevsingh]

Well I don't get your requirement completely, but I would prefer to use custom Action where I will create one array to store the ID received from payload. 2nd array would be dynamic which store the approx. 10k ID (i believe 40k is supported in SN) from LIST record. Then I will check the difference and will store as a payload/Array as a return. 

We can pull the data from the List using "ChooseWindow" in GlideRecord.