Skip to main content
200 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
3 answers
97 views

Assume I have many rows with jsonb data like this in their respective columns: { ..., "participants": { "one_uuid": { "id": "another_uuid", &...
mrivera's user avatar
  • 21
0 votes
2 answers
115 views

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, { "...
Kiran Deep's user avatar
  • 163
0 votes
1 answer
47 views

I have some JSON data from a third-party and I am using JSON Path to transform the data. Below is a sample of the JSON data and the expressions I am trying. { "Traveller": [ { &...
Dev Team's user avatar
  • 1
2 votes
1 answer
73 views

Using JsonPath.Net, is it possible to write a single query that will obtain the values of properties with the same key at different nesting levels? For example, from the following JSON: { "ObjA&...
Cliff Pennalligen's user avatar
  • 423
0 votes
1 answer
186 views

I have a JSON with the following structure: { "markets": { "US": { "homes": [ { "type": "house&...
Kinsey Bice's user avatar
  • 1
0 votes
1 answer
20 views

How do I get a particular array element's value whose position keeps changing using NiFi JsonPath Input JSON: { "phones": [ { "type": "H", "...
Sam's user avatar
  • 21
1 vote
1 answer
130 views

Hi I'm struggling to find the JSONPATH expression to get all the JSON object having a specific key including the root JSON object. For example: { "key1": 1, "key2": 2, &...
Nicolas Sitbon's user avatar
  • 13
0 votes
1 answer
80 views

I want to validate the JSON response of all key value pair except the timestamp which is Dynamics. Either I have to write multiple JSONPath Expression assertions or can achieve this in one assertion? ...
Maddy's user avatar
  • 715
2 votes
1 answer
86 views

I have a jsonb saved in a PostgreSQL database that has the structure: { "foo": { "key0": { "bar": "myValueA", }, "key1": { &...
Valentin Vignal's user avatar
  • 8,644
0 votes
1 answer
53 views

I am new to JSON. I have a LossHistory Json from which I need to filter "LineOfBusinessCode" equal to "General Liab - Excess" from that I need to show specific "Lossyear" ...
Rajesh Senapati's user avatar
  • 202
0 votes
1 answer
81 views

I want to extract a token from the the given below JSON response where the key of the token is dynamic. The key 57 is dynamic. it change every time. I know that how to extract value by given key but ...
BhavinD.'s user avatar
  • 481
1 vote
1 answer
2k views

I am invoking an AWS Steps orchestration - and one of the contained steps is to invoke an ECS Fargate Task. I currently pass some of the Steps' inputs as the "command" of the ECS Task using ...
Andrew Patterson's user avatar
  • 1,370
0 votes
1 answer
111 views

I'm trying to return the full parent object when the url = 'www.fruits.com' Below is the json schema. It's quite tricky { "produce": [ { "type": "fruit", ...
Addison Joseph's user avatar
  • 157
1 vote
1 answer
268 views

I have a JsonNode with the structure: { 'field1': 'value1' 'field2': 'value2' } I want to retrieve 'value1' by specifying a json path: "$.field1". However, instead of getting 'value1', I'm ...
AznBoyStride's user avatar
  • 317
0 votes
0 answers
49 views

How to get values.status value when values.name.value=text from the json. $.values[?(@.name[?(@.language=='EN' && @.value=='test')])].status is giving more than 2 status values {"values&...
Anonymous's user avatar
  • 1
0 votes
1 answer
161 views

I have data in JSON format and it looks like this: { "book": [{ "category": "reference", "author": "Nigel Rees", "...
Krishna Madhav's user avatar
  • 3
0 votes
2 answers
244 views

Let's say I have a JSON like this: { "roles": [ "role1", "role2", "super_role1", "super_role2" ] } And I want to filter with ...
Jeremy D's user avatar
  • 1
0 votes
1 answer
327 views

Here is a json snippet containing a definition structure : { "Type": "page", "Label": "Test", "Children": { "crud": { "...
Cristof's user avatar
  • 26
0 votes
1 answer
174 views

I have the following json: { "books": [ { "id": 1, "name": "República Brasileira. de Deodoro a Bolsonaro - 2° Edição", ...
user2919910's user avatar
  • 685
0 votes
1 answer
535 views

The data: { token : "xxxx" files: [ { id : 1, deleted: true }, { id : 2, deleted: false }, { id : 3, deleted: false } ] } I ...
Ananda Bhavani Gedela's user avatar
  • 21
1 vote
2 answers
376 views

I have a model with a JSONField and need to select just the objects that have a certain value somewhere nested in the jsonb. From the Django documentation I understand you can use contains but the ...
Chris Wesseling's user avatar
  • 6,396
0 votes
1 answer
183 views

Is there's a way I could extract the highest id: "15" of bld-appliance-1 using Json Path expression. Currently if use this Json expression "[?(@.name == 'bld-appliance-1')]..id" it ...
Harris's user avatar
  • 185
0 votes
1 answer
247 views

I have a json of type: [{ "event": "click", "status": "success", "test": true } , { "event": "send", "...
sashmi's user avatar
  • 169
0 votes
1 answer
742 views

I have a JSON that structured as below. I am using JSONPath Expression to filter values only. How does one filter and output only those values where the first three characters of those values match ...
Naveen Chand K's user avatar
  • 426
1 vote
1 answer
340 views

I am creating a Infrastructure-as-Code for a Step Functions Machine. One of these states is of type 'Task' which performs a DynamoUpdateItem on a DynamoDB table. The code looks as following: const ...
DevBob's user avatar
  • 75

1
2 3 4