Get data from a JSON output using 'jq'

Question

I have the following JSON output:

{
  "201110131738QP27N": {
    "parent": 17,
    "name": "CentralServer",
    "status": "Active",
    "count": 6
  },
  "201803271459ICV69": {
    "name": "subaccount1",
    "status": "Active",
    "count": 1
  },
  "2018032715008ZM2G": {
    "name": "subaccount2",
    "status": "Active",
    "count": 1
  },
  "201803281536PSKR4": {
    "name": "Este e um teste",
    "status": "Active"
  }
}

And I'm trying to get only the following data:

201110131738QP27N
201803271459ICV69
2018032715008ZM2G
201803281536PSKR4

To get the desired data, I'm trying to use the jq command, but so far I have not succeeded.

Hi, Welcome to Stack Overflow. You mentioned you attempted this task using `jq`, but you did not provide your attempt. Could you please update your question to show your attempt? — kvantour, Mar 29 '18 at 12:43

Inian · Accepted Answer · 2018-03-29T12:59:10.273

7

To get the raw output without an array use |.[] to unwrap it

jq --raw-output 'keys | .[]'  input.json

produces

201110131738QP27N
201803271459ICV69
2018032715008ZM2G
201803281536PSKR4

or more simply written as just jq --raw-output 'keys[]'

edited Mar 29 '18 at 12:59

answered Mar 29 '18 at 12:49

Inian

80,270
14
142
161

1

worked perfectly, thank you very much! – RafaelBrianeziDaSilva Mar 29 '18 at 13:09
Is there any way I can enter the contents of the key name and jq gives me the KeyID? For example: I inform "subaccount1" on the command and jq returns me 201803271459ICV69" – RafaelBrianeziDaSilva Mar 30 '18 at 11:53
@RafaelBrianeziDaSilva: You need to ask it as a different question with your efforts – Inian Mar 30 '18 at 11:54

score 2 · Answer 2 · answered Mar 29 '18 at 12:47

2

Use the keys builtin function of jq.

Assuming your input JSON is stored in the file input.json:

$ cat input.json | jq 'keys'

produces:

[
  "201110131738QP27N",
  "201803271459ICV69",
  "2018032715008ZM2G",
  "201803281536PSKR4"
]

answered Mar 29 '18 at 12:47

axiac

68,258
9
99
134

1

Note that `keys` sorts the key names; if you want the unsorted listing, use `keys_unsorted` instead. – peak Mar 29 '18 at 13:13

Get data from a JSON output using 'jq'

2 Answers2