Check if column exists in Nested JSON

Question

Below is my sample JSON

{
      "_id":{
         "$oid":"1564t8re13e4ter86"
      },
      "object":{
         "shop":"shop1",
         "domain":"Divers",
         "sell":[
            {
               "location":{
                  "zipCode":"58000",
                  "city":"NEVERS"
               },
               "properties":{
                  "description":"ddddd!!!!",
                  "id":"f1re67897116fre87"
               },
               "employee":[
                  {
                     "name":"employee1",
                     "id":"245975"
                  },
                  {
                     "name":"employee2",
                     "id":"458624"
                  }
               ],
               "customer":{
                  "name":"Customer1",
                  "custid":"test_réf"
               }
               "preference":"talking"
            }
         ]
      }
   }

In the above sample i would like to know if this particular column exists in the $.object.sell.preference exists , as in most cases it is not existing which is leading to failure.

Also i am good if there is any option i can set to get null or blank as return when using readcontext.read($...)

Thanks in Advance

Regards

You might want to use **JSONObject** to parse your json and use its `has(String key)`method to check if a key exists in this Json or not. If it does exists, just retrieve it and set it to the desired valued. — Amit kumar, Jul 23 '20 at 04:41

score 3 · Accepted Answer · answered Jul 23 '20 at 04:53

NOTE: I'm referring in java

Yes, it is possible to check using jsonObject.has() method. Suppose you have response variable in which you have full JSON

You can proceed it like this

 JSONObject jsonObject = new JSONObject(response);
 JSONArray jsonArray = jsonObject.getJSONObject("object").getJSONArray("sell");
 for (int i = 0; i < jsonArray.length(); i++) {
    JSONObject jsonObject1 = jsonArray.getJSONObject(i);
    if (jsonObject1.has("preference")) {
        //  Exist
    } else {
        //Not Exist
    }
 }

score 1 · Answer 2 · answered Jul 23 '20 at 04:43

1

try:

bool(json['object']['sell'][0]["preference"])

it will return false if empty and vice versa

answered Jul 23 '20 at 04:43

JaySabir

322
1
10

1

Hi @JaySabir - Let me try on the same. Thanks for the info. – Sam Berchmans Jul 23 '20 at 05:02
Hi , Can the column names be dynamically built to check ? – Sam Berchmans Jul 23 '20 at 14:48

Check if column exists in Nested JSON

2 Answers2