Fetch non-array objects in collection with certain value

Question

Given a collection (not an array) like this:

{
  "field1": {
    "type": "string",
    "value": "test"
  },
  "field2": {
    "type": "array",
    "value": []
  },
  "field3": {
    "type": "string",
    "value": "test"
  },
  "field4": {
    "type": "array",
    "value": []
  }
}

how do I end up with just (filtering on type="array"):

{
  "field2": {
    "type": "array",
    "value": []
  },
  "field4": {
    "type": "array",
    "value": []
  }
}

Vlad Dimov · Accepted Answer · 2025-03-25 10:19:19Z

0

The JSONata wildcard operator will select the values of all fields in the context object.

Option 1

$map($spread($), function($x){
  $x.*.type = 'array' ? {
    $keys($x): $x.*
  }
})

JSONata Playground: https://jsonatastudio.com/playground/f5648325

Option 2

$.*[type="array"]

The output will look like:

[
  {
    "type": "array",
    "value": []
  },
  {
    "type": "array",
    "value": []
  }
]

JSONata Playground: https://jsonatastudio.com/playground/3007924a

edited Mar 25 at 10:19

answered Mar 25 at 8:50

Vlad Dimov

2062 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

Fetch non-array objects in collection with certain value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related