Navigating JSON Data in Groovy Using a Loop: A Handy Guide

Question

Navigating JSON Data in Groovy Using a Loop: A Handy Guide

Just starting out with Groovy and attempting to mock a service in SoapUI.

The task at hand involves loading a text file containing JSON data, and then matching that data to a specific node.

Here is what I have attempted so far:

def inputFile = new File("D:\\Users\\json.txt")
def InputJSON = new JsonSlurper().parseText(inputFile.text)

    InputJSON.each{  
        def ID1 = it
        it.items.each { 
            if(it.Number == itemNumber) 
            {
                log.info it
                requestContext.Id = ID1
            } 
        }
    }

While this works well, there is one problem – the format gets lost when ID1 loads into requestContext.Id from the file.

What I am aiming for is:

{
 "items" {
        "number" : 1475175072691
      }
}

However, what I end up getting is:

{
 metadata = {
        timestamp = 1475175072691
}
}

I'm puzzled as to why the double quotes " and colon : are stripped from my JSON. Any suggestions on how to resolve this?

javascript json groovy scripting soapui

Answer 1

Answer №1

Check out the code snippet below:

import groovy.json.*

def str = '''\
[
   {
      "items":{
         "number":1475175072691
      }
   },
   {
      "items":{
         "number":1475175072691
      }
   },
   {
      "items":{
         "number":1475175072691
      }
   },
   {
      "items":{
         "number":1475175072691
      }
   }
]'''

def json = new JsonSlurper().parseText(str)

json.each { 
  println JsonOutput.prettyPrint(JsonOutput.toJson(it))
}

The output displayed will be as follows:

{
    "items": {
        "number": 1475175072691
    }
}
{
    "items": {
        "number": 1475175072691
    }
}
{
    "items": {
        "number": 1475175072691
    }
}
{
    "items": {
        "number": 1475175072691
    }
}

To achieve this desired format, you must serialize and pretty print the json nodes accordingly.

Answer 2

Check out the code snippet below:

import groovy.json.*

def str = '''\
[
   {
      "items":{
         "number":1475175072691
      }
   },
   {
      "items":{
         "number":1475175072691
      }
   },
   {
      "items":{
         "number":1475175072691
      }
   },
   {
      "items":{
         "number":1475175072691
      }
   }
]'''

def json = new JsonSlurper().parseText(str)

json.each { 
  println JsonOutput.prettyPrint(JsonOutput.toJson(it))
}

The output displayed will be as follows:

{
    "items": {
        "number": 1475175072691
    }
}
{
    "items": {
        "number": 1475175072691
    }
}
{
    "items": {
        "number": 1475175072691
    }
}
{
    "items": {
        "number": 1475175072691
    }
}

To achieve this desired format, you must serialize and pretty print the json nodes accordingly.

Navigating JSON Data in Groovy Using a Loop: A Handy Guide

Answer №1

Similar questions

What is the best way to invoke a function from one controller in angularjs to another controller?

Unable to access the property '__reactAutoBindMap' as it is undefined

Guide to setting up Date Range Validator within MVC 4

Tips for stopping Vue.js automatic merging of CSS classes

Tips for clearing a saved password in a browser using Angular.js and Javascript

Leveraging data schemas to manage the feedback from APIs

Strange issue encountered when utilizing Worklight along with XSL transformation on a JSON response

When using express, encountering a "Cannot GET / on page refresh" error

There seems to be an issue with Node.js/Express: the page at /

Utilizing RxHttpClient in Micronaut to send a JSON body in a POST

Is there a more efficient method to select all the rows containing '1's in a specific cell within a large range of data?

Utilizing React and Material-UI to create an autocomplete feature for words within sentences that are not the first word

Having trouble accessing properties of an undefined object when trying to read 'credentials' in Firebase Auth within ReactJS

How to Dynamically Update Sass Styles with Webpack 2?

Ensuring that a service is completely initialized before Angular injects it into the system

What are the steps to successfully install OpenCV (javascript edition) on Internet Explorer 11?

Show a specific div using jQuery fadeIn() when the user reaches the top of an HTML section

Choose the offspring of an element using jQuery

The steps to triggering a button click after e.preventDefault()

Verify the functionality of a specific method invoked within another method through unit testing