projection from the filtering result of an array using jsonata

Question

I am interested in using jsonata to filter my json results, which is an array. I can use $[predicate] to filter the array, but how can I output the selected keys in each object? which means, to do project operations on each object in the result array?

Here is an example -

input:

[
  {
    "a": 1,
    "b": 2,
    "c": 3
  },
  {
    "a": 5,
    "b": 6,
    "c": 7
  }
]

expected result of selecting only a and c:

[
  {
    "a": 1,
    "c": 3
  },
  {
    "a": 5,
    "c": 7
  }
]

ray · Accepted Answer · 2021-10-12 10:58:41Z

1

You can use this,

$ ~> |$|{}, ['b']|

here is simple demo

answered Oct 12, 2021 at 10:58

ray

1,6906 silver badges11 bronze badges

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

2 Comments

Zhang Wei Over a year ago

Thanks, it works. Two follow ups, firstly is the any document that explains the operators used in this example; Secondly, this doesn't seem graceful since it's by remove instead of select, what if I have so many keys, and I want to select a few specific keys? should I list all the keys that should be removed? Thanks.

Andrew Coleman Over a year ago

1) docs.jsonata.org/other-operators 2) $.{ 'a': a, 'b': b }

Collectives™ on Stack Overflow

projection from the filtering result of an array using jsonata

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related