Extract the specific value from the JSON object

Help Studio
, ,
1

Hi Team,

Please help me to extract the specific value from the JSON object

My HTTP request output is as shown below

@“{”“projects”“: {”“project”": [
{
““domain-name””: ““MIGRATION””,
““create-from-domain””: ““restored””,
““is-auto-mail-enabled””: false,
““description””: ““Created on 7/31/2020 12:18:10 PM””,
““db-server-name””: "“almawssqld01"”,
““uid””: ““518f0d59-d2c6-42af-8d23-0ce60e27f647"”,
““id””: 73,
““users-quota””: -1,
““domain-id””: 5,
““is-qpm-auto-calc-enabled””: true,
““is-active””: false,
““is-unicode””: false,
““db-name””: ““training_workflow_db””,
““version””: ““15.00"”,
““search-language””: ““English””,
““project-type””: ““Standard””,
““is-template””: false,
““exception-file””: “”””,
““is-db-native-auth””: false,
““db-type””: 2,
““name””: ““Workflow””,
},

I need the Domain name as output.

Kindly help on this

Thanks

2

@srinusoft37

I see this is not the full json

tyr this with desirialized data

jsondata("Projects")("Project")(0)("domain-name").ToString

cheers

3

Use Deserialize JSON Activity
jsonObject(“project”)(“domain-name”).ToString

4

in Addition to above:
grafik
output - myJObject | DataType: JObject

grafik

Kindly note: the property keys are case sensitive when using it

1 Like
5

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