how to remove [] character at extracted json using json path

Question

{
    "responseCode": "200",
    "data": {
        "sequence": 1,
        "used": true,
        "sensingTags": [
            {
                "code": "LED",
                "value": 1,
                "updatedOn": 1587557350251
            }
        ]
    }
}

My goal is get updatedOn value from this json using jsonPath like this

1587557350251

i thought below jsonPath will work but it extract only empty list.

$..sensingTags[?(@.code == 'LED')][0].updatedOn

And i want to know how to extract value like below

            {
                "code": "LED",
                "value": 1,
                "updatedOn": 1587557350251
            }

Not like this one.

[
   {
      "code" : "LED",
      "value" : 1,
      "updatedOn" : 1587557350251
   }
]

can you add some code to generate this JSON? – Ronnie Tws Apr 23 '20 at 02:52 — Ronnie Tws, Apr 23 '20 at 02:52

score 1 · Answer 1 · edited Apr 23 '20 at 09:57

1

As per Getting a single value from a JSON object using JSONPath, JsonPath will always return an array (or a false) at that point...

Best you can do is process it as an array of updatedOn and simply always grab the first value.

$..sensingTags[?(@.code == 'LED')].updatedOn

edited Apr 23 '20 at 09:57

Chris F Carroll

11,146
3
53
61

answered Apr 23 '20 at 08:56

Davey van Tilburg

708
3
19

how to remove [] character at extracted json using json path

1 Answers1