How to check an array inside json data is empty using jmespath?

Question

I have json data as below:

[
  {
    "id": "i_1",
    "name": "abc",
    "address": [
      {
        "city": [
          "city1",
          "city2"
        ]
      },
      {
        "city": [
          "city1",
          "city2"
        ]
      }
    ]
  },
  {
    "id": "i_2",
    "name": "def",
    "address": [
      {
        "city": []
      },
      {
        "city": []
      }
    ]
  }
]

Now, I want only that data where city array is not null. So in the above example the output should be 1st element i.e. with id i_1.

How to filter this json using jmespath library?

Isha Padalia · Accepted Answer · 2019-01-28 09:59:53Z

5

You can do this:

var arr = [
  {
    "id": "i_1",
    "name": "abc",
    "address": [
      {
        "city": [
          "city1",
          "city2"
        ]
      },
      {
        "city": [
          "city1",
          "city2"
        ]
      }
    ]
  },
  {
    "id": "i_2",
    "name": "def",
    "address": [
      {
        "city": []
      },
      {
        "city": []
      }
    ]
  }
];

console.log(jmespath.search(arr,"[?not_null(address[].city[])]"));

<script src="https://cdnjs.cloudflare.com/ajax/libs/jmespath/0.15.0/jmespath.js"></script>

answered Jan 28, 2019 at 9:59

Isha Padalia

1,2321 gold badge11 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

adiga · Accepted Answer · 2019-01-28 08:40:45Z

0

You could do this in pure javascript using filter and every

const items=[{"id":"i_1","name":"abc","address":[{"city":["city1","city2"]},{"city":["city1","city2"]}]},{"id":"i_2","name":"def","address":[{"city":[]},{"city":[]}]}]

const filtered = items.filter(i => i.address.every(a => a.city && a.city.length > 0))

console.log(filtered)

This returns only if every object inside address has a non-empty city array.

edited Jan 28, 2019 at 8:40

answered Jan 28, 2019 at 8:32

adiga

35.4k9 gold badges65 silver badges88 bronze badges

3 Comments

Monarth Sarvaiya Over a year ago

I want to do this using jmespath, is there any way to do this using jmespath?

Nick Parsons Over a year ago

you could simplify this a little by changing a.city.length > 0 to just a.city.length

adiga Over a year ago

@MonarthSarvaiya I don't know, sorry. Just providing an alternative javascript solution.

Teocci · Accepted Answer · 2019-01-28 09:55:12Z

0

You don't need to use jmespath library use filter and `every from the vanilla JS. It is more efficient.

let jsonTxt = '{"data":[{"id":"i_1","name":"abc","address":[{"city":["city1","city2"]},{"city":["city1","city2"]}]},{"id":"i_2","name":"def","address":[{"city":[]},{"city":[]}]}]}'

let jsonData = JSON.parse(jsonTxt);
let items = jsonData.data;
const result = items.filter(i => i.address.every(a => a.city && a.city.length))
console.log('id: ', result[0].id);
//using jmespath
console.log(jmespath.search({data: items}, "data[*].address[*].city"));

<script src="https://cdnjs.cloudflare.com/ajax/libs/jmespath/0.15.0/jmespath.js"></script>

edited Jan 28, 2019 at 9:55

answered Jan 28, 2019 at 8:51

Teocci

9,3751 gold badge71 silver badges56 bronze badges

1 Comment

Monarth Sarvaiya Over a year ago

I am using other filters of jmespath, at this point I am stuck, so I want solution only using jmespath. Here is only some part of my code.

Collectives™ on Stack Overflow

How to check an array inside json data is empty using jmespath?

3 Answers 3

Comments

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related