Reference to root element as key in JSON Path Expression

Question

I have a JSON like this

{ 
    "a" : 1,
    "key_to_find" : "value_of_key",
    "nested" : {
         "value_of_key" : "real_value",
         "b" : 2
    }
}

I want to create a JSON Path expression to get "real_value", but I don't now the key "value_of_key" so I need to dynamically reference it. I tried something like:

$.nested['$.key_to_find']

but it doesn't work. How can I reference to root element value as key to get children values? Is that possible?

I need to use it inside AWS Step Functions, so no programming languages/libraries can be used.

gregsdennis · Accepted Answer · 2023-01-24 23:45:31Z

2

References like this aren't part of JSON Path, though I think since you're using them inside AWS, you'll need to see exactly what they support. It varies. Widely.

We (the team working on the coming specification) have looked at the idea of a key() or index() function, however. You may find this discussion enlightening as well.

answered Jan 24, 2023 at 23:45

gregsdennis

8,5206 gold badges43 silver badges79 bronze badges

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

2 Comments

mostr Over a year ago

Thank you, I am following the discussion in the link so correct me if I am wrong. Actually there is no solution for this, but you are already working on a possible functions implementation to address this kind of use cases?

gregsdennis Over a year ago

There are some proposals, yes, but nothing has been added to the spec, yet, for this specific use case.

Collectives™ on Stack Overflow

Reference to root element as key in JSON Path Expression

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related