JQ get data from an array of array

Question

How can I get a value from an array of arrays. This is JSON from which I have to get the data:

{
  "status": "success",
  "data": {
    "resultType": "matrix",
    "result": [
      {
        "metric": {
          "myMetric": "ABC"
        },
        "values": [
          [
            1633597734,
            "64.54166666666667"
          ],
          [
            1633598034,
            "65.51666666666667"  <-- wanted value
          ]
        ]
      }
    ]
  }
}

I have to get value from the last array in values. I tried the following:

jq .data.result.values input.json
jq .data.result.values[] input.json
jq .data.result.values[][] input.json

For every one the result is:

jq: error (at json:0): Cannot index array with string "values"

How can I get value from the last array in values?

Can you try with jq .data.result[0].values[1][1] input.json or if you want all the quoted floating point numbers jq .data.result[0].values[][1] input.json? — Marko E
– Marko E, Commented Oct 7, 2021 at 12:10
If you want the last entry in the last array in values of the last entry in result, this would work: .data.result[-1].values[-1][-1]; did you want just that, or for all values? — Benjamin W.
– Benjamin W., Commented Oct 7, 2021 at 12:17

Benjamin W. · Accepted Answer · 2021-10-07 14:22:01Z

2

You can use a negative index to enumerate from the back of an array: to get the last element of the last array in the values of the last element of result:

.data.result[-1].values[-1][-1]

answered Oct 7, 2021 at 14:22

Benjamin W.

54k19 gold badges135 silver badges136 bronze badges

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

Comments

Logan Lee · Accepted Answer · 2022-03-16 02:41:22Z

0

demo: https://jqplay.org/s/YMpB8-A4-Q

filter: 
.data.result[].values[1][1]?

input:
{
  "status": "success",
  "data": {
    "resultType": "matrix",
    "result": [
      {
        "metric": {
          "myMetric": "ABC"
        },
        "values": [
          [
            1633597734,
            "64.54166666666667"
          ],
          [
            1633598034,
            "65.51666666666667"
          ]
        ]
      }
    ]
  }
}

output:
"65.51666666666667"

answered Mar 16, 2022 at 2:41

Logan Lee

1,0351 gold badge12 silver badges27 bronze badges

Collectives™ on Stack Overflow

JQ get data from an array of array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related