Use for each boucle with Json

Help Studio
, ,
1

Hi ,

hello ,

How do I configure a for loop ( see image ) so that the loop changes at each id.

In this case the data for each id ( nni , first name , last name … etc ) used in the process of the robot ( in the form of variable ) once the processsus finished we pass to the next id and so on .

Thanks for your help

exemple

2

Hi @frederic-f.bonnet

If possible provide the complete json data and i will try to provide the output as per your data.

->Pass the string input into the Deseralize Json avtivity.
->You need to use the for each and pass the output of the Deseralize activit as the input for the for each .

Please check the below thread for better understanding and you need to change the key names as per your requirement.

Regards

3

Deserialize The JSON with:
Deserialize JArray Activity - out: myJArray

For each Activity - item in myJArray.Values(Of JObject)

  • nested for each Activity - prp in item.Properties() | TypeArgument: JProperty
    • For Demo: log message: prp.Name
    • For Demo: log message: prp.Value.toString()
4

Hi @frederic-f.bonnet

Workflow:

image
image886×736 28.6 KB

xaml:
Sequence2.xaml (8.7 KB)

Output:
image

Regards

5

hi ,thanks for your help ,

vrdabberu , your file sequence2 seems corrupted , i cannot open

this an example of json

Capture
Capture544×806 13.9 KB

6

Hi @frederic-f.bonnet

Check the below workflow file:
BlankProcess25.zip (697.5 KB)

Regards

7

Looping over items and properties

grafik
grafik655×795 49.2 KB

Sample logs
grafik

DataType specific extraction Demo:
grafik

Also have a look at this:
grafik

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.