Best approach to randomly process JSON items from multiple arrays from queue

Help Automation Cloud
, , ,
1

I have a queue item where SpecificContentstrong text contains multiple fields, and each field stores a JSON array of objects. Each object contains information such as hierarchy values and optional table or text data.

During automation execution, I need to process all these JSON items, but the execution order should be random rather than sequential. The workflow should read the JSON data, combine items from different arrays, and then process them one by one in a randomized orderWhat is the recommended pattern in UiPath for handling multiple JSON arrays from queue SpecificContent?

2

@Supriya_Borah Can u follow below steps:

  1. Read each SpecificContent field as string

2.Deserialize each JSON array into a JArray / List(Of JObject)

  1. Add all items into one common list

4.Shuffle that list

5.Process items one by one

3

@Dhruba_Jyoti_Kalita can you help me to understand common list ?

4

Please check below steps:

  1. use Deserialize JSON Array
  2. store each result in JArray
  3. loop through each array and add items into List(Of JObject)
    4.randomize using OrderBy(Function(x) Guid.NewGuid()) or a small shuffle logic
    5.then process the final randomized list