Discovering ways to verify if an array is empty within JSON data using JMESPath?

Question

Discovering ways to verify if an array is empty within JSON data using JMESPath?

I am presenting JSON data that looks like this:

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

My objective is to extract only the data where the city array is not empty. Based on the above example, the output should be the first element with an id of i_1.

Can you explain how the json can be filtered using the JMESPath library?

javascript json jmespath

Answer 1

Answer №1

Here is an example of how you can achieve this:

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

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

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

Answer 2

Here is an example of how you can achieve this:

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

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

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

Answer 3

Answer №2

If you want to achieve this using pure JavaScript, you can utilize the filter and every methods.

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 code snippet will only return objects where every item in the address array contains a non-empty city array.

Answer 4

If you want to achieve this using pure JavaScript, you can utilize the filter and every methods.

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 code snippet will only return objects where every item in the address array contains a non-empty city array.

Answer 5

Answer №3

To achieve the same result without relying on the jmespath library, you can utilize the filter and `every methods from vanilla JS, which tends to be more efficient.

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

let parsedData = JSON.parse(jsonData);
let dataItems = parsedData.data;
const filteredResult = dataItems.filter(item => item.address.every(addr => addr.city && addr.city.length))
console.log('id: ', filteredResult[0].id);
//jmespath alternative
console.log(jmespath.search({data: dataItems}, "data[*].address[*].city"));

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

Answer 6

To achieve the same result without relying on the jmespath library, you can utilize the filter and `every methods from vanilla JS, which tends to be more efficient.

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

let parsedData = JSON.parse(jsonData);
let dataItems = parsedData.data;
const filteredResult = dataItems.filter(item => item.address.every(addr => addr.city && addr.city.length))
console.log('id: ', filteredResult[0].id);
//jmespath alternative
console.log(jmespath.search({data: dataItems}, "data[*].address[*].city"));

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

Discovering ways to verify if an array is empty within JSON data using JMESPath?

Answer №1

Answer №2

Answer №3

Similar questions

Direct the /username path to /[user]/[tab].js instead of [user]/index.js in Next.js

Information is only displayed within the Node Request function and is not accessible to

Matching Tables with JavaScript and JSON

Is there a method in Angular to refresh or recompile a specific section or entire page that utilizes one-time bindings?

Incorporating PHP generated content into Dart without using Ajax

The process of obtaining HTML input using JavaScript

Utilizing Jquery to interchange two values and update styling

Accessing a child component's method within a parent component by making a call to it

Using jQuery to toggle the visibility of HTML elements

How to decode and access a nested JSON array in Swift: A guide

What is the most efficient method to import multiple MaterialUI components using a shared namespace without requiring the entire library to be imported

What is the best way to send an HttpPost request to a RESTful web service in order to transmit a URL with parameters that contains an array of values?

Converting Object to XML without the need for [xmlns=""]

Can you explain the meaning of the code provided below?

Encountered a TypeError in React 16.7: The function (0, _react.useState) is not recognized

When using async functions in iterative processes

Sort an array by mapping it in decreasing order based on the total sum of its elements

Decoding JSON data into Enum fields

Abort S3 file upload using ASW-SDK

Modify the color scheme of the Highcharts Maps to display a range of colors according to the minimum and maximum values