Retrieving data from external entity from Odata catalog taking time.

Hello All,   I am trying to retrieve the data from external entity in microflow and it is retrieving data in 1000 object chunks due to this it is taking  more time get 22k records. Do we have any solution to get rid for this.  
1 answers


If you have a lot of records to process through a microflow it is recommended to do this in batches. 
Create 2 variables, offset and limit. And iterate through the records per batch of for example 500 records.
View the following blog about this method here: