How to get JSON from an XML response from server?

Question

My android application sends a web service request and gets the response from web service in xml, with the embedded data in JSON. I am saving this in a string. Now I do not know how to get the JSON data from this string.

    System.setProperty("http.keepAlive", "false");
            // request parameters
            HttpParams params = httpClient.getParams();
            HttpConnectionParams.setConnectionTimeout(params, 10000);
            HttpConnectionParams.setSoTimeout(params, 15000);
            // set parameter
            HttpProtocolParams.setUseExpectContinue(httpClient.getParams(), true);

            // POST the envelope
            HttpPost httppost = new HttpPost(url);
            // add headers
            httppost.setHeader("SOAPAction", soapAction);
            httppost.setHeader("Content-Type", "text/xml; charset=utf-8");
    //      httppost.setHeader("Content-Length",
    //              String.valueOf(requestEnvelope.length()));
            httppost.setHeader("SOAPAction", "http://tempuri.org/"
                    + methodName);



    //      String responseString = "";
            try {

                // the entity holds the request
                HttpEntity entity = new StringEntity(requestEnvelope);
                httppost.setEntity(entity);
HttpResponse response = httpClient.execute(httppost);
            String result = EntityUtils.toString(response.getEntity());

This is the response from the server, which I get in the result string.

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<ValidatePassCodeResponse xmlns="http://tempuri.org/">
<ValidatePassCodeResult>
[{"ID":1929,"Headline":"Test News","Detail":"","SubmitDate":"1/17/2012 12:08:04 PM"}]
</ValidatePassCodeResult>
</ValidatePassCodeResponse>
</soap:Body>
</soap:Envelope>

Thanks in advance.

aiRbornE · Accepted Answer · 2012-01-23 07:29:23Z

This is how I removed the tags of xml string and obtained the json string from that, then I parsed the string to json array and obtained the result.

XmlPullParserFactory factory = XmlPullParserFactory.newInstance();
            factory.setNamespaceAware(true);
            XmlPullParser xpp = factory.newPullParser();

            xpp.setInput(new StringReader(result));
            int eventType = xpp.getEventType();
            while (eventType != XmlPullParser.END_DOCUMENT) {
                if (eventType == XmlPullParser.START_DOCUMENT) {
                    System.out.println("Start document");
                } else if (eventType == XmlPullParser.START_TAG) {
                    System.out.println("Start tag " + xpp.getName());
                } else if (eventType == XmlPullParser.END_TAG) {
                    System.out.println("End tag " + xpp.getName());
                } else if (eventType == XmlPullParser.TEXT) {
                    responseString = xpp.getText();
                    System.out.println("Text " + xpp.getText());
                }
                eventType = xpp.next();
            }
            System.out.println("End document");

Community · Accepted Answer · 2017-05-23 11:45:47Z

0

Please see my question and put your response string in json viewer.

How to use Json Parsing?

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Jan 18, 2012 at 11:58

Dipak Keshariya

22.3k18 gold badges80 silver badges129 bronze badges

Comments

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

0

First retrieve JSON using SAXParser.
See this sample.
Then you parse the JSON. See this question.

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Jan 18, 2012 at 11:59

Shadow

6,3073 gold badges22 silver badges14 bronze badges

Comments

DaveShaw · Accepted Answer · 2012-01-19 13:15:14Z

0

I got the solution using XMLPullParser. Thanks for the help though.

edited Jan 19, 2012 at 13:15

DaveShaw

52.9k18 gold badges118 silver badges142 bronze badges

answered Jan 19, 2012 at 13:07

aiRbornE

1391 silver badge11 bronze badges

1 Comment

Jim DeLaHunt Over a year ago

... and what was the answer? The next reader of this question could benefit if you write down what you found out.

Collectives™ on Stack Overflow

How to get JSON from an XML response from server?

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related