Collection Management: BP writes only one row from collection

ernest_mg

New Member
Hi Guys,
Can you help me extract the data if it is presented in a collection like below?

{"items":
[
{"id":"ndv9l55dx8li","itemType":"file","name":"6677648_0000064970.TIFF"},{"id":"5elbr72guj5o","itemType":"file","name":"6677648_0000064966.TIFF"},{"id":"adc0b30fkom4","itemType":"file","name":"6677648_0000064961.TIFF"},{"id":"obpnrxzuu6sh","itemType":"file","name":"6677648_0000064958.TIFF"},{"id":"1abvvyz69q3hs","itemType":"file","name":"6677648_0000064969.TIFF"},{"id":"scly513cne1y","itemType":"file","name":"6677648_0000064965.TIFF"},{"id":"1dp1e3yz1bw7","itemType":"file","name":"6677648_0000064959.TIFF"},{"id":"16azllw2rww8b","itemType":"file","name":"6677648_0000064962.TIFF"},{"id":"1famkiv48g8y8","itemType":"file","name":"6677648_0000064964.TIFF"},{"id":"ee8ao63xdvvl","itemType":"file","name":"6677648_0000064968.TIFF"},{"id":"jcyz821w41c1","itemType":"file","name":"6677648_0000064963.TIFF"},{"id":"xbcmox1bdjie","itemType":"file","name":"6677648_0000064960.TIFF"},{"id":"11c8x204t6qrv","itemType":"file","name":"6677648_0000064967.TIFF"},{"id":"fun7b4i4dp8","itemType":"file","name":"6677648_0000064971.TIFF"},{"id":"fc2ouyyeau2k","itemType":"file","name":"6677648_0000064956.TIFF"},{"id":"1b9qa5s0qn1or","itemType":"file","name":"6677648_0000064957.TIFF"}
]
}

also included a collection with this data
I will be grateful for any help
M
 

Attachments

  • JSON-Collection.JPG
    JSON-Collection.JPG
    31.9 KB · Views: 21

sahil_raina_91

Active Member
Hi Guys,
Can you help me extract the data if it is presented in a collection like below?

{"items":
[
{"id":"ndv9l55dx8li","itemType":"file","name":"6677648_0000064970.TIFF"},{"id":"5elbr72guj5o","itemType":"file","name":"6677648_0000064966.TIFF"},{"id":"adc0b30fkom4","itemType":"file","name":"6677648_0000064961.TIFF"},{"id":"obpnrxzuu6sh","itemType":"file","name":"6677648_0000064958.TIFF"},{"id":"1abvvyz69q3hs","itemType":"file","name":"6677648_0000064969.TIFF"},{"id":"scly513cne1y","itemType":"file","name":"6677648_0000064965.TIFF"},{"id":"1dp1e3yz1bw7","itemType":"file","name":"6677648_0000064959.TIFF"},{"id":"16azllw2rww8b","itemType":"file","name":"6677648_0000064962.TIFF"},{"id":"1famkiv48g8y8","itemType":"file","name":"6677648_0000064964.TIFF"},{"id":"ee8ao63xdvvl","itemType":"file","name":"6677648_0000064968.TIFF"},{"id":"jcyz821w41c1","itemType":"file","name":"6677648_0000064963.TIFF"},{"id":"xbcmox1bdjie","itemType":"file","name":"6677648_0000064960.TIFF"},{"id":"11c8x204t6qrv","itemType":"file","name":"6677648_0000064967.TIFF"},{"id":"fun7b4i4dp8","itemType":"file","name":"6677648_0000064971.TIFF"},{"id":"fc2ouyyeau2k","itemType":"file","name":"6677648_0000064956.TIFF"},{"id":"1b9qa5s0qn1or","itemType":"file","name":"6677648_0000064957.TIFF"}
]
}

also included a collection with this data
I will be grateful for any help
M

1. Inside calculation stage : [Collection.items] and store in a Collection name ItemCollection
2. Looping ItemCollection you can fetch each row using [ItemCollection.JSON:Array]
(You can directly access an element using [ItemCollection.JSON:Array.id])

OR you can use pre built VBO : https://digitalexchange.blueprism.com/dx/entry/7888/solution/json-manipulation-c
 
Top