The Simple Way to Parse JSON Responses Using Groovy and Katalon Studio
Many people have asked how to retrieve information from JSON responses and parse the JSON format in Katalon Studio. Check out this post to learn more!
Join the DZone community and get the full member experience.
Join For FreeMany people in the Katalon forum have asked about retrieving information from JSON responses and parsing the JSON format in the Katalon Studio. In this post, I will show a simple way on how to do so. Let's get started.
JSON Response Example
Suppose we have the following JSON response, and we want to parse and retrieve its data:
{"menu": {
"id": "file",
"tools": {
"actions": [
{"id": "new", "title": "New file"},
{"id": "open", "title": "Open File"},
{"id": "close", "title": "Close File"}
],
"errors": []
}}}
JsonSlurper
We use this Groovy helper class to parse JSON strings. We need to create a new instance of JsonSlurper
and call the JsonSlurper.parseText
method. Here is the sample code:
import groovy.json.JsonSlurper
String jsonString = '''{"menu": {
"id": "file",
"tools": {
"actions": [
{"id": "new", "title": "New File"},
{"id": "open", "title": "Open File"},
{"id": "close", "title": "Close File"}
],
"errors": []
}}}'''
JsonSlurper slurper = new JsonSlurper()
Map parsedJson = slurper.parseText(jsonString)
The parsed JSON response is now stored in a variable called parsedJson
. In our case, it is the Map
data structure, but sometimes it may be something else.
JsonSlurper
also provides a couple of JsonSlurper
overloading methods, which can be used if your JSON input is File
, Reader
, InputStream
, or a URL other than String. For further information, please refer to the JsonSlurper documentation.
Get a Key Value
Let's say you want to get a value of id from the JSON response above. JSON is a structured document, so you can get any element using its absolute path. Check out this example:
String idValue = parsedJson.menu.id
String idValue2 = parsedJson.get("menu").get("id")
As you can see, there are two ways to get it. One is to access Map
objects using the dot notation (.). The other is to use get
methods from Map
, List
, and Set
as you do in Java.
Basically, the parsedJson
variable is a type of Then
. To get the inner Map
, you call parsedJson
. menu
is the String key. This method returns the inner Map
on which you can call other get methods until you reach your key.
Verify if a Key Is Present in JSON
If you want to verify if a selected key is present in a JSON response, you can use the similar code as below:
import com.kms.katalon.core.util.KeywordUtil
String getSelectedKey = parsedJson.menu.id
if(getSelectedKey == null) {
KeywordUtil.markFailed("Key is not present")
}
It is a simple check for the null — if the given key is not found, null is returned. But, there is one special case when this code won’t work, that is, if key “id” has value null in your JSON. For such cases, you should use more robust code:
boolean isKeyPresent = parsedJson.get("menu").keySet().contains("id")
if (!isKeyPresent) {
KeywordUtil.markFailed("Key is not present")
}
You get all keys from the "menu" object and then check if it contains the key you are looking for.
Get an Array Element
Your JSON response may also contain arrays. Like any array in Java or Groovy, you can access an array element using arrayName[index]
.
For example, we can get the "title" value of the first object in the "actions" array as below
String idValue = parsedJson.menu.tools.actions[0].title
String idValue2 = parsedJson.get("menu").get("tools").get("actions").get(0).get("title")
In this example, we access the item with the index of 0, the first item in the array (the index is zero-based).
Get an Array Element Based on Some Condition
A more usual case is when you want to get the exact array element based on some specific condition. For example, you get the "title" value of an object whose "id" is "Open." You can do using the following:
def array1 = parsedJson.menu.tools.actions
String onlickValue1 = ""
for(def member : array1) {
if(member.id == 'Open') {
onlickValue1 = member.title
break
}
}
I used the for-each loop in this case. This loop checks every item in the array until the condition is met. If so, onlickValue1
is assigned to the item's title.
JSON Data Types
The JSON format supports a few data types, such as String
, number
, Boolean
, and null
. If you are not sure what the data type is, you can just use the keyword def
.
def myVar = ‘get value from json here’.
A rule of thumb is that a String
value is enclosed in quotes, numbers unquoted (floating point may be present as well), and Boolean. But, initializing a variable using def
is always a good choice when you are not sure about its type.
Conclusion
This tutorial offers a few basic best practices for working with JSON strings in Katalon Studio. JSON is the most common format returned from API/Web Services. When you perform API testing, you likely have to deal with JSON responses. Hopefully, these practices are useful for your API testing!
Published at DZone with permission of Marek Melocik. See the original article here.
Opinions expressed by DZone contributors are their own.
Comments