Getting Last Available element of a Particular Column in JQ

Nishothan Vettivel 0
Viewed 58

I have been working on a Bash script. I am having a curl response as follows.

{
  "range": "'PR-DETAILS'!A1:Z1000",
  "majorDimension": "ROWS",
  "values": [
    [
      "PR ID",
      "PR Owner"
    ],
    [
      "1929",
      "Angel"
    ],
    [
      "73",    
      "Martin"
    ],
    [
      "142"
    ]
  ]
}

Here I just want to get the last available element for the second column.

Expected Answer:- Martin

jq json
2 Answers

Here's one way:

last(.values[] | select(has(1))) [1]

Online demo

If the second column does not contain false values (null, false) this will also work:

last(.values[][1] // empty)
oguz ismail0

Here's a different solution:

.values | map(.[1] | select(.)) | last

probably less efficient, but quite readable.

The difference to the other answer is that select(.) will filter any falsy value, not only non-existent values. So if your second columns were to contain false or null, these wouldn't show up in your result.

knittl0
Related