Skip to main content
200 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
501 views

I have a JSON Array which contains multiple JSON objects: [ { "s3_uri":"s3://fake-s3-bucket/fact_table/fact_table.csv", "dataset":"fact_table" ...
Geocoder's user avatar
  • 141
2 votes
1 answer
2k views

I need to extract "https://www.domain3.com" from this JSON { "jobs": [ { "name": "alfa", "url": "https://www....
Cesare's user avatar
  • 1,757
0 votes
0 answers
360 views

I am trying to use the code completion with antlr4-c3. Suppose that the list of suggestions for the function argument depends on the function's name. So for the following expression foo(bar(...)) I ...
Pavel Ganelin's user avatar
  • 314
0 votes
1 answer
156 views

I've this JSON (I know it's not a very conventional JSON ;) ) { "2958114":{"stockOnline": 305 }, "2958113": {"stockOnline": 2}, "2958115": ...
gozen59's user avatar
  • 3
1 vote
1 answer
1k views

What I want Apply a JSONPath to given json response, to match specific elements by comparing their children's node keys with a value. Input { "data": { "ticket": { ...
oikonomopo's user avatar
  • 4,065
0 votes
1 answer
449 views

I'm trying on JSONPath expression on https://jsonpath.com. I have the following JSON, and I only need the last Order's (tranTxt) Invoice number (invcNr). So first I filtered out the object where I ...
Zoltan's user avatar
  • 15
0 votes
1 answer
523 views

Json { "Id": "1234", "AValue": { "qId": "ABCD", "aType": "DATE", "value": { &...
parhau's user avatar
  • 227
1 vote
1 answer
423 views

in postgres 13, I have a Jsonb object and I am able to get only the keys using jsonb_object_keys like this. SELECT keys from jsonb_object_keys('{ "135": { "timestamp": ...
Shrikar Kalagi's user avatar
  • 111
1 vote
1 answer
2k views

In Postgres 13, for the below query, the jsonb values are getting filtered correctly based on "priority": SELECT jsonb_path_query( '{ "100": { "name": "test&...
Shrikar Kalagi's user avatar
  • 111
0 votes
2 answers
327 views

For example: command kgp -o jsonpath='{range .items[]}{range @.spec.containers[]}{@.name}{"\t"}{.items[].metadata.name}{"\n"}{end}{"\n"}{end}' output nginx istio-proxy ...
kabilan's user avatar
  • 11
0 votes
2 answers
115 views

Using JSONPath I'm trying to fetch pools > id > options > id based on this condition: componentGroups > id > poolId = pools > id "poolId": "cb720883-04f1-4be4-a416-...
FeelGood's user avatar
  • 11
1 vote
1 answer
1k views

I have Json data as follows: { "template" : [ "{ "Id": "abc" }" ] } I am using JSONPath to extract data from the Json above. I would ...
mang4521's user avatar
  • 832
2 votes
1 answer
3k views

I am performing a sagemaker batch transform using a transformer created out of an xgboost estimator. The csv input for prediction/batch transform has both, an ID column and a header (with names of ...
A-G-'s user avatar
  • 21
1 vote
2 answers
1k views

kI have a problem with the library https://github.com/JSONPath-Plus/JSONPath at the latest version. Example: { "firstName": "John", "lastName": "doe", ...
Hugo's user avatar
  • 13
2 votes
2 answers
1k views

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 ...
M4tee's user avatar
  • 61
1 vote
1 answer
1k views

Hi I don't know if this is possible, but I have some data in MySQL in the following structure : {"LinkId": "q1", "Answer": "Yes"},{"LinkId": "q2&...
Kiran Cheema's user avatar
  • 66
0 votes
1 answer
468 views

I have this json: { "deviceId": "deviceCustom", "moduleId": "custom", "properties": { "desired": { "...
sarjaana's user avatar
  • 85
5 votes
2 answers
18k views

Im trying to filter the elements of this JSON array to return only the first element it will find. { "elements": [{ "urn": "urn:li:lyndaCourse:189800", ...
Infor.KS's user avatar
  • 51
1 vote
2 answers
499 views

I am using jsonpath-plus 6.01. I have following JSON: { "Request": { "@Domain": "SomeDomain", "Vehicle": { "@ID": "E11XPD" ...
Lucas's user avatar
  • 91
0 votes
2 answers
400 views

I need to know how to get this output - JSON DOC - { "status": "E000", "customerId": "VjAxI2VhNzg5ZmJlLWIyNjAtNGZlOS1iZDNkLTdjMmU1MjA2ZmVhZA", "merchantId&...
Rishabh Jain's user avatar
  • 3
1 vote
1 answer
684 views

Say I have a JSON data stored in a varchar(max) column in a database. Is it possible to use SQL to get all the JSON paths present in that data. For example for the following JSON: { "dog"...
SBFrancies's user avatar
  • 4,260
0 votes
0 answers
3k views

I am using jsonpath library (https://github.com/json-path/JsonPath) in Go, and I need to process a JSON object and filter from an array of objects, the objects which match any of the multiple criteria ...
Ccy's user avatar
  • 689
1 vote
1 answer
725 views

I have a very heavily nested json file with multiple blocks inside it. The following is an excerpt of the file, It has more than 6 levels of nesting like that { "title": "main ...
notsopeter's user avatar
  • 11
0 votes
2 answers
3k views

I am using JSONPath to filter out a json file, I am trying to retrieve both the Key + Value from the JSON array but I am lost at figuring how best to do this. QUERY $.phoneNumbers[*].[type,number] ...
Kyle McBride's user avatar
  • 169
0 votes
1 answer
102 views

I want to know the value of "Test1" whose "createdTs" value is greater than or equal to 444. [ { "raw" : { "Test1":"Apple", "Test2":{ "createdTs": ...
testaaa's user avatar
  • 15

1
2
3 4