Databases
StackOverflow2013
Postsdbo
POParsing a JSON Response from a .Net webservice
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POParsing a JSON Response from a .Net webservice
    primarykey
    data
    text
    <p>Just to get this out in the open I am new to JAVA, KSOAP, and JSON. So I'll try to explain this the best I can.</p> <p>A while ago I created a webservice to be consumed by Blackberry Apps that we're built using the plug in for Visual Studio. Now the project I am working on, I want to consume the same webservice for Android devices. For the most part I have the base code for the Android app done and working. Here's my problem:</p> <p>I can successfully call the webservice and get a response. I know from creating the webservice that it sends a JSON response. My problem is trying to parse through the JSON response. I have found a few examples that I have been suiting to my needs however I am hung up on one thing.</p> <p>In the JSON each element is preceeded by "anyType" which is forcing my code to return no results (Ultimately I am binding the data to an ArrayList) Here's what I get if I "getProperty(0).toString()...</p> <pre><code>anyType{Artist=anyType{TrackName=Champagne Supernova;}; </code></pre> <p>Here is the code I am using to parse the JSON Object....</p> <pre><code>SoapObject gr = (SoapObject)envelope.getResponse(); String ro = gr.getProperty(0).toString(); //Added just to see structure of response Artist_Result.add(gr.toString()); if (ro.startsWith("{")) { JSONObject JSONObj = new JSONObject(ro); Iterator&lt;String&gt; itr = JSONObj.keys(); while (itr.hasNext()) { String key = (String)itr.next(); String value = JSONObj.getString(key); //bundleResult.putString(key, value); Artist_Result.add(value); } } else if (ro.startsWith("[")) { JSONArr = new JSONArray(ro); for (int i = 0; i &lt; JSONArr.length(); i++) { JSONObj = (JSONObject)JSONArr.get(i); //bundleResult.putString(String.valueOf(i), JSONObj.toString()); Artist_Result.add(JSONObj.toString()); } } </code></pre> <p>WebService Code:</p> <pre><code> [WebMethod] [return: System.Xml.Serialization.XmlArrayItemAttribute(typeof(Artist))] public Artist[] GetArtist(string ArtistQuery) { // All the SQL Stuff Here SqlDataReader sReader; sReader = cmd.ExecuteReader(); List&lt;Artist&gt; Artists = new List&lt;Artist&gt;(); while (sReader.Read()) { Artist result = new Artist(); result.TrackName = sReader.GetString(0); Artists.Add(result); } sReader.Close(); sqlConn.Close(); return Artists.ToArray(); } public class Artist { public string TrackName; } </code></pre> <p>Sample of XML Output from a browser:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt; - &lt;ArrayOfArtist xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://bb.mcrcog.com/"&gt; - &lt;Artist&gt; &lt;TrackName&gt;Champagne Supernova&lt;/TrackName&gt; &lt;/Artist&gt; - &lt;Artist&gt; &lt;TrackName&gt;Don't Look Back In Anger&lt;/TrackName&gt; &lt;/Artist&gt; - &lt;Artist&gt; &lt;TrackName&gt;D'you Know What I Mean&lt;/TrackName&gt; &lt;/Artist&gt; - &lt;Artist&gt; &lt;TrackName&gt;Go Let It Out&lt;/TrackName&gt; &lt;/Artist&gt; </code></pre> <p>I have a feeling I will need to implement a Class, and Getters/Setters on the Android side. I'm just not sure how to go about doing that. Any help would be greatly appreciated!</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMaskau
    1. USMaskau
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POParsing a JSON Response from a .Net webservice
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POParsing a JSON Response from a .Net webservice
      1. USuser77115
      1. VTFavorite
    1. COAFAIK, that is not valid JSON, which will be contributing to your difficulty. http://json.org/
      singulars
      1. POParsing a JSON Response from a .Net webservice
      1. USCommonsWare
    2. COThat doesn't look like valid JSON at all to me. I doubt you'll be able to get the built in parser to do anything with that
      singulars
      1. POParsing a JSON Response from a .Net webservice
      1. USsynic
    3. COI knew this would be a messed up project....but when I built the web service, like I said it was for Blackberry apps, using the plugin for Visual Studio....which in turn they were actually written in JavaScript, and the web service works flawlessly with the BB apps. The plug in parsed the response automatically(By using Visual Studio's "Add Web Refrence"), so I never had to deal with this, until I jumped platforms, and now I'm lost.
      singulars
      1. POParsing a JSON Response from a .Net webservice
      1. USMaskau
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload