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

Appium and android mobile app automation

Next appium and Android mobile app automation video tutoria l is live. If you are new to appium then please check - appium-tutorial This video tutorial covers - Start vysor (Just for this session and not mobile automation :)) Start appium and start appium inspector Desired Capabilities platformName - Android deviceName - L2N0219828001013 (as seen on "adb devices") Saved Capability Sets Start Session Scan app elements using appium inspector Get appPackage and appActivity using "APK info" app Install "APK info" app and open app whose appPackage and appActivity are required i.e. calculator Check top section of app icon com.android.calculator2 is app package com.android.calculator2.Calculator is app activity testng.xml file settings for running Android app tests Test details com.seleniumtests.tests.mobile.AndroidAppTest and CalculatorScreen class View beautiful STF test report  

Return only first or last element from webelements collection

Note: If you are new to java and selenium then start with selenium java training videos .     We often come across situation when there are multiple elements on a page and we probably like to exercise only a few of them using selenium webdriver. May be just first and last element. For example on a search result page we may like to click on only first and last link and not all. This is when Iterables API comes handy. (By the way I am assuming that you have already completed watching selenium training videos :)). Once we have collection of web element then we can use Iterables to get only first or last element as following - Consider that we fetch collection of element as - List< WebElement > webElements = getDriver().findElements(By. id ( "htmlID" ));   Now we can get the first web element from this collection as -  WebElement firstElement = Iterables. getFirst (webElements,  getDriver().findElement(By. id ( "defaultElement" )));   Herein second

Using chrome console to test xPath and css selectors

Note: If you are new to java and selenium then start with selenium java training videos .       Since the advent of selenium there have been many plugin to test xPath / css selectors but you don’t need any of them if you have chrome browser. Using Chrome console you can test both xPath and css selectors. Launch website to be tested in chrome browser and hit F-12 and you would see chrome console opened in lower pane of application - Hit escape key and console would open another pane to write element locators - And now you can start writing xPath or css selectors in chrome console and test them - The syntax for writing css id - $$(“ ”) And hit the enter key. If your expression is right then html snippet of the application element corresponding to the css selector would be displayed - If you mouse over the html snippet in chrome console then it would highlight the corresponding element in application - If you want to clean console of previously wri