Working with JSON in accelQ

This article helps you understand various JSON processing and verification commands available in accelQ along with some examples. For various commands in accelQ, JSON node is specified in the standard JSON path format.

We will use the following sample JSON file content for the examples:

{
   "store":{

     "book":[
     {
       "category":"reference",
       "author":"Nigel Rees",
       "title":"Sayings of the Century",
       "price":8.95
     },
     {
       "category":null,
       "author":"Evelyn Waugh",
       "title":"Sword of Honour",
       "price":12.99
     }
     ],

     "bicycle":{
       "color":"red",
       "price":19.95
     }
   }
}

Reading a JSON node 

Get JSON Node value

Gets node value from JSON for the given JSON node path . The return value can be any json data type like JSON object, array, string, etc..

 JSON path
 
 JSON content
 
 Returns

 JSON node path to retrieve value
 
 JSON content to retrieve node value from
 
 JSON node value

Get JSON Array size

Gets JSON Array size from JSON content at given array node.

JSON content

JSON path

Returns

JSON content

JSON node path to get array size

JSON Array size from JSON content at given node

Validating JSON nodes

Verify JSON Node exists

Verifies node exists in given JSON content.

JSON path

JSON content

failure action

JSON node path

JSON content to verify node exists

whether to abort or continue the test if the verification fails

Verifies node value in given JSON content matches expected value.

JSON content

JSON path

expected value

comparison type

match type

failure action
 

JSON content

JSON node path

expected value

select matching option (equals, contains)

select case sensitivity option (ignore case, match case, regex pattern)

continue or abort test case
 

Is JSON Node value NULL

Enquires if node value is null from JSON content for the given node.

json content

json node path

Returns

JSON content

JSON node path

true or false

Verify JSON Array size Is

Verifies JSON Array size equals expected count from JSON content at given node.

json content

json node path

node count

failure action

JSON content

JSON node path

expected node count

continue or abort test case

Updating JSON Content

Set Value For JSON Property

Updates value for JSON property at given JSON path.

JSON content

Path

Value

JSON content

JSON node path

Value to be updated for property

Add New JSON Property

json content

json node path

property

value

Returns

JSON content

JSON node path

new property to be added

property value

JSON content with newly added JSON property

Add Item to JSON Array

json content

json array path

item

Returns

JSON content

JSON array path

item to be inserted

Updated JSON content

Log JSON Value

Prints a given JSON content in report, in a structured tree format.

parameter

prefix

JSON content to print

prefix, to appear in the report message