<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Hey Nawin,… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92988#M42657</link>
    <description>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.</description>
    <pubDate>Tue, 09 Jan 2018 11:24:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-01-09T11:24:00Z</dc:date>
    <item>
      <title>Read Json Text and loop through records</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92987#M42656</link>
      <description>Hello team,

I have converted a&amp;nbsp;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</description>
      <pubDate>Tue, 09 Jan 2018 10:22:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92987#M42656</guid>
      <dc:creator>NawinAnkathi</dc:creator>
      <dc:date>2018-01-09T10:22:00Z</dc:date>
    </item>
    <item>
      <title>Hey Nawin,…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92988#M42657</link>
      <description>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.</description>
      <pubDate>Tue, 09 Jan 2018 11:24:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92988#M42657</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-01-09T11:24:00Z</dc:date>
    </item>
    <item>
      <title>Using collections is covered…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92989#M42658</link>
      <description>Using collections is covered in chapter 3 of the Foundation Training course.&amp;nbsp; 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.</description>
      <pubDate>Tue, 09 Jan 2018 16:00:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92989#M42658</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-01-09T16:00:00Z</dc:date>
    </item>
    <item>
      <title>Hey Guys,…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92990#M42659</link>
      <description>Hey Guys,
I believe nawin was meaning to ask how to access the data in the collection after using the JSON to Collection action. &amp;nbsp;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&amp;nbsp;comments are of no value to the community.</description>
      <pubDate>Sun, 15 Apr 2018 04:39:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92990#M42659</guid>
      <dc:creator>DukeAmes</dc:creator>
      <dc:date>2018-04-15T04:39:00Z</dc:date>
    </item>
    <item>
      <title>I think what you can do is…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92991#M42660</link>
      <description>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 =&amp;nbsp; 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.
&amp;nbsp;
&amp;nbsp;</description>
      <pubDate>Mon, 16 Apr 2018 11:43:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Read-Json-Text-and-loop-through-records/m-p/92991#M42660</guid>
      <dc:creator>JongOclarit</dc:creator>
      <dc:date>2018-04-16T11:43:00Z</dc:date>
    </item>
  </channel>
</rss>

