Groovy script, handle hyphen
Hello team, Working on groovy script to compare Json response format to SQL script values . created a hashmap object and when trying to loop through the reponse object based on a attribute whi...
Forum Discussion
Hello, hyphen in a json node is tricky but you can overcome this by enclosing that node in a square brackets([])
for ex:
I have saved your Json response in a file and I am reading it from there.
import net.sf.*
import net.sf.json.*
import net.sf.json.groovy.*
import groovy.json.JsonSlurper
import groovy.io.FileType
log.info "Parsing JSON payload..."
//## READ canned request from a file to modify ##//
def MyJSON = new File("C:\\TestFolder\\SampleJson.txt").text
def JsonNodes = new JsonSlurper().parseText MyJSON
log.info JsonNodes.data[0]["lab-term"]
hope this helps!
