How to count items in JSON object using command line?

Question

I'm getting this kind of JSON reply from a curl command:

[
  {
    "cid": 49,
    "pyn": "yi4",
    "hans": "亿",
    "hant": "億",
    "tid": 68,
    "l10n": "cent million",
    "pid": 1,
    "pos": "num",
    "pos_txt": ""
  },
  {
    "cid": 50,
    "pyn": "yi4",
    "hans": "亿",
    "hant": "億",
    "tid": 69,
    "l10n": "100 millions",
    "pid": 1,
    "pos": "num",
    "pos_txt": ""
  }
]

How can I count the number of items in the array (here 2), using Bash or a command line (e.g. underscore) ?

Is JavaScript solution, okay for you? – thefourtheye Jan 24 '14 at 13:51 — thefourtheye, Jan 24 '14 at 13:51
Through `NPM` module yes. Otherwise, no. – Édouard Lopez Jan 24 '14 at 13:53 — Édouard Lopez, Jan 24 '14 at 13:53
Check my solution. That needs no npm. Plain JavaScript. – thefourtheye Jan 24 '14 at 13:55 — thefourtheye, Jan 24 '14 at 13:55
I'm in a bash context, not web – Édouard Lopez Jan 24 '14 at 13:59 — Édouard Lopez, Jan 24 '14 at 13:59
You know that you can execute JavaScript in shell, right? – thefourtheye Jan 25 '14 at 03:39 — thefourtheye, Jan 25 '14 at 03:39

score 533 · Accepted Answer · edited Sep 25 '18 at 19:59

533

Just throwing another solution in the mix...

Try jq, a lightweight and flexible command-line JSON processor:

jq length /tmp/test.json

Prints the length of the array of objects.

edited Sep 25 '18 at 19:59

peak

88,177
15
123
150

answered Jan 25 '14 at 19:50

Ken

6,887
1
19
20

4

Your initial `jq` code (`.[]`) return the length of each `object` in the root array, while I'm looking for the length of the root array itself. Need to fix to `.` – Édouard Lopez Jan 26 '14 at 09:52
33

If your root is not an array but an object with a key that contains an array, i.e. { "key": [elem1, elem2] } , then you can use use `jq '.[] | length' file.json` – Alex Bitek Jan 27 '15 at 15:10
2

Another useful option for that @MnemonicFlow is `jq map_values(length) file.json` . That will give you the keys as well. – Paulo Casaretto Dec 09 '16 at 19:06
11

And if your input is made of independent objects instead of a single array, you'd use the `-s` or `--slurp` option, which collects them into an array while reading: `jq -s length file.json` – hemflit Jul 02 '18 at 10:34
`. | ` is not required, `jq 'length' ... ` is enough – ssc Sep 02 '18 at 14:39
@bitek Either I understood you wrong, or you're mistaken. `echo '{"key":[1,"asdf"]}' | jq '.[] | length'` gives an error. What produces expected result to me is `echo '{"key":[1,"asdf"]}' | jq '.key | length'`. – x-yuri Sep 30 '18 at 01:39

score 74 · Answer 2 · edited Mar 31 '16 at 11:21

74

The shortest expression is

curl 'http://…' | jq length

edited Mar 31 '16 at 11:21

Édouard Lopez

36,430
24
114
170

answered Mar 31 '16 at 10:21

nikolay

2,366
20
13

score 48 · Answer 3 · edited Jul 16 '21 at 17:47

48

You can also use jq to track down the array within the returned json and then pipe that in to a second jq call to get its length. Suppose it was in a property called records, like {"records":[...]}.

$ curl https://my-source-of-json.com/list | jq -r '.records | length'
2
$

edited Jul 16 '21 at 17:47

Mr. Lance E Sloan

2,970
5
31
48

answered Sep 21 '20 at 19:23

yuvilio

3,385
31
33

12

You can save yourself an extra system call by converting that to one jq call: `jq -r '.records | length' – Josh Ghiloni Dec 04 '20 at 20:53
2

The above comment is irrelevant now (The answer has been updated). – Krishna Aug 09 '21 at 13:26

score 8 · Answer 4 · answered Aug 24 '21 at 07:10

If the JSON is being read from a file, try this -

number_of_objects=`jq '. | length' json_file_name.json`
echo $number_of_objects

If the JSON array is inside a key in the JSON as shown below -

{
  "fruits": [
    "apples",
    "oranges",
    "pears"
  ]
}

try this -

number_of_objects=`jq '.fruits | length' json_file_name.json`
echo $number_of_objects

(You'll have to download jq for this solution to work)

score 4 · Answer 5 · answered Jan 24 '14 at 14:45

4

A simple solution is to install jshon library :

jshon -l < /tmp/test.json
2

answered Jan 24 '14 at 14:45

Édouard Lopez

36,430
24
114
170

score 2 · Answer 6 · answered Jul 07 '21 at 00:40

2

try qic. it works like jq/jello. qic support interactive mode as well.

cat test.json | qic "len(_)"

https://walkerever.github.io/qic/

answered Jul 07 '21 at 00:40

Y W

21
1

How to count items in JSON object using command line?

6 Answers6

Linked