how to get data using array concept

Hey amarnath1234,

If you are really good in handling JSON using Gson , jettison and json-simple, then it's quite easier for you to do it. You can use simple java code to handle this.

1. Get the Json
2. Convert to JSONArray of "personalizedOffers" and iterate using for loop till the size() of array.
3. Convert the Array Data to JSONObject of "promotion" and again iterate using for loop till the "promotion" object size.
4. Fetch all the String values you require, which exists inside promotion object.

This is the way, you can handle this dynamically and you don't have to worry about the no. of "promotion" object existing.

Here is the working code:-

import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;

import org.codehaus.jettison.json.JSONArray;
import org.codehaus.jettison.json.JSONException;
import org.codehaus.jettison.json.JSONObject;

BufferedReader reader = new BufferedReader(new FileReader("C:\\Users\\Desktop\\json.txt"));
		String json = "";
		try {
		    StringBuilder sb = new StringBuilder();
		    String line = reader.readLine();

		    while (line != null) {
		        sb.append(line);
		        sb.append("\n");
		        line = reader.readLine();
		    }
		    json = sb.toString();
		} finally {
		    reader.close();
		}
		
		JSONObject object = new JSONObject(json);
		JSONArray personalizedOffers = new JSONArray(object.getString("personalizedOffers"));
		for(int i=0; i<personalizedOffers.length(); i++) {
			JSONObject validCoupon = (JSONObject) personalizedOffers.getJSONObject(i).get("validCoupon");
			JSONObject promotion = validCoupon.getJSONObject("promotion");
			System.out.println(promotion.getString("id"));
			System.out.println(promotion.getString("createdTime"));
			System.out.println(promotion.getString("lastUpdatedTime"));
			System.out.println(promotion.getString("shortDescription"));
			System.out.println(promotion.getString("longDescription"));
}
		

If you are using ReadyAPI, please download - jettison.jar, put inside soapui/home/ext and then run this code.

Please refer the link I have mentioned above. First take example of easy JSON and then try the JSON you have mentioned here.

If the code works, please don't  forget to Accept as solution.

Thanks,

avidCoder

/**
* Below is script assertion
* for the Rest Request test step
* which reads json response
* and extract user requested data
* write into a csv file in system temporary directory
**/
def json = new groovy.json.JsonSlurper().parseText(context.response)
def promotions = json.personalizedOffers*.validCoupon.promotion
//You may add more columns if needed
def columns = ['createdTime', 'lastUpdatedTime', 'shortDescription', 'longDescription']
def sb = new StringBuffer()

sb.append(columns.join(',')).append('\n')

def buildPromotionData = { promotion ->
	columns.eachWithIndex { key, index ->
		promotion[key] ? sb.append(promotion[key]) : sb.append('')
		(index+1 != columns.size()) ? sb.append(',')	: sb.append('\n')
	}
}

promotions.each { buildPromotionData(it) }
def file = "${System.getProperty('java.io.tmpdir')}/${System.currentTimeMillis()}.csv" as String
log.info "Creating the file ${file}"
new File(file).write(sb.toString())
log.info sb.toString()

 

The above  Script Assertion does what was requested. No additional libraries or test steps required.

You may be able to open "CSV" file in excel if you want.