Feature: Validations : JSON manipulation

Testing JSON object key deletion and extraction

Scenarios

Chart

Status

Progress

Passed	100.00 %
Failed	0.00 %

Total duration:

00:00:00.013

Metadata

Device Local test machine
OS 4.15.0-140-generic

Scenario: Readme simple extract Example

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

When set "response" to 00:00:00.001

+ Show Info

{
  "response": {
    "error": {
      "subErrorCodes": [
        {
          "subErrorCode": 1101,
          "subErrorMessage": "Phone Number is required"
        }
      ]
    },
    "doesnotexist": null
  }
}

        {
          "error": {
            "subErrorCodes": [
              {
                "subErrorCode": 1101,
                "subErrorMessage": "Phone Number is required"
              }
            ]
          },
          "doesnotexist": null
        }

When JSON key "subErrorCodes" is extracted from "response.error" 0s

+ Show Info

{
  "lastRun": [
    {
      "subErrorCode": 1101,
      "subErrorMessage": "Phone Number is required"
    }
  ]
}

When JSON key "doesnotexist" is extracted from "response.error" 0s

+ Show Info

{}

When set "Data" to 0s

+ Show Info

{
  "Data": {
    "a": "apple",
    "b": "banana"
  }
}

{
    "a":"apple",
    "b":"banana"
}

Then element "a" exists in item "Data" 00:00:00.001

When JSON key "a" is extracted from "Data" 0s

+ Show Info

{
  "lastRun": "apple"
}

Then it is equal to "apple" 00:00:00.001

Scenario: Readme simple removal Example

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

When set "Data" to 00:00:00.001

+ Show Info

{
  "Data": {
    "a": "apple",
    "b": "banana"
  }
}

{
    "a":"apple",
    "b":"banana"
}

And elements '["a", "b"]' exist in item "Data" 0s

And elements 'a, b' exist in item "Data" 0s

When JSON key "a" is removed from "Data" 0s

+ Show Info

{
  "lastRun": {
    "b": "banana"
  }
}

Then "${Data.b}" is equal to "banana" 0s

And element "a" does not exist in item "Data" 00:00:00.001

And elements '[c,d]' do not exist in item "Data" 0s

Scenario: JSON Key Deletion

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

When set "TestJSON" to 00:00:00.001

+ Show Info

