How to extract a paticular key from the json-CodePudding

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": "[email protected]",
    "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://[email protected]/rest/v1/users/{data.createdBy}"
    },
    "data.fields.user1": {
      "type": "users",
      "href": "https://[email protected]/rest/v1/users/{data.fields.user1}"
    },
    "data.modifiedBy": {
      "type": "users",
      "href": "https://[email protected]/rest/v1/users/{data.modifiedBy}"
    },
    "data.fields.projectManager": {
      "type": "users",
      "href": "https://[email protected]/rest/v1/users/{data.fields.projectManager}"
    },
    "data.parent": {
      "type": "projects",
      "href": "https://[email protected]/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[]'

CodePudding user response：

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

CodePudding user response：

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