Hello team,
I have converted a Json string to collection using Json VBO. I am unable to loop through the records present inside the collection, I just see row1 of 1.
Can you please give me the sample code to loop through the collection.
Thanks
Hey Nawin,
there is no code required for looping through a collection..use loop stage and specify the target collection. if your collection is having only one record it will loop only once.
Using collections is covered in chapter 3 of the Foundation Training course. If you anyone out there is using the Blue Prism product without completing all the mandatory training that is part of the Accreditation training path - I would put your entire project at a red RAG status.
Hey Guys,
I believe nawin was meaning to ask how to access the data in the collection after using the JSON to Collection action. I'm having the same issue:
Row 1 of 1
Row 1 of 1
Row 1 of 1
...
Please share your knowledge if you understand the issue and know the solution.
Denis - Your condescending comments are of no value to the community.
I think what you can do is use Append rows to collection.
Example below:
Row 1 of 1
Row 1 of 1
assuming that you have the data inside result collection. and inside Row 1 you have a fix column name ""Data""
So what you can do is use append rows to a collection.
Main Collection = would be a collection to where you would like to put the data.
Collection to Append would be like this [result.data] it will put the data to a new collection as long as the column name is fix.
