How to extract a paticular key from the json

Question

I am trying to extract values from a json that I obtained using the curl command for api testing. My json looks as below. I need some help extracting the value "20456" from here?

 {
  "meta": {
    "status": "OK",
    "timestamp": "2022-09-16T14:45:55.076+0000"
  },
  "links": {},
  "data": {
    "id": 24843,
    "username": "abcd",
    "firstName": "abc",
    "lastName": "xyz",
    "email": "abc@abc.com",
    "phone": "",
    "title": "",
    "location": "",
    "licenseType": "FLOATING",
    "active": true,
    "uid": "u24843",
    "type": "users"
  }
}
{
  "meta": {
    "status": "OK",
    "timestamp": "2022-09-16T14:45:55.282+0000",
    "pageInfo": {
      "startIndex": 0,
      "resultCount": 1,
      "totalResults": 1
    }
  },
  "links": {
    "data.createdBy": {
      "type": "users",
      "href": "https://abc@abc.com/rest/v1/users/{data.createdBy}"
    },
    "data.fields.user1": {
      "type": "users",
      "href": "https://abc@abc.com/rest/v1/users/{data.fields.user1}"
    },
    "data.modifiedBy": {
      "type": "users",
      "href": "https://abc@abc.com/rest/v1/users/{data.modifiedBy}"
    },
    "data.fields.projectManager": {
      "type": "users",
      "href": "https://abc@abc.com/rest/v1/users/{data.fields.projectManager}"
    },
    "data.parent": {
      "type": "projects",
      "href": "https://abc@abc.com/rest/v1/projects/{data.parent}"
    }
  },
  "data": [
    {
      "id": 20456,
      "projectKey": "Stratus",
      "parent": 20303,
      "isFolder": false,
      "createdDate": "2018-03-12T23:46:59.000+0000",
      "modifiedDate": "2020-04-28T22:14:35.000+0000",
      "createdBy": 18994,
      "modifiedBy": 18865,
      "fields": {
        "projectManager": 18373,
        "user1": 18628,
        "projectKey": "Stratus",
        "text1": "",
        "name": "Stratus",
        "description": "",
        "date2": "2019-03-12",
        "date1": "2018-03-12"
      },
      "type": "projects"
    }
  ]
}

I have tried the following, but end up getting error:

▶ cat jqTrial.txt | jq '.data[].id'
jq: error (at <stdin>:21): Cannot index number with string "id"
20456

Also tried this but I get strings outside the object that I am not sure how to remove:

cat jqTrial.txt | jq '.data[]'

That's right. But the problem is that is what i get as output from the curl command. Is there a way to extract required data from here? — larry, Sep 16 '22 at 15:35
@larry, how do you know _which_ `data` object you want the `id` for? One is type "users" the other is type "projects" — glenn jackman, Sep 16 '22 at 15:37
As an aside, that's a [useless use of `cat`](https://stackoverflow.com/questions/11710552/useless-use-of-cat) — tripleee, Sep 16 '22 at 15:40

score 0 · Answer 1 · answered Sep 16 '22 at 15:38

Your input consists of two JSON documents; both have a data field on top level. But while the first one is itself an object which has an .id field, the second one is an array with one object item, which also has an .id field.

To retrieve both, you could use the --slurp (or -s) option which wraps both top-level objects into an array, then you can address them separately by index:

jq --slurp '.[0].data.id, .[1].data[].id' jqTrial.txt

24843
20456

Demo

Good to learn a new option to use with jq. Thank you! – larry Sep 16 '22 at 15:48 — larry, Sep 16 '22 at 15:48

glenn jackman · Accepted Answer · 2022-09-16T16:12:45.820

0

Assuming you want the project id not the user id:

jq '
    .data
    | if type == "object" then . else .[] end
    | select(.type == "projects")
    | .id
' file.json

There's probably a better way to write the 2nd expression

Indeed, thanks to @pmf

.data | objects // arrays[] | select(.type == "projects").id

edited Sep 16 '22 at 16:12

answered Sep 16 '22 at 15:42

glenn jackman

238,783
38
220
352

1

Thank you so much. That did the trick! I am still new to jq and theres a lot to learn. This helps. – larry Sep 16 '22 at 15:46
1

`.data | objects // arrays[] | select(.type == "projects").id` – pmf Sep 16 '22 at 16:09
1

There it is! Thanks @pmf – glenn jackman Sep 16 '22 at 16:12

How to extract a paticular key from the json

2 Answers2