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

I successfully merged two arrays (decks of cards) without using recursion, but I'm curious to understand where I went wrong with the recursive approach

worldpay implements the useTemplateForm callback function

Issue with Django div reloading: Using ajax GET after POST does not fetch the most recent database model instances

Error retrieving content from website: Failed to connect to http://roblox.plus:2052/limiteds

Encountering difficulties with displaying error messages on the Material UI datepicker

Callback function triggered upon the creation of a DOM node

Error TS2307: Module 'calculator' could not be located

transforming JSON data into an array format on the fly

issue with integrating promise in angular 4

Uncover the valuable information within a string using regex in JavaScript

Transform the size and convert an object from a picture into text based on the user's scrolling

Developing tests for an asynchronous function

How come jQuery is retaining the original DOM element classes even after I have modified them using jQuery?

Creating models or bulk creating promises in a seed file

In my Express Javascript application, I recently encountered a challenge where I needed to export a const outside of another

After signing out, the function getRedirectResult in Firebase is being invoked

The Dropdownlist jQuery is having trouble retrieving the database value

Display PDF blob in browser using an aesthetically pleasing URL in JavaScript

What methods does Enzyme have for determining the visibility of components?

Tips for wrapping a function call that may occasionally involve asynchronous behavior to ensure it runs synchronously