{
  "TestJSON": {
    "url": "http://google.com",
    "meh": "Test",
    "meh2": "Another Test",
    "deepMeh": {
      "deep1": "Testing1",
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3",
      "deep4": "Testing4"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

{
"url": "http://google.com",
"meh": "Test",
"meh2": "Another Test",
"deepMeh": {
    "deep1": "Testing1",
    "deep2": "Testing2"
},
"deepMeh2": {
    "deep3": "Testing3",
    "deep4": "Testing4"
},
"arrayTest": [
    "Testing1",
    "Testing2",
    "Testing3"
]
}

And JSON key "meh" is removed from item "TestJSON" 0s

+ Show Info

{
  "lastRun": {
    "url": "http://google.com",
    "meh2": "Another Test",
    "deepMeh": {
      "deep1": "Testing1",
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3",
      "deep4": "Testing4"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

And set "lastRun" to item "TestJSON" 0s

+ Show Info

{
  "lastRun": {
    "url": "http://google.com",
    "meh2": "Another Test",
    "deepMeh": {
      "deep1": "Testing1",
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3",
      "deep4": "Testing4"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

And JSON key "deepMeh.deep1" is removed from it 00:00:00.001

+ Show Info

{
  "lastRun": {
    "url": "http://google.com",
    "meh2": "Another Test",
    "deepMeh": {
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3",
      "deep4": "Testing4"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

Scenario: JSON Key Extraction

When set "directory" to "./test" 00:00:00.001

+ Show Info

{
  "directory": "./test"
}

When set "TestJSON" to 0s

+ Show Info

{
  "TestJSON": {
    "url": "http://google.com",
    "meh": "Test",
    "meh2": "Another Test",
    "deepMeh": {
      "deep1": "Testing1",
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3",
      "deep4": "Testing4"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

{
"url": "http://google.com",
"meh": "Test",
"meh2": "Another Test",
"deepMeh": {
    "deep1": "Testing1",
    "deep2": "Testing2"
},
"deepMeh2": {
    "deep3": "Testing3",
    "deep4": "Testing4"
},
"arrayTest": [
    "Testing1",
    "Testing2",
    "Testing3"
]
}

When set "newJSON" to item "TestJSON" 0s

+ Show Info

{
  "newJSON": {
    "url": "http://google.com",
    "meh": "Test",
    "meh2": "Another Test",
    "deepMeh": {
      "deep1": "Testing1",
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3",
      "deep4": "Testing4"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

When JSON key "arrayTest[0]" is extracted from item "newJSON" 0s

+ Show Info

{
  "lastRun": "Testing1"
}

When JSON key "deepMeh" is extracted from item "TestJSON" 00:00:00.001

+ Show Info

{
  "lastRun": {
    "deep1": "Testing1",
    "deep2": "Testing2"
  }
}

And JSON keys '["meh","deepMeh","deepMeh2.deep3", "arrayTest"]' are extracted from item "TestJSON" 0s

+ Show Info

{
  "lastRun": {
    "meh": "Test",
    "deepMeh": {
      "deep1": "Testing1",
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

And JSON key "deep2" is extracted from it 0s

+ Show Info

{}

And JSON keys 'meh,deepMeh,deepMeh2.deep3, arrayTest]' are extracted from item "TestJSON" 00:00:00.001

+ Show Info

{
  "lastRun": {
    "meh": "Test",
    "deepMeh": {
      "deep1": "Testing1",
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

And set "expected" to 0s

+ Show Info

{
  "expected": {
    "meh": "Test",
    "deepMeh": {
      "deep1": "Testing1",
      "deep2": "Testing2"
    },
    "deepMeh2": {
      "deep3": "Testing3"
    },
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

{
    "meh": "Test",
    "deepMeh": {
    "deep1": "Testing1",
    "deep2": "Testing2"
    },
    "deepMeh2": {
    "deep3": "Testing3"
    },
    "arrayTest": [
    "Testing1",
    "Testing2",
    "Testing3"
    ]
}

Then item "expected" is equal to item "lastRun" 0s

Scenario: JSON Key Lowercase

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

When set "data" to: 00:00:00.001

+ Show Info

{
  "data": {
    "alreadylower": "lower",
    "Alpha": "apple",
    "BETA": "Banana",
    "Charley": {
      "Coconut": "Hierarchy"
    }
  }
}

{
"alreadylower": "lower",
"Alpha": "apple",
"BETA": "Banana",
"Charley": { "Coconut": "Hierarchy"}
}

When make json keys for item "data" lower case 0s

+ Show Info

{
  "alreadylower": "lower",
  "alpha": "apple",
  "beta": "Banana",
  "charley": {
    "coconut": "Hierarchy"
  }
}

Then item "data" is equal to: 0s

{
"alreadylower": "lower",
"alpha": "apple",
"beta": "Banana",
"charley": { "coconut":  "Hierarchy" }
}

Scenario: JSON Key Lowercase

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

When set "data" to: 0s

+ Show Info

{
  "data": {
    "Alpha": "apple",
    "BETA": "Banana",
    "Charley": "coconut"
  }
}

{
"Alpha": "apple",
"BETA": "Banana",
"Charley": "coconut"
}

When make json keys for item "data" lower case 0s

+ Show Info

{
  "alpha": "apple",
  "beta": "Banana",
  "charley": "coconut"
}

Then item "data" is equal to: 0s

{
"alpha": "apple",
"beta": "Banana",
"charley": "coconut"
}

Scenario: JSON Numberify

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

When set "data" to: 0s

+ Show Info

{
  "data": {
    "Alpha": "123",
    "Beta": {
      "Beta_21": "456",
      "Beta_22": "some_word"
    },
    "Charley": {
      "Charley_21": "45.6",
      "Charley_22": 24.9
    },
    "Delta": "1.2.3"
  }
}

{
"Alpha": "123",
"Beta": {
    "Beta_21": "456",
    "Beta_22": "some_word"
    },
"Charley": {
    "Charley_21": "45.6",
    "Charley_22": 24.9
    },
"Delta": "1.2.3"
}

When json item "data" is numberifyed 0s

+ Show Info

{
  "Alpha": 123,
  "Beta": {
    "Beta_21": 456,
    "Beta_22": "some_word"
  },
  "Charley": {
    "Charley_21": 45.6,
    "Charley_22": 24.9
  },
  "Delta": "1.2.3"
}

Then item "data" is equal to: 0s

{
"Alpha": 123,
"Beta": {
  "Beta_21": 456,
  "Beta_22": "some_word"
    },
"Charley": {
  "Charley_21": 45.6,
  "Charley_22": 24.9
    },
"Delta": "1.2.3"
}

Scenario: JSON Trim

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

When set "data" to: 00:00:00.001

+ Show Info

{
  "data": {
    "Alpha": {
      "Alpha_2": "Apple   "
    },
    "John": 5,
    "Beta": "_Banana_",
    "Charley": "Spaces are kept in between words",
    "Delta": {
      "Delta_21": "   But spaces at the beginning and end are removed   ",
      "Delta_22": "\nSo are new lines\n"
    }
  }
}

{
"Alpha": {
    "Alpha_2": "Apple   "
    },
    "John": 5,
"Beta": "_Banana_",
"Charley": "Spaces are kept in between words",
"Delta": { 
    "Delta_21" : "   But spaces at the beginning and end are removed   ",
    "Delta_22" : "\nSo are new lines\n"
    }
}

When json item "data" is trimmed 0s

+ Show Info

{
  "Alpha": {
    "Alpha_2": "Apple"
  },
  "John": 5,
  "Beta": "_Banana_",
  "Charley": "Spaces are kept in between words",
  "Delta": {
    "Delta_21": "But spaces at the beginning and end are removed",
    "Delta_22": "So are new lines"
  }
}

Then item "data" is equal to: 00:00:00.001

{
"Alpha": {
  "Alpha_2": "Apple"
},
                "John": 5,
"Beta": "_Banana_",
"Charley": "Spaces are kept in between words",
"Delta": {
  "Delta_21": "But spaces at the beginning and end are removed",
  "Delta_22": "So are new lines"
    }
}

Scenario: JSON Flatten

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

When set "data" to: 0s

+ Show Info

{
  "data": {
    "Alpha": {
      "Alpha_2": "Apple"
    },
    "Beta": "Banana",
    "Charley": {
      "Charley_2": {
        "Charley_3": "Coconut"
      }
    },
    "Delta": {
      "Delta_21": "Durian1",
      "Delta_22": "Durian2"
    }
  }
}

{
"Alpha": {
    "Alpha_2": "Apple"
    },
"Beta": "Banana",
"Charley": {
    "Charley_2": {
        "Charley_3": "Coconut"
        }
    },
"Delta": { 
    "Delta_21" : "Durian1",
    "Delta_22" : "Durian2"
    }
}

When json item "data" is flattened 0s

+ Show Info

{
  "Alpha_2": "Apple",
  "Beta": "Banana",
  "Charley_3": "Coconut",
  "Delta_21": "Durian1",
  "Delta_22": "Durian2"
}

Then item "data" is equal to: 0s

{
"Alpha_2": "Apple",
"Beta": "Banana",
"Charley_3": "Coconut",
"Delta_21": "Durian1",
"Delta_22": "Durian2"
}

Scenario: Example for json path

When set "directory" to "./test" 0s

+ Show Info

{
  "directory": "./test"
}

Given set "meh" to: 0s

+ Show Info

{
  "meh": {
    "url": "http://google.com",
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

{
  "url": "http://google.com",
  "arrayTest": [
    "Testing1",
    "Testing2",
    "Testing3"
  ]
}

And set "expected" to: 0s

+ Show Info

{
  "expected": {
    "url": null,
    "arrayTest": [
      "Testing1",
      "Testing2",
      "Testing3"
    ]
  }
}

{
  "url": null,
  "arrayTest": [
    "Testing1",
    "Testing2",
    "Testing3"
  ]
}

When "null" is applied to item "meh" on JSON path "$.url" 0s

+ Show Info

{
  "url": null,
  "arrayTest": [
    "Testing1",
    "Testing2",
    "Testing3"
  ]
}

Then item "expected" is equal to item "meh" 0s

When "" is applied to item "meh" on JSON path "$.url" 0s

+ Show Info

{
  "url": "",
  "arrayTest": [
    "Testing1",
    "Testing2",
    "Testing3"
  ]
}