Question

Get Nested Dictionary Data in JSON Response

  • 10 December 2023
  • 1 reply
  • 41 views

Badge

Hi 

I have below data in JSON response through Rest API. Could you please help me to get the opened_by node value.

Thanks,

Ajay

 

{"result":[{"parent":{"link":"https://adientdev.service-now.com/api/now/table/task/e62b23d9dbad44dc0b6dc7ec0b96194e","value":"e62b23d9dbad44dc0b6dc7ec0b96194e"},
        "made_sla":"true",
        "watch_list":"",
        "sc_catalog":"",
        "upon_reject":"cancel",
        "sys_updated_on":"2020-03-26 13:09:26",
        "task_effective_number":"SCTASK0268655",
        "approval_history":"",
        "skills":"",
        "number":"SCTASK0268655",
        "sys_updated_by":"jdasji",
        "opened_by":{"link":"https://adientdev.service-now.com/api/now/table/sys_user/1a180baedb3a1f04fd8fd855ca961961","value":"1a180baedb3a1f04fd8fd855ca961961"},
        "user_input":"",
        "sys_created_on":"2019-12-05 14:52:31",
        "sys_domain":{"link":"https://adientdev.service-now.com/api/now/table/sys_user_group/global","value":"global"},
        "state":"-5",
        "route_reason":"",
        "sys_created_by":"akramem4",
        "knowledge":"false",
       }]}


1 reply

Userlevel 7
Badge +13

Hi @alatwaa1 ,

 

Have you tried with the Get node value under the JSON Package?

result[0].opened_by

 
 
Refer this blog for a better understanding.
 
 

Reply