topic RE: JSON Parsing Solution in Product Forum

JSON Parsing Solution

RohanGoswami1 — Thu, 04 Aug 2022 16:28:00 GMT

Hi Everyone,
I am looking for solution to retrieve data from a JSON. I have try doing by using the Utility - JSON. As the JSON has nested data so it is not working for me to get the exact piece of data. Any Suggestions would be a great help.
This is JSON Below. Where all the objects data should be extracted.
{
"Success":true,
"Data":
[
{
"ClientName":"Rock Caprio",
"missingValues":"",
"jsonData":{
"member_number":"96.51364",
           "first_label":"99.31908",
           "last_label":"99.36682",
           "date_of_birth":null,
           "date_of_service":null,
           "member_id":"94",
           "first_name":"UserName",
           "last_name":"TitleName",
           "date_of_birth":null,
           "date_of_service":null
           }
}
]
}

------------------------------
Rohan Goswami
------------------------------

RE: JSON Parsing Solution

ewilson — Thu, 04 Aug 2022 17:01:00 GMT

Hi @RohanGoswami1,

What is the issue you're encountering with the Utility - JSON VBO? If you use the either the JSON to Collection action or the JSON to Collection (Skipping Array) action, they will convert the raw JSON string to a Blue Prism Collection. You can then iterate that Collection.

Here's an example of how I would access the member_number value as a data item if my Collection was generated using JSON to Collection: [Result.Data.JSON:Array.jsonData.member_number]

And here's how I would access it if I had used the JSON to Collection (Skipping Array) action: [Result.Data.jsonData.member_number]
Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: JSON Parsing Solution

RohanGoswami1 — Thu, 04 Aug 2022 17:19:00 GMT

Thanks @ewilson,
I am new to Blue Prism so facing few small doubts. I am Not aware of this expression [Result.Data.JSON:Array.jsonData.member_number]. This helped me Thanks a lot.

Best Ragards
Rohan Goswami

------------------------------
Rohan Goswami
------------------------------

RE: JSON Parsing Solution

ewilson — Thu, 04 Aug 2022 17:35:00 GMT

@RohanGoswami1,

Happy to help.

For future reference, if you step through your process in Debug, you can open the Collection data item and see what the populated field names are. Then you'll have what you need to figure out the name reference.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------