json - Fetch non-array objects in collection with certain value - Stack Overflow

admin管理员组

文章数量:1399989

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": []
  }
}

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": []
  }
}

• json
• jsonata

Share Improve this question Follow edited Mar 24 at 17:25 jonrsharpe 122k3030 gold badges268268 silver badges475475 bronze badges asked Mar 24 at 17:23 L SzijL Szij 111 bronze badge

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 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/playground/f5648325

Option 2

$.*[type="array"]

The output will look like:

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

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

本文标签： jsonFetch nonarray objects in collection with certain valueStack Overflow