Extarct value from json

[Mathkar_kunal]

Hello,

I have below json

{
“billableSeconds”: 10800,
“timeSpent”: “3h”,
“location”: {
“name”: “Default Location”,
“id”: 1
},
“attributes”: {
“WorkLocation”: {
“workAttributeId”: 1,
“value”: “”,
“type”: “STATIC_LIST”,
“key”: “WorkLocation”,
“name”: “Work Location”
},
“TypeofHour”: {
“workAttributeId”: 5,
“value”: “”,
“type”: “STATIC_LIST”,
“key”: “TypeofHour”,
“name”: "Type of Hour "
},
“HourType”: {
“workAttributeId”: 2,
“value”: “”,
“type”: “STATIC_LIST”,
“key”: “HourType”,
“name”: “Hour Type”
}
},
“comment”: “abc”,
“tempoWorklogId”: 1597584,
“timeSpentSeconds”: 10800,
“issue”: {
“key”: “DC0045-97”,
“id”: 505083,
“versions”: ,
“issueStatus”: “In Progress”,
“reporterKey”: “123”,
“internalIssue”: false,
“components”: [
15700
],
“issueType”: “Service Request”,
“projectId”: 611,
“projectKey”: “DC0045”,
“iconUrl”: “/abc/pqr/”,
“summary”: “xyz”
},
“originId”: 111,
“worker”: “USER123”,
“updater”: “USER234”,
“started”: “2023-07-25 08:28:00.000”,
“dateCreated”: “2023-07-27 08:28:53.000”,
“dateUpdated”: “2023-08-09 10:40:00.000”,
“originTaskId”: 505083
}

i need to extract work location - work attribute id which is 1 , type of hour - work attribute id which is 5 and hour type - work attribute id which is 2

so i need to retive thise IDs only which are 1,5 and 2

let me know how can i achive this.
help me on same.

[Anil_G (Anil Gorthi)]

@Mathkar_kunal

use deserialize json and get the output into a variable say jobj

then

loc id - jobj("attributes")("WorkLocation")("workAttributeId").ToString

type id - jobj("attributes")("TypeofHour")("workAttributeId").tostring

Hour id - jobj("attributes")(" HourType")("workAttributeId").tostring

[rashmisingh2695 (Rashmi)]

Hi @Mathkar_kunal

Please try to use deserialize json activity and extract values from Response like below
JSONResponse(“attributes”)(“WorkLocation”)(“workAttributeId”).ToString
JSONResponse(“attributes”)(“TypeofHour”)(“workAttributeId”).tostring
JSONResponse(“attributes”)(“HourType”)(“workAttributeId”).tostring