Flow or subflow batch processing of records from table.

DevdattaK
Tera Contributor

Hello,

Is there any way to process the records from a table batch wise in a flow or a subflow?

In my case I have a flow which is internally calling a subflow in which I need to fetch the records from a table e.g. "sn_si_incident" and in one go I should fetch only 100 records perform some operations by iterating over each record and once done I should fetch next 100 records and so on.
How can this be achieved when I have a trigger set for the flow?

1 REPLY 1

Sumanth16
Kilo Patron

Hi @DevdattaK ,

My recommendation is go with the fix script (or) scheduled job for processing batch records.

 

Please refer below thread:

https://www.servicenow.com/community/developer-forum/bestpractice-of-inserting-huge-number-of-record...

 

 

Kindly mark my answer as Correct and Helpful based on the Impact.

 

Thanks & Regards,

Sumanth Meda