1,886 questions
1
vote
3
answers
112
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
137
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
1
vote
0
answers
27
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....
- 11
0
votes
0
answers
65
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,554
0
votes
1
answer
41
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
1
answer
89
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
94
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
126
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
133
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,626
0
votes
1
answer
52
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.4k
0
votes
1
answer
88
views
JSON Path functionality (sum) value
I'm making an API request with Zabbix here :
{
"result": "success",
"maxTotal": 2,
"users": [
{
"unit": "...
0
votes
1
answer
217
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
69
views
Keep nested structure in JSONPath-Plus
I've the following JSON file:
[
{
"id": "9a884faee51213bd0fd9b5e97ad5fd0c54e92d8d",
"name": "75193f9f-836a-47ba-b425-b00bca0806ea.yml",
"type&...
- 1,125
0
votes
1
answer
117
views
Syntax error in `JSON_EXISTS` function in PostgreSQL
I want to fetch the data if a particular employee id exists using JSON_EXISTS function.
But I am getting syntax error, not sure where I am wrong. Can someone suggest?
create table test (
id int ...
- 49
0
votes
1
answer
88
views
Filtering list of string with Json Path
I have the following json example
{
"address_components": [
{
"long_name": "43a",
"short_name": "43a",
...
- 67
