How can I get unique values in array in a jmespath query?

Question

In an aws cli jmespath query, with for example the output ["a","a","b","a","b"], how do i extract the unique values of it to get ["a","b"]?

score 11 · Accepted Answer · answered May 05 '16 at 17:49

11

Unfortunately this is not currently possible in jmespath.

answered May 05 '16 at 17:49

Jordon Phillips

1

I would argue that jmespath is grep, not gawk. It just provides a selection of data. That is it's job. Processing json is someone else's business! :-) Now what that other tool should be is another question and I think the answer depends on context. – Max Murphy Feb 07 '17 at 12:41

score 3 · Answer 2 · answered Mar 05 '20 at 22:59

3

It's not what you asked for but I've used the following:

aws ... | jq -r ".[]" | sort | uniq

This will convert ["a", "a", "b", "a"] to:

a
b

answered Mar 05 '20 at 22:59

mekazu

2 Answers2