# Extract information from Json

**URL:** <https://forum.uipath.com/t/extract-information-from-json/381828>\
**Category:** Studio\
**Tags:** activities-panel, question, studio, webapi, activities\
**Created:** [December 20, 2021, 10:48am UTC](https://forum.uipath.com/t/extract-information-from-json/381828 "2021-12-20T10:48:40Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![regina2112](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/regina2112/32/178742_2.png) [@regina2112](https://forum.uipath.com/u/regina2112)\
**Post date:** [December 20, 2021, 10:48am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/1 "2021-12-20T10:48:40Z")

</div>

Hello,

I have got this Deserialize Json Response and now I want to extract the stats count (236) and the first observationDate (2021-12-15T19:39:30.051Z). I am really grateful for some further help.

{  
“results”: [  
{  
“group”: {  
“queueId”: “58c45614-7805-4ee8-917a-3ac4879a959a”,  
“mediaType”: “email”  
},  
“data”: [  
{  
“metric”: “oWaiting”,  
“stats”: {  
“count”: 236  
},  
“truncated”: true,  
“observations”: [  
{  
“observationDate”: “2021-12-15T19:39:30.051Z”,  
“conversationId”: “835874ff-917d-44c8-8f4a-218a56ad99c2”,  
“sessionId”: “648ab238-f418-469f-bd67-5ac4747def34”,  
“requestedRoutingSkillIds”: [  
“37c8b7f6-8853-4fee-8700-9af744ce2b64”  
],  
“routingPriority”: 10,  
“participantName”: “John K. Samuel”,  
“direction”: “inbound”,  
“addressFrom”: “[johnksam@kln.gov.my](mailto:johnksam@kln.gov.my)”,  
“addressTo”: “[partner@zurich.mypurecloud.ie](mailto:partner@zurich.mypurecloud.ie)”,  
“requestedRoutings”: [  
“Bullseye”,  
“Standard”  
]  
},  
{  
“observationDate”: “2021-12-16T05:11:51.673Z”,  
“conversationId”: “0b32e1fe-2353-4431-b755-d1a491712dc8”,  
“sessionId”: “3eb4543c-6750-428f-a61d-7ed3874aee84”,  
“requestedRoutingSkillIds”: [  
“fba57f35-b897-49ee-83e1-f9ef8bab9be8”  
],  
“requestedLanguageId”: “f8f8339b-b23f-4ea0-a1d9-9e77219cdd54”,  
“routingPriority”: 10,  
“participantName”: “CHZ\_UAT\_SCC\_Inbound”,  
“direction”: “inbound”,  
“addressFrom”: “[chz.uat.scc.inbound@zurich.ch](mailto:chz.uat.scc.inbound@zurich.ch)”,  
“addressTo”: “[service@zurich.ch](mailto:service@zurich.ch)”,  
“requestedRoutings”: [  
“Bullseye”,  
“Standard”  
]  
},  
{  
“observationDate”: “2021-12-16T05:59:08.649Z”,  
“conversationId”: “0aa25128-89d4-47fc-95a9-8e1b0aa20c00”,  
“sessionId”: “93f29389-8f0e-4155-affb-afeff75e34a7”,  
“requestedRoutingSkillIds”: [  
“fba57f35-b897-49ee-83e1-f9ef8bab9be8”  
],  
“requestedLanguageId”: “f8f8339b-b23f-4ea0-a1d9-9e77219cdd54”,  
“routingPriority”: 10,  
“participantName”: “Sandro Tedesco”,  
“direction”: “inbound”,  
“addressFrom”: “[tedescosandro@hotmail.com](mailto:tedescosandro@hotmail.com)”,  
“addressTo”: “[service@zurich.ch](mailto:service@zurich.ch)”,  
“requestedRoutings”: [  
“Bullseye”,  
“Standard”  
] }}}

---

<div class="post-metadata">

**Author:** ![Jobin\_Joy](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jobin_joy/32/555040_2.png) [@Jobin\_Joy](https://forum.uipath.com/u/Jobin_Joy)\
**Post date:** [December 20, 2021, 10:56am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/2 "2021-12-20T10:56:33Z")

</div>

Hi @regina2112

Drag _ **“Deserialize JSON”** _ activity into the designer panel to deserialize a JSON string. Supply a variable to it as input and create an another variable of JsonObject type to use in Output.

![image](https://global.discourse-cdn.com/uipath/original/4X/4/8/c/48c69d534aefeaa92a9ca091e95f2d0db2771ce5.png)

Use this for reference.

> [@How to extract the exact data from Json file](https://forum.uipath.com/t/how-to-extract-the-exact-data-from-json-file/115745):
>
> Hi All, Am trying to extract the specific data from Json file . Can any of you help me on how to extract: Data is : {“invoiceNumber”:“Abc- 645687”,“accountNumber”:“DXXX”,“invoiceDate”:“XXXX”,“OrderNumber”:“XXXX”,“soldToDetails”:"; XXXXXXX . "} I wanted to create a datatable with this data . Can anyone please help. Thank you

Hope this will be helpful. Thank you.

---

<div class="post-metadata">

**Author:** ![regina2112](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/regina2112/32/178742_2.png) [@regina2112](https://forum.uipath.com/u/regina2112)\
**Post date:** [December 20, 2021, 10:59am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/3 "2021-12-20T10:59:07Z")

</div>

Hi @Jobin_Joy ,

Thank you for your quick response.

So after I deserialize the Json I want to get the 236 and the first observation date. How would I proceed?

Thank you and best regards,  
Regina

---

<div class="post-metadata">

**Author:** ![Jobin\_Joy](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jobin_joy/32/555040_2.png) [@Jobin\_Joy](https://forum.uipath.com/u/Jobin_Joy)\
**Post date:** [December 20, 2021, 11:04am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/4 "2021-12-20T11:04:33Z")

</div>

HI @regina2112

Please use like this.

LHS: StatCount →   
RHS:out\_json(“count”).ToString

Later you can convert string to int as below

CInt(StatCount)

Recommended to look into the above mentioned reference, it will give you more idea about this.

Thank you.

---

<div class="post-metadata">

**Author:** ![Gokul001](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/gokul001/32/462734_2.png) [@Gokul001](https://forum.uipath.com/u/Gokul001)\
**Post date:** [December 20, 2021, 11:08am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/5 "2021-12-20T11:08:33Z")

</div>

Hi @regina2112

1. Taking the count of the Json.
2. Use for each Activity (Enumerable.Range 0, Output Count Json)
3. Use Assign activity  
LHS → String variable  
RHS → “Deserialize JSON Output variable”.GetValue(“observationDate”).ToString

Regards  
Gokul

---

<div class="post-metadata">

**Author:** ![regina2112](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/regina2112/32/178742_2.png) [@regina2112](https://forum.uipath.com/u/regina2112)\
**Post date:** [December 20, 2021, 11:09am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/6 "2021-12-20T11:09:12Z")

</div>

This has not worked. I get “Object reference not set to an instance of an object”

---

<div class="post-metadata">

**Author:** ![pikorpa](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pikorpa/32/548059_2.png) [@pikorpa](https://forum.uipath.com/u/pikorpa)\
**Post date:** [December 20, 2021, 11:18am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/7 "2021-12-20T11:18:02Z")

</div>

Hey,

**jsonObject(“results”)(0)(“data”)(0)(“stats”)(“count”).ToString**

**jsonObject(“results”)(0)(“data”)(0)(“observations”)(0)(“observationDate”).ToString**

where 0 is the iteration of array.

---

<div class="post-metadata">

**Author:** ![Jobin\_Joy](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jobin_joy/32/555040_2.png) [@Jobin\_Joy](https://forum.uipath.com/u/Jobin_Joy)\
**Post date:** [December 20, 2021, 11:31am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/8 "2021-12-20T11:31:07Z")

</div>

Hi @regina2112

Oops. I didn’t check the data hierarchy,

![image](https://global.discourse-cdn.com/uipath/original/4X/4/b/f/4bfc268efa419360e40801a2cdef8128bfe85bc7.png)

Whatever highlight in yellow is root nodes, marked in red is the key for the value we are looking for.

Can you please try what @pikorpa suggested?

Thank you.

---

<div class="post-metadata">

**Author:** ![ppr](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ppr/32/464097_2.png) [@ppr](https://forum.uipath.com/u/ppr)\
**Post date:** [December 20, 2021, 11:32am UTC](https://forum.uipath.com/t/extract-information-from-json/381828/9 "2021-12-20T11:32:50Z")

</div>

![grafik](https://global.discourse-cdn.com/uipath/original/4X/4/6/7/46783bc9308319d805fa778c6307e7e993924180.png)  
Also have a look on the SelectToken / SelectTokens method like  
 ![grafik](https://global.discourse-cdn.com/uipath/original/4X/3/5/3/35311baa6fcdf5fb7b002f2d3b42942c503775e8.png)

---

<div class="post-metadata">

**Author:** ![regina2112](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/regina2112/32/178742_2.png) [@regina2112](https://forum.uipath.com/u/regina2112)\
**Post date:** [December 20, 2021, 12:17pm UTC](https://forum.uipath.com/t/extract-information-from-json/381828/10 "2021-12-20T12:17:08Z")

</div>

Thank you very much, now it worked!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [December 23, 2021, 12:17pm UTC](https://forum.uipath.com/t/extract-information-from-json/381828/11 "2021-12-23T12:17:15Z")

</div>

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.