Validating Json array using java script

🙋 Help
, ,
1

Hi guys need help in validating the json response. I need to validate the json array values and if atleast one value > specific condition my script should pass. below is the json

[
  {
    "batch_id": xxxxxxx,
    "last_revision_id": xxxxxxx,
    "priority": "xxxxxxx",
    "name": "xxxxxxxx",
    "items": 14,
    "print_by": "xxxxxxx",
    "created": "2xxxxxxx0",
    "jsactions": [
      {
        "label": "xxxxxxx",
        "action": "xxxxxxx",
        "icon": "xxxxxxxx"
      },
      {
        "label": "xxxxxxx",
        "action": "xxxxxx-xxxxx",
        "icon": "xxxxxxxx",
		}
    ],
    "disappear_date": fgfgh,
    "filtered_by_default_tags": fhfghg,
    "assignments": 0,
    "undeletable_assignments": gggfh
  },
  {
    "batch_id": xxxxxxx,
    "last_revision_id": xxxxxxx,
    "priority": "xxxxxxx",
    "name": "xxxxxxxx",
    "items": 5456,
    "print_by": "xxxxxxx",
    "created": "2xxxxxxx0",
    "jsactions": [
      {
        "label": "xxxxxxx",
        "action": "xxxxxxx",
        "icon": "xxxxxxxx"
      },
      {
        "label": "xxxxxxx",
        "action": "xxxxxx-xxxxx",
        "icon": "xxxxxxxx",
		}
    ],
    "disappear_date": fgfgh,
    "filtered_by_default_tags": fhfghg,
    "assignments": 0,
    "undeletable_assignments": gggfh
  }
    
]

I used normal if condition using javascript but it is not validating properly

var jsonData = JSON.parse(responseBody);
if (responseBody.has("items")) {
   if(jsonData[0].items >=300){
   tests["Is atleast one of the batch in future >=300"] = responseBody.has("items");
}
}
else {
    tests["The batch is empty"] = responseBody.has("njmkhkhull");
}

But the test getting passed irrespective of the values present in the json array. Even if the json value is 10 if i give the condition as >=30000 it is showing the test as passed.

I used the _.each(pm.response.json(), (arrItem) => function it is working fine but this method is not suited for my result analysis as it validates all the array elements.

My desired condition is even if one among the array values satisfies the condition test case should be passed. so that only one value will be logged in console either in case of pass or fail. In case of .each it is logging for all the array values and its cumbersome

please help on this

2

Hey @aravaws,

Are you able to provide an example of the structure of your response, please?

You can just paste an example of the JSON here rather than an image. Mask or add dummy values for any sensitive information.

This will help users to run things locally and help provide a solution quicker. :smiley:

3 
[
  {
    "batch_id": xxxxxxx,
    "last_revision_id": xxxxxxx,
    "priority": "xxxxxxx",
    "name": "xxxxxxxx",
    "items": 14,
    "print_by": "xxxxxxx",
    "created": "2xxxxxxx0",
    "jsactions": [
      {
        "label": "xxxxxxx",
        "action": "xxxxxxx",
        "icon": "xxxxxxxx"
      },
      {
        "label": "xxxxxxx",
        "action": "xxxxxx-xxxxx",
        "icon": "xxxxxxxx",
		}
    ],
    "disappear_date": fgfgh,
    "filtered_by_default_tags": fhfghg,
    "assignments": 0,
    "undeletable_assignments": gggfh
  },
  {
    "batch_id": xxxxxxx,
    "last_revision_id": xxxxxxx,
    "priority": "xxxxxxx",
    "name": "xxxxxxxx",
    "items": 5456,
    "print_by": "xxxxxxx",
    "created": "2xxxxxxx0",
    "jsactions": [
      {
        "label": "xxxxxxx",
        "action": "xxxxxxx",
        "icon": "xxxxxxxx"
      },
      {
        "label": "xxxxxxx",
        "action": "xxxxxx-xxxxx",
        "icon": "xxxxxxxx",
		}
    ],
    "disappear_date": fgfgh,
    "filtered_by_default_tags": fhfghg,
    "assignments": 0,
    "undeletable_assignments": gggfh
  }
    
]
4

You could use something like this to loop through and filter the objects that contain items greater than 300. It will create an array that you can assert against the length of to see if it’s above 1.

I’ve added in a custom error string that shows you why it failed.

pm.test('Is atleast one of the batch in future >=300', () => {
    let result = pm.response.json().filter(arr => arr.items >= 300)
    pm.expect(result.length).to.be.above(1, `Objects matching condition ${result.length}`)
})

This will give you an idea of other assertions that could be made in the pm.expect() statements:

https://www.chaijs.com/api/bdd/

5

Thanks a lot I will try and let you know

6

Hi I finally found the desired solution for this. I have used plain Java-script code for this and it worked. I have saved all the items values in to an array and then validated all the array elements at once against a single condition like >=50. It works perfectly and below is the code for it

var jsonData = JSON.parse(responseBody);
var data = [ ];
for(var i in jsonData){
data.push(jsonData[i].items);

}
//console.log(data);
if (data.length>1 && data[0].items!=0){
const isLargeNumber = (data) => data >= 1000;
//console.log(data.findIndex(isLargeNumber));

if (data.findIndex(isLargeNumber)>=0){
tests[“Is atleast one of the batch in Due Today >=3000”] = responseBody.has(“items”);
}
else{
tests["No batch in Due Today has value >= 3000 "] = responseBody.has(“t#3%$&*4435”);
console.log(“L_Due_Today”, pm.variables.get(“Store_number2”));
}
}
else{
tests[“The batch is empty”] = responseBody.has(“hfgh546”);
console.log(“L_EMPTY_Today”,pm.variables.get(“Store_number2”));
}