Skip to main content

Using JSONobject and JSONarray for parsing json

Did you ever wonder why sometimes you have json with curly brackets while sometimes with square brackets? This is because you were dealing with JSON object and arrays respectively. JSON array organizes collection of related items which can be json object in themselves -


[{"name":"item 1"},{"name": "item2} ]


JSON object usually contains key/value pair of related item. For ex -


{"name": "firstname", "dateOfBirth":"65475645"}


We used Jackson parser in API video tutorial but if you don’t need entire data set from json response of API call then you can parse the API response using JSONArray or JSONObject APIs.
you would use JSONArray to parse JSON which starts with the array brackets.  On the other hand, you would use JSONObject when dealing with JSON that begins with curly braces.


Of course, JSON arrays and objects may be nested inside one another. One common example of this is an API which returns a JSON object containing some metadata alongside an array of the items matching your query:
{"startIndex": 0, "data": [{"name":"item 1"},{"name": "item2"} ]}


We will use the json file available at - https://httpbin.org/get?show_env=1 in following example.
In case httpbin goes down in future, the same json looks as -


{
  • args:
  • {
    • show_env: "1"
  • },
  • headers:
  • {
    • Accept: "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8",
    • Accept-Encoding: "gzip, deflate, sdch, br",
    • Accept-Language: "en-US,en;q=0.8,de;q=0.6",
    • Host: "httpbin.org",
    • Runscope-Service: "httpbin",
    • Upgrade-Insecure-Requests: "1",
    • User-Agent: "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36",
    • X-Forwarded-For: "94.135.236.134",
    • X-Forwarded-Protocol: "https",
    • X-Forwarded-Ssl: "on",
    • X-Real-Ip: "94.135.236.134"
  • },
  • origin: "94.135.236.134",
}


We will use jersey client to get the json response -


// get JSON response
Client client = Client.create();
WebResource webResource = client.resource("https://httpbin.org/get?show_env=1");
ClientResponse clientResponse =  webResource.accept(MediaType.APPLICATION_JSON).get(ClientResponse.class);
System.out.println(clientResponse.getStatus());
String jsonResponse = clientResponse.getEntity(String.class);
System.out.println(jsonResponse);


Since the output is json object here, we will use JSONObject to parse the response from previous example and print the data we need.
// parse JSON objects
JSONObject jsonObject = new JSONObject(jsonResponse);
System.out.println("headers are: "+jsonObject.getString("headers"));
System.out.println("origin is: "+jsonObject.getString("origin"));
System.out.println("url is: "+jsonObject.getString("url"));


I am just printing the required data points but you can use it carry assert operation to verify if data returned is valid or not.


Now let’s see an example of parsing json array. For this we would use the API call. In case the api goes down in future, this is how the response looks like -


{
  • Content-Length: "137",
  • Content-Type:
  • [
    • "application/json",
    • "text/plain; charset=UTF-8"
  • ],
  • Server: "httpbin"
}


it is a JSON object which contains “Content-Type:” array and we will print all of its values.


// get JSON response
webResource = client.resource("https://httpbin.org/response-headers?Content-Type=text%2Fplain%3B+charset%3DUTF-8&Server=httpbin");
clientResponse =  webResource.accept(MediaType.APPLICATION_JSON).get(ClientResponse.class);
System.out.println(clientResponse.getStatus());
jsonResponse = clientResponse.getEntity(String.class);
System.out.println(jsonResponse);


// parse JSON Array
jsonObject = new JSONObject(jsonResponse);
JSONArray jsonArray = jsonObject.getJSONArray("Content-Type");
System.out.println("Content-Type json array is: "+jsonArray);


for(int index=0; index<jsonArray.length(); index++) {
  System.out.println("Content at JSON array index: "+index+", "+ jsonArray.get(index));
}

And now you can assert the JSON array data for required values.
Project Download

Popular posts from this blog

Selenium Tutorial: Ant Build for Selenium Java project

Ant is a build tool which could be used to have your tests running either from command line or from Hudson CI tool. There is detailed documentation available for ant here but probably you need to know only a little part of it for you selenium tests. The essentials which are needed to know are: Project Target (ant execution point and collection of tasks) Tasks (could be as simple as compilation) And there would usually be following targets for Selenium tools - setClassPath - so that ant knows where you jar files are loadTestNG - so that you could use testng task in ant and use it to execute testng tests from ant init - created the build file clean - delete the build file compile - compiles the selenium tests run - executes the selenium tests Here is my project set up for ant -

Verify email confirmation using Selenium

Note: If you are new to java and selenium then start with selenium java training videos .     Email confirmation seems to be integral part of any registration process. I came across an application which lets you provide your email address. You can follow the sign up link in you mail and then complete the registration process. Lets consider we provide GMail address for it. Now if were to use only Selenium then we would have to follow following steps - Launch GMail using Selenium; Some how search for new mail in the list of available mails; Some how click on it; Parse the mail message; Get the registration link; Follow up with registration process What do you think of an approach in which you can

Real Time JMeter Result Using Backend Listener

Since JMeter 2.13 Backend Listener has been available to create real time graph of JMeter Test. Following tutorial explain the entire process in detail. At the end of this tutorial you would be able to create JMeter Live Test Result dashboard similar to following - This tutorial borrows information from many sources and my own experiments with JMeter live reporting dashboard. I have added source of information wherever applicable But before we can build such a snazzy JMeter Live Reporting dashboard we need to understand two more components - influxDB (a time series database) and Grafana Dashboard This is a big tutorial, so take deep breath :-) and follow on. Once you complete set up specified in this tutorial then you can watch JMeter Training Video Tutorial to watch this in action. What is Time Series Database? A time series is a sequence of data points , typically consisting of successive measurements made over a time interval . Examples of time ...