Reading json data from remote service and printing specific elements

Question

Hi I have this json object data from service

{
    "Result": [
        {
            "Status": {
                "StatusCode": 200,
                "Text": "Successful"
            }
        },
        {
            "ListByPI": {
                "ORCA_ID": "25746",
                "ProtocolID": "20140476HU",
                "PIName": "DeFronzo"
            }
        },
        {
            "ListByPI": {
                "ORCA_ID": "21273",
                "ProtocolID": "20120202HU",
                "PIName": "DeFronzo"
            }
        }
    ]
}

How can I get the values of ORCA_ID, ProtocolID and PIName?

That's a JSON object, you need to 'deserialize' it. What language are you using for your application? — Anto
– Anto, Commented Jan 2, 2015 at 10:23
Where you do want to parse this json?? In PHP or js or android? — Indra Kumar S
– Indra Kumar S, Commented Jan 2, 2015 at 10:30
What do you want? You ask for a javascript solution and accept one with Java, then you ask more things in comments... You should read How do I ask a good question? — fedorqui
– fedorqui, Commented Jan 2, 2015 at 11:46

Community · Accepted Answer · 2017-05-23 12:05:53Z

0

You can for example use a for and loop through your desired element, as seen in get keys of json-object in JavaScript:

for (k in s.Result[1].ListByPI) {
    document.write(k);   
}

See it in action:

var s = {
    "Result": [
        {
            "Status": {
                "StatusCode": 200,
                "Text": "Successful"
            }
        },
        {
            "ListByPI": {
                "ORCA_ID": "25746",
                "ProtocolID": "20140476HU",
                "PIName": "DeFronzo"
            }
        },
        {
            "ListByPI": {
                "ORCA_ID": "21273",
                "ProtocolID": "20120202HU",
                "PIName": "DeFronzo"
            }
        }
    ]
};

for (k in s.Result[1].ListByPI) {
    document.write(k);   
}

Also in JSFiddle.

Update

If you don't want to specify Result[ + number + ], then you can loop through them like this:

for (i in s.Result) {
   document.write('we are in id);
   for (k in s.Result[i].ListByPI) {
       document.write(k);   
   }
}

See it in action:

var s = {
    "Result": [
        {
            "Status": {
                "StatusCode": 200,
                "Text": "Successful"
            }
        },
        {
            "ListByPI": {
                "ORCA_ID": "25746",
                "ProtocolID": "20140476HU",
                "PIName": "DeFronzo"
            }
        },
        {
            "ListByPI": {
                "ORCA_ID": "21273",
                "ProtocolID": "20120202HU",
                "PIName": "DeFronzo"
            }
        }
    ]
};

for (i in s.Result) {
   document.write('we are in id);
   for (k in s.Result[i].ListByPI) {
       document.write(k);   
   }
}

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Jan 2, 2015 at 10:50

fedorqui

293k113 gold badges592 silver badges640 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Raja Sekhar Reddy Bolle Over a year ago

how to get all values of ORCA_ID,ProtocolID,PIName

fedorqui Over a year ago

what do you mean? Update your question indication what is exactly your desired output.

Raja Sekhar Reddy Bolle Over a year ago

you code will display keys ORCA_ID,ProtocolID,PIName valuea but I want the values 25746,20140476HU,DeFronzo not the keys.

fedorqui Over a year ago

@RajaSekharReddyBolle then you can say: alert(k + " = " + s.Result[1].ListByPI[k]);. Check it and indicate if it works to you.

Raja Sekhar Reddy Bolle Over a year ago

the above will work but everytime we have to pass Result[1 0r 2 or 3] values,how to get all data by passing dynamically values to Result{] array

|

Indra Kumar S · Accepted Answer · 2015-01-02 10:28:39Z

0

In PHP you can use json_decode and extract like this

<?php
$contents = '{
"Result":[
{
"Status":{
"StatusCode":200,
"Text":"Successful"
}
},
{
"ListByPI":{
"ORCA_ID":"25746",
"ProtocolID":"20140476HU",
"PIName":"DeFronzo"
}
},
{
"ListByPI":{
"ORCA_ID":"21273",
"ProtocolID":"20120202HU",
"PIName":"DeFronzo"
}
}
]
}';

$json = json_decode($contents, true); 



echo "In Result  first ORCA_ID is ".$json['Result'][1]['ListByPI']['ORCA_ID']."<br>"; //Here result is an array...So Indexs should be mentioned... then string name

      ?>

And output is

In Result, first ORCA_ID is 25746

answered Jan 2, 2015 at 10:28

Indra Kumar S

2,9552 gold badges19 silver badges29 bronze badges

1 Comment

Raja Sekhar Reddy Bolle Over a year ago

I want to get in javascript

Prasad Khode · Accepted Answer · 2015-01-02 10:44:06Z

0

If you want to parse it by using java, then you can use the following:

String json = "{\"Result\":[{\"Status\":{\"StatusCode\":200,\"Text\":\"Successful\"}},{\"ListByPI\":{\"ORCA_ID\":\"25746\",\"ProtocolID\":\"20140476HU\",\"PIName\":\"DeFronzo\"}},{\"ListByPI\":{\"ORCA_ID\":\"21273\",\"ProtocolID\":\"20120202HU\",\"PIName\":\"DeFronzo\"}}]}";

JSONObject jsonObject = new JSONObject(json);

JSONArray jsonArray = jsonObject.getJSONArray("Result");

for (int i = 1; i < jsonArray.length(); i++) {
    JSONObject object = jsonArray.getJSONObject(i).getJSONObject("ListByPI");
    System.out.println("ORCA_ID = " + object.getString("ORCA_ID") + " --- ProtocolID = " + object.getString("ProtocolID"));
}

answered Jan 2, 2015 at 10:44

Prasad Khode

6,77712 gold badges48 silver badges62 bronze badges

Comments

Revannath Hajare · Accepted Answer · 2015-01-02 11:06:17Z

0

You can write this:

 var temp = {"Result": [
               { "Status": { "StatusCode": 200, "Text": "Successful" } },
               { "ListByPI": { "ORCA_ID": "25746", "ProtocolID": "20140476HU", "PIName": "DeFronzo" } },
               { "ListByPI": { "ORCA_ID": "21273", "ProtocolID": "20120202HU", "PIName": "DeFronzo" } }]
                };
                temp["Result"][0].Status.StatusCode;
                temp["Result"][0].Status.Text;
                temp["Result"][1].ListByPI.ORCA_ID;
                temp["Result"][1].ListByPI.ProtocolID;
                temp["Result"][1].ListByPI.PIName;
                temp["Result"][2].ListByPI.ORCA_ID;
                temp["Result"][2].ListByPI.ProtocolID;
                temp["Result"][2].ListByPI.PIName;
            }

answered Jan 2, 2015 at 11:06

Revannath Hajare

1

1 Comment

Raja Sekhar Reddy Bolle Over a year ago

If the "ListByPI" repetition is not known then how we will get the values instead of passing 1 and 2 values to temp["Result"][1 or 2].ListByPI.ORCA_ID;

Collectives™ on Stack Overflow

Reading json data from remote service and printing specific elements

4 Answers 4

Update

7 Comments

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Update

7 Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related