Json Path – get all but last element of an array
I have a JSON array: [ 1, 2, 3, 4 ] I want to create a Json Path expression that returns all but the last element of the array, i.e. the result is: [ 1, 2, 3 ] There are…
Is it possible to use JSONPath with "?()" syntax to filter objects (not array) in Redis?
I'm using node-redis library. I have redis key: test1 with value: { "requests": [ { "requestId": "123", "requestType": "TYPE_1", "foo": "bar", "timestampS": 1230011000 }, { "requestId": "124", "requestType": "TYPE_1", "foo": "bar2", "timestampS": 1230011050 } ] } To get all requests…
Json – Filtering using Newtonsoft with multiple conditions in C#
I'm trying to extract values from json using Newtonsoft, but I'm having some problems. Below is the json snippet I use: { "result": { "areas": [ { "area": 1, "items": [ { "name": "name1", "numbers": [ 2, 2, 2, 1…
Separating the common name when extracting data from a json format
I do have this sample json data that I got from jsonplaceholder, a dummy rest api data. I am practicing display/fetching data to it. Now, I am having a trouble when I am fetching the name of the person. But…
Postgresql – how extract 'cancellationDate' this:
["{"RequestedByUser":false,"RequestedBySystem":null,"RequestedBySellerNotification":null,"RequestedByPaymentNotification":true,"Reason":null,"CancellationDate":"2024-01-16T00:40:59.0928615+00:00"}"] tryingjson_extract, jsonpath and nothing
evaluate jsonpath expression for the example
{ "a": [ { "b": { "c": [ { "id": "123" } ], "d": { "e": { "f": [ { "name": "abc", "type": "in" }, { "name": "xyz", "type": "out" } ] } } } }, { "b": { "c":…
Assignment in Newtonsoft.Json's implementation of JsonPath
I have a JSON like this one: { "options": [ { "price": 217, "quantity": 2 }, { "price": 63, "quantity": 5 } ] } And I want to query it with JsonPath to get the product of "price" and "quantity"…
Json Path To extract array element with child Filter
Hi I am looking to construct a jsonpath expression to find the array element that matches the filter on a child. Please find details below Json { "items": [ { "id": 1, "children": [ {"id": 101, "name": "Child1"}, {"id": 102,…
JSONPath to reference json inside of json
This is on AWS Eventbridge input transformer, AWS UI not code So i have a JSON { "version": "0", "id": "437e4ed4-8ee1a178", "detail-type": "blah", "source": "blahblah", "account": "011604459942", "time": "2023-11-20T23:20:14Z", "detail": { "transaction_id": 6787, "customer_id": 1234, ... "created_at": "2023-11-21T10:19:40.929+11:00", "updated_at": "2023-11-21T10:19:52.425+11:00"…
Postgresql – Variable substitution for Postgres jsonpath operator like_regex?
I want to query a JSONB array using a regex filter. Following the docs, I should be able to do: WHERE jsonb_path_exists( data, '$.value[*] ? (@ like_regex $foo flag "i")', jsonb_build_object('foo', 'demo') ) But I'm getting an error: ERROR: syntax…