How to find last element in Array list using jsonpath expression?

Question

I have json string like below

[
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "test",
        "partition": 0,
        "offset": 0
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "test",
        "partition": 0,
        "offset": 1
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "test",
        "partition": 0,
        "offset": 2
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "test",
        "partition": 0,
        "offset": 3
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "test",
        "partition": 0,
        "offset": 4
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "test",
        "partition": 0,
        "offset": 5
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "test",
        "partition": 0,
        "offset": 6
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "Hi Test",
        "partition": 0,
        "offset": 7
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "Hi Test",
        "partition": 0,
        "offset": 8
    },
    {
        "topic": "inputTopic",
        "key": "0",
        "message": "Hi Test",
        "partition": 0,
        "offset": 9
    }
]

How can I get last item using jsonpath expression?

 {
    "topic": "inputTopic",
    "key": "0",
    "message": "Hi Test",
    "partition": 0,
    "offset": 9
}

We can get first element by using expression like this " $.[1] " . — Pradeep Poojari
– Pradeep Poojari, Commented Aug 22, 2015 at 8:30

Mario Eis · Accepted Answer · 2017-07-11 08:49:58Z

37

As you can read in the docs you can ether do a

$..book[(@.length-1)]

as mentioned by Duncan above. Or you can

$..book[-1:]

Personally I find the first a bit more expressive, the latter a bit smarter to write. The latter also seems to be the intended default. I'd say it's a question of personal flavor.

answered Jul 11, 2017 at 8:49

Mario Eis

2,93134 silver badges33 bronze badges

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

1 Comment

Don Ho Over a year ago

Even more convenient is "$..book[-1]" which returns just the last element, whereas "$..book[-1:]" returns an array containing the last element.

Duncan · Accepted Answer · 2015-08-22 10:02:25Z

10

You can use the underlying language features when using JsonPath, so in JavaScript for example, the length property is available. You can therefore say I want the last one by asking for length minus one.

Assuming you are using JsonPath from JavaScript the following query will find the last item:

$.[(@.length-1)]

You can see the query working here on this online JsonPath tester: http://www.jsonquerytool.com/sample/jsonpathlastinarray

answered Aug 22, 2015 at 10:02

Duncan

8417 silver badges8 bronze badges

Comments

vlatko606 · Accepted Answer · 2022-10-06 10:42:31Z

3

What was working here for me was:

$..[-1:]

You can test it here: https://jsonpath.com/

answered Oct 6, 2022 at 10:42

vlatko606

1,1692 gold badges17 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to find last element in Array list using jsonpath expression?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related