cancel
Showing results for 
Search instead for 
Did you mean: 

[TechCorner Challenge #15] Fetch a value/data from a JSON response using a Groovy Script

SOLVED
sonya_m
Community Manager

[TechCorner Challenge #15] Fetch a value/data from a JSON response using a Groovy Script

Hello ReadyAPI Community!

 

We have another task for you to put your ReadyAPI knowledge to the test. Check out the participation rules and the TechCorner Leaderboard here.

 

In this task, we will have a scenario in which you need to iterate throughout a JSON response to find a specific item/value from it. You should stop once the value has been found.

 

Task: Find a specific value in a JSON response using a Groovy script

Difficulty: Star_Gold.pngStar_gray.pngStar_gray.png

 

Here is what your script should do:

1. Iterate through all the test steps in a test case that have JSON responses.

2. Compare the value given (VeryImportantString) with all the values in the JSON response.

3. Once the value is found, return it. If there is no such value in the response, return “The value wasn’t found“.

 

JSON response example:

 

{
	"id": 1111,
	"name": "doggie",
	"photoUrls": [
		"string"
	],
	"tags": [
		{
			"id": 99,
			"name": "string",
			"Additional info": [
				{
					"ad1": "VeryImportantString",
					"ad2": "NoteVeryImportantString"
				}
			]
		}
	],
	"status": "available"
}

 

Helpful Tips:


Iteration Sample Code:

 

def TesCaselist=context.testCase.testSuite.getTestCaseList()
TesCaselist.each{
def steps=it.getTestStepList(); //'it' is used for referring to current item
steps.each{
(CHECK SMTH)? <DO SMTH>:<DO SMTH ELSE> 
}

 

Good luck!


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Tags (1)
2 ACCEPTED SOLUTIONS

Accepted Solutions
ChrisA
Community Leader

Fetch a value/data from a JSON response using a Groovy Script

Task: Find a specific value in a JSON response using a Groovy script

 

This is a solution created for [TechCorner Challenge #15]

 

Hi,

Here is my attempt....

 

 

def TestCaselist=context.testCase.testSuite.getTestCaseList();
import groovy.json.*;

def jsonSlurper = new JsonSlurper();
def responseMessage;

def importantString = "some value";  // This is the value to look for....

def testStepName;
def found = false;
def returnString = '';

TestCaselist.each{

  def steps=it.getTestStepList(); //'it' is used for referring to current item
  steps.each{
    if(it.toString().contains('RestTest')){
      if(it.testRequest.response != null){ 
        // We only want to check steps where there is a response

        testStepName = it.name;  // We use this later.
        responseMessage = it.testRequest.response.contentAsString;  // Get the response as string
          if(responseMessage != null){
            // Only continue if message is not null.
            try {
              // Only proceeding if response parses into JSON
              def object = jsonSlurper.parseText(responseMessage);

              // Convert JSON back to a string and use contains function to check for importantString
              if(object.toString().contains(importantString)){
                // Found one.  Log it, append to return string and set found to true.
                log.info("Found '" + importantString + "' in Test Step " + testStepName);
                returnString = returnString + "Found '" + importantString + "' in Test Step " + testStepName + ".\n";
                found = true;
              }
            } catch(Exception e){
              // Not JSON - Don't have to log this, but only trying to ensure we only check JSON response.
              log.info(e);
            }
          }
        }
      }
    }
}

if (found) {
  return returnString;
} else {
  return ("Could not find '" + importantString + "' in any JSON reponse.");
}

 

View solution in original post

Tags (1)
HimanshuTayal
Community Hero

Fetch a value/data from a JSON response using a Groovy Script

Task: Find a specific value in a JSON response using a Groovy script

 

This is a solution created for [TechCorner Challenge #15]

 

Hi @sonya_m :

 

Thank you for letting me know, please refer below code,hope this will work

 

 

import groovy.json.*;

def testCases = testRunner.testCase.testSuite.getTestCaseList()
def jsonSlurper = new JsonSlurper()

def strToCheck = "VeryImportantString"
def returnText = ""

testCases.each{
	def steps = it.getTestStepList();
	steps.each{
//		Checking only the rest teststep
		if(it.config.type.toLowerCase() == "restrequest" ){
			response = it.getPropertyValue("response")
//			Checking whose response is not null
			if(response != null){
//				getting name to append
				def testStepName = it.name;
				def res = jsonSlurper.parseText(response);
				
//				checking that desired text exist or not
				if(res.toString().contains(strToCheck))
					returnText = returnText + " Found \"" + strToCheck + "\" in Test Step " + testStepName +" \n"
			}
		}
	}
}
if (returnText != null || returnText != "")
	return returnText
else
	return ("The value wasn't found")

 

 

 


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal

View solution in original post

Tags (1)
5 REPLIES 5
ChrisA
Community Leader

Fetch a value/data from a JSON response using a Groovy Script

Task: Find a specific value in a JSON response using a Groovy script

 

This is a solution created for [TechCorner Challenge #15]

 

Hi,

Here is my attempt....

 

 

def TestCaselist=context.testCase.testSuite.getTestCaseList();
import groovy.json.*;

def jsonSlurper = new JsonSlurper();
def responseMessage;

def importantString = "some value";  // This is the value to look for....

def testStepName;
def found = false;
def returnString = '';

TestCaselist.each{

  def steps=it.getTestStepList(); //'it' is used for referring to current item
  steps.each{
    if(it.toString().contains('RestTest')){
      if(it.testRequest.response != null){ 
        // We only want to check steps where there is a response

        testStepName = it.name;  // We use this later.
        responseMessage = it.testRequest.response.contentAsString;  // Get the response as string
          if(responseMessage != null){
            // Only continue if message is not null.
            try {
              // Only proceeding if response parses into JSON
              def object = jsonSlurper.parseText(responseMessage);

              // Convert JSON back to a string and use contains function to check for importantString
              if(object.toString().contains(importantString)){
                // Found one.  Log it, append to return string and set found to true.
                log.info("Found '" + importantString + "' in Test Step " + testStepName);
                returnString = returnString + "Found '" + importantString + "' in Test Step " + testStepName + ".\n";
                found = true;
              }
            } catch(Exception e){
              // Not JSON - Don't have to log this, but only trying to ensure we only check JSON response.
              log.info(e);
            }
          }
        }
      }
    }
}

if (found) {
  return returnString;
} else {
  return ("Could not find '" + importantString + "' in any JSON reponse.");
}

 

View solution in original post

Tags (1)
HimanshuTayal
Community Hero

Re: [TechCorner Challenge #15] Fetch a value/data from a JSON response using a Groovy Script

Hi @sonya_m : 

 

First of all thanks for another challenge. And below is the code in order to solve the challenge, please try it and let me know whether it fits in according to challenge or need any modification 🙂

 

 

import groovy.json.*;

def testCases = testRunner.testCase.testSuite.getTestCaseList()
def jsonSlurper = new JsonSlurper()

def strToCheck = "VeryImportantString"
def returnText = ""

testCases.each{
	def steps = it.getTestStepList();
	steps.each{
//		Checking only the rest teststep
		if(it.config.type.toLowerCase() == "restrequest" ){
			response = it.getPropertyValue("response")
//			Checking whose response is not null
			if(response != null){
//				getting name to append
				def testStepName = it.name;
				def res = jsonSlurper.parseText(response);
				
//				checking that desired text exist or not
				if(res.toString().contains(strToCheck))
					returnText = returnText + " Found \"" + strToCheck + "\" in Test Step " + testStepName " \n"
			}
		}
	}
}
if (returnText != null || returnText != "")
	return returnText
else
	return ("The value wasn't found")

 

 

 


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal
sonya_m
Community Manager

Re: [TechCorner Challenge #15] Fetch a value/data from a JSON response using a Groovy Script

@ChrisA One more challenge done! Congratulations😊

 

@HimanshuTayal It was a close one! However, we experienced a compilation error. Could you double-check🙂 


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
HimanshuTayal
Community Hero

Fetch a value/data from a JSON response using a Groovy Script

Task: Find a specific value in a JSON response using a Groovy script

 

This is a solution created for [TechCorner Challenge #15]

 

Hi @sonya_m :

 

Thank you for letting me know, please refer below code,hope this will work

 

 

import groovy.json.*;

def testCases = testRunner.testCase.testSuite.getTestCaseList()
def jsonSlurper = new JsonSlurper()

def strToCheck = "VeryImportantString"
def returnText = ""

testCases.each{
	def steps = it.getTestStepList();
	steps.each{
//		Checking only the rest teststep
		if(it.config.type.toLowerCase() == "restrequest" ){
			response = it.getPropertyValue("response")
//			Checking whose response is not null
			if(response != null){
//				getting name to append
				def testStepName = it.name;
				def res = jsonSlurper.parseText(response);
				
//				checking that desired text exist or not
				if(res.toString().contains(strToCheck))
					returnText = returnText + " Found \"" + strToCheck + "\" in Test Step " + testStepName +" \n"
			}
		}
	}
}
if (returnText != null || returnText != "")
	return returnText
else
	return ("The value wasn't found")

 

 

 


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal

View solution in original post

Tags (1)
sonya_m
Community Manager

Re: Fetch a value/data from a JSON response using a Groovy Script

Yay! It is working perfectly @HimanshuTayal !


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors