Hi everyone,
I am trying to run the following process:
1-Getting JSON text from a website
2-Converting JSON text to collection (of 2 rows)
3-Writing the collection to Excel
The first two steps work perfectly. The problem occurs during step 3: Blue Prism writes only the first row. As you can see in the attached picture ("Collection properties - current values"), BP creates one row for each row (I do not know why). As a result, only the first row (image: "first row") is written in the excel file (picture: "Output on Excel").
This is caused by the "extra" intermediary row that is created by BP. As a matter of fact, I have tried to create manually a random collection Coll1 (image: "collection manually created") and BP did correctly write the entire collection. As you may have noticed, the collection I have manually created shows only one row that contains both "real" rows (image: "Collection manually created - current values). And this allows BP to copy all the table, as the "real" rows are directly listed one under the other.
Any idea how one can structure the first collection the same way as in the second collection so that BP writes the entire collection?
I have also tried the "Append rows to collection", "Add to queue" functions, etc. but no luck. At the end, the output remains the same which is only one row that is considered/treated.
Below is the original JSON code:
[{"employee":"first.last@google.com","car":"Peugeot 208 GT line","color":"Ruby red"},
{"employee":"another.first.another.last@google.com","car":"Mini Cooper","color":"Midnight black"}]
The goal is to be able to write this code directly into an excel spreadsheet.
Thank you very much for your support. Your help would be highly appreciated.
Best regards
I am trying to run the following process:
1-Getting JSON text from a website
2-Converting JSON text to collection (of 2 rows)
3-Writing the collection to Excel
The first two steps work perfectly. The problem occurs during step 3: Blue Prism writes only the first row. As you can see in the attached picture ("Collection properties - current values"), BP creates one row for each row (I do not know why). As a result, only the first row (image: "first row") is written in the excel file (picture: "Output on Excel").
This is caused by the "extra" intermediary row that is created by BP. As a matter of fact, I have tried to create manually a random collection Coll1 (image: "collection manually created") and BP did correctly write the entire collection. As you may have noticed, the collection I have manually created shows only one row that contains both "real" rows (image: "Collection manually created - current values). And this allows BP to copy all the table, as the "real" rows are directly listed one under the other.
Any idea how one can structure the first collection the same way as in the second collection so that BP writes the entire collection?
I have also tried the "Append rows to collection", "Add to queue" functions, etc. but no luck. At the end, the output remains the same which is only one row that is considered/treated.
Below is the original JSON code:
[{"employee":"first.last@google.com","car":"Peugeot 208 GT line","color":"Ruby red"},
{"employee":"another.first.another.last@google.com","car":"Mini Cooper","color":"Midnight black"}]
The goal is to be able to write this code directly into an excel spreadsheet.
Thank you very much for your support. Your help would be highly appreciated.
Best regards
Attachments
Last edited: