Extracting a json string from child array in bash

Question

This is the output I receive via curl. I want to save 'playcount' in a variable. How do I loop through tracks[] to get the strings 'playcount' and save them so I can form the sum?
I've spend a lot of time figuring it out with jq but nothing really worked out..

{
  "success": true,
  "data": {
    "track_count": 2,
    "discs": [
      {
        "number": 1,
        "name": "",
        "tracks": [
          {
            "album_id": "u2hh2n2b7fo20v46cbe",
            "playcount": 17212,
            "name": "World Savior",
            "number": 1,
            "duration": 341,
          },
          {
            "album_id": "jk299sdhjahj991nbwd",
            "playcount": 9812,
            "name": "Tower",
            "number": 2,
            "duration": 281,
          }
        ]
      }
    ],
    "month": 11,
    "day": 26,
    "year": 2021,
    "type": "single",
  }
}

Gordon Davisson · Accepted Answer · 2021-07-03 09:37:43Z

2

If you want the list of playcount values, you just have to drill down to the right content:

jq '.data.discs[].tracks[].playcount'

If you want their sum, make an array of that and add its entries:

jq '[.data.discs[].tracks[].playcount]|add'

answered Jul 3, 2021 at 9:37

Gordon Davisson

128k16 gold badges141 silver badges168 bronze badges

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

Collectives™ on Stack Overflow

Extracting a json string from child array in bash

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