JSON Parsing Solution

[RohanGoswami1]

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
------------------------------

[ewilson]

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
------------------------------

[RohanGoswami1]

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
------------------------------

[ewilson]

@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
------------------------------