Forum Discussion

nkpalli's avatar
nkpalli
Contributor
6 years ago
Solved

How to delete a key value pair from JSON response, goovy script

I have a groovy which basically make a rest request  as below sample and returns JSON response. but in the response returned  i would like to remove a key value pair(IsEditable = true)  before i star...
  • Radford's avatar
    Radford
    6 years ago

    The JsonSlurper returns Maps and Lists, thus with your second example you need to loop through each List item, which in turn is a Map and remove the item from each, for example:

     

    import groovy.json.JsonSlurper

def Response = '''\
[{
 "PVOptions" : "Yes, No",
 "UCount" : 449,
 "PName" : "Affordable Price All",
 "IsEdit" : true,
 "PCode" : "1234",
 "PPId" : 984,
 "IPNullable" : false
},
{
 "PVOptions" : "Yes, No",
 "UCount" : 4495,
 "PName" : "Affordable Price All",
 "IsEdit" : true,
 "PCode" : "12345",
 "PPId" : 984,
 "IPNullable" : false
}]
'''

def slurperResponse = new JsonSlurper().parseText(Response)
log.info("API Response results:" +  slurperResponse.toString())

slurperResponse.each(){ dataSet ->
	dataSet.remove('IsEdit')
}

log.info("API Response results:" +  slurperResponse.toString())
Radford's avatar
Radford
Super Contributor

The following is a standalone example of how to delete an entry, based on your response data above:

 

import groovy.json.JsonSlurper

def Response = '''\
{
	"PVOptions" : "Yes, No",
	"UCount" : 449,
	"PName" : "Affordable Price All",
	"IsEdit" : true,
	"PCode" : "1234",
	"PPId" : 984,
	"IPNullable" : false
}'''

def slurperResponse = new JsonSlurper().parseText(Response)
log.info("API Response results:" +  slurperResponse.toString())

// slurperResponse is a Map, thus we call the remove method with the desired map entry key.
slurperResponse.remove('IsEdit');
log.info("API Response results:" +  slurperResponse.toString())

[Edit: Removed an extraneous space from the script] 

nkpalli's avatar
nkpalli
Contributor
6 years ago

Thank you for direction .... I tried the groovy script and it works when JSON has single node  but if JSON  response sample has  mulitple nodes and we need to remove ISEDIT from all nodes ..solution seems to be not working  .  can you provide sample for removing key in this case 

 

Here below is example of groovy script i tried  with multiple nodes

 

 

 

import groovy.json.JsonSlurper
def Response = '''\
[{
 "PVOptions" : "Yes, No",
 "UCount" : 449,
 "PName" : "Affordable Price All",
 "IsEdit" : true,
 "PCode" : "1234",
 "PPId" : 984,
 "IPNullable" : false
},
{
 "PVOptions" : "Yes, No",
 "UCount" : 4495,
 "PName" : "Affordable Price All",
 "IsEdit" : true,
 "PCode" : "12345",
 "PPId" : 984,
 "IPNullable" : false
}]
'''
def slurperResponse = new JsonSlurper().parseText(Response)
log.info("API Response results:" +  slurperResponse.toString())
// slurperResponse is a Map, thus we call the remove method with the desired map entry key.
slurperResponse.remove('IsEdit');
log.info("API Response results:" +  slurperResponse.toString())
 
Result set returned :
 
[[IPNullable:false, IsEdit:true, PCode:1234, PName:Affordable Price All, PPId:984, PVOptions:Yes, No, UCount:449], [IPNullable:false, IsEdit:true, PCode:12345, PName:Affordable Price All, PPId:984, PVOptions:Yes, No, UCount:4495]]
 
  • Radford's avatar
    Radford
    Super Contributor
    6 years ago

    The JsonSlurper returns Maps and Lists, thus with your second example you need to loop through each List item, which in turn is a Map and remove the item from each, for example:

     

    import groovy.json.JsonSlurper

def Response = '''\
[{
 "PVOptions" : "Yes, No",
 "UCount" : 449,
 "PName" : "Affordable Price All",
 "IsEdit" : true,
 "PCode" : "1234",
 "PPId" : 984,
 "IPNullable" : false
},
{
 "PVOptions" : "Yes, No",
 "UCount" : 4495,
 "PName" : "Affordable Price All",
 "IsEdit" : true,
 "PCode" : "12345",
 "PPId" : 984,
 "IPNullable" : false
}]
'''

def slurperResponse = new JsonSlurper().parseText(Response)
log.info("API Response results:" +  slurperResponse.toString())

slurperResponse.each(){ dataSet ->
	dataSet.remove('IsEdit')
}

log.info("API Response results:" +  slurperResponse.toString())
    • nkpalli's avatar
      nkpalli
      Contributor
      6 years ago

      Thank you ! This works