How can I use the JSONPath filtering capabilities to query for a specific condition on a property on a subobject (without an array)? Consider this JSON example:
I try to pass argument $1 to jsonpath-expression: SELECT 1 FROM %s.orders AS O WHERE order_info @? '$.items[*] ? (@.ProductID == $1)' but it doesn't work. P
This is the JSON Path I have been using: $..products[?(@.category == 'merchant_cards' && @.countries[0].abbr == 'US' && @.skus[0].min < '25')
I realize there are several other JmesPath join questions here, but I'm having trouble with a separate problem that I haven't found any examples for, where I ne
I am struggling to modify several JSON objects, while using the JsonPath library. I have a selector, that gets declared at runtime and a JSON file of unknown si
I'm following the tutorial for using jsonpath (https://www.baeldung.com/guide-to-jayway-jsonpath) and using the endpoint https://api.binance.com/api/v3/exchange
I need all elements (including "id" and all attributes) of the json sample below where "type" has the value "state_machine_state", but only if "type" is on the
Say the input is: [{keyname: firstname, path:person.name.firstname,type:string}, {keyname:age, path:person.age,type:number}] Then jsonschema should be generate
I am using JSONPath and this node module https://www.npmjs.com/package/jsonpath-object-transform to transform a JSON obj into a different output. This is simila
I want to add a new field to jsonObject and this new field's name will be based on a value of another field. To be clear, this an examples of what I want to ach
I want to add a new field to jsonObject and this new field's name will be based on a value of another field. To be clear, this an examples of what I want to ach
I'm writing a JSONPath expression that counts objects in an array while filtering by one of the field of the object. Input JSON taken from http://jsonpath.hero