1,887 questions
0
votes
2
answers
95
views
JsonPath nested conditions
I have this sample json
{
"accessRequestId": "2c91808b6ef1d43e016efba0ce470904",
"requestedBy": {
"type": "IDENTITY",
"id&...
- 2,168
2
votes
1
answer
117
views
How to find the jsonpath of any element in JSON
I am working with Altova MapForce for data mapping tasks involving JSON. Is there a built-in function or a way to create a custom function in Altova MapForce that takes a specific field (or node) as ...
1
vote
3
answers
156
views
SELECT jsonb data based on specific children values/properties
Assume I have many rows with jsonb data like this in their respective columns:
{
...,
"participants": {
"one_uuid": {
"id": "another_uuid",
&...
- 21
2
votes
2
answers
153
views
$..[?(@.name=='is_literate')] expression works completely fine on `https://jsonpath.com` but it throw an error while using expression at `jsonpath-ng`
I am facing an issue with phasing data using jsonpath-ng. My expression looks like:
$..[?(@.name=='is_literate')]
I tried it at https://jsonpath.com/, it works fine with $..[?(@.name=='is_literate')] ...
- 137
0
votes
0
answers
45
views
Getting 'org.json.JSONException: JSONArray[0] not found' exception when accessing invalid key or key with NULL value
JSONObject json = new JSONObject(""" { "key": null } """);
Configuration config = Configuration.builder()
.options(Option.SUPPRESS_EXCEPTIONS, Option....
0
votes
0
answers
70
views
how to write rule for a nested json
I'm using json-rules-engine and would like to write a query for a nested json. Here is my code. the code runs without any error but the event doesn't triggered.
const { Engine } = require('json-rules-...
- 6,584
0
votes
1
answer
51
views
How to filter on missing field in jsonpath (Jayway)
In Jsonpath (Jayway Java implementation), how do I find array elements where a certain field is missing? For example, in the below JSON, how do I find books without isbn?
In theory, empty(true) ...
- 103
0
votes
0
answers
94
views
Handling conditional JsonPath in nested JSONArray
I'm trying to return the value of 'id', where value is "India" in nested JSON as shown below
{
"iterations": [
{
"id": "122",
"parameters&...
- 19
0
votes
1
answer
108
views
How can I split or extract specific node from a JSON string object using jsonpath
I have a JSON string object, and I have to extract a value, but either I can split the JSON or I need to extract that value. Below is my JSON string.
[
{
"Code": "1",
&...
0
votes
2
answers
148
views
jayway.jsonpath:json-path is failing to filter objects with !=
I am trying to exclude a field and keeps rest of the fields intact using Goessner JSONPath of com.jayway.jsonpath:json-path:2.9.0 but apparently it is not working.
For the following JSON,
{
"...
- 163
1
vote
1
answer
295
views
Get first array element to meet a condition in JSONPath
Given a JSON object with an array —e.g.:
{
"phoneNumbers": [
{
"type" : "iPhone",
"number": "0000-0000-0000"
},
{
&...
- 5,654
0
votes
1
answer
55
views
How can I evaluate all values of a path with Oracle?
I'm working with Oracle's sample schemas.
With the following column values of PRODUCT_DTAILS,
"{
"colour" : "brown",
"gender" : "Women's",
"...
- 22.5k
0
votes
1
answer
118
views
JSONPath sum values
API request with Zabbix:
{
"result": "success",
"maxTotal": 2,
"users": [
{
"unit": "2025-04-01",
...
0
votes
1
answer
259
views
Conditional Expression in JSONPath for AWS Step Function
I am working with AWS Step Functions and trying to send an event to an EventBridge event bus using the PutEvents API. However, I am encountering an issue with the following Step Function configuration ...
0
votes
1
answer
80
views
Keep nested structure in JSONPath-Plus
I've the following JSON file:
[
{
"id": "9a884faee51213bd0fd9b5e97ad5fd0c54e92d8d",
"name": "75193f9f-836a-47ba-b425-b00bca0806ea.yml",
"type&...
- 1,145