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

Sentry: Easily upload source maps from a nested directory structure

What is the best way to display images one by one from a map using a random fade effect?

Only the initial submission is allowed when submitting forms using jQuery $.ajax

Is there a way to invoke an Angular2 function from within a Google Map infowindow?

Modify the onerror function of the image tag within the onerror function

Listen for the 'open' event on a node HTTP server

Ways to display all current users on a single page within an application

Iterate over a list of strings and convert them into key-value pairs in JSON format using Python

Using Javascript within a PHP file to generate JSON output

Encountering a problem while deserializing a JSON response from Stripe

Securing Your Content - Preventing Users from Right-Clicking and Using F12 on Your Website

Sorting arrays can yield varying results depending on the browser being used

The <br/> tag is not functioning properly when retrieving text from a MySQL query

What location is most ideal for incorporating JavaScript/Ajax within a document?

Angular JS failing to display error messages

What is the best method for obtaining a JSON string from a URL?

Troubleshooting Problem with ListItem Alignment in Material UI v0 involving Custom Avatar Component

The 'userEvent.type' function in React Testing Library is failing to update the input value in a Material UI TextField component that has

What is the correct way to format responses written within response.write() in NodeJS?

How can I export an ES Object in Node.JS to an NPM package?