JSONPath expressions don't work

Created on 7 July 2024, 5 months ago

Problem/Motivation

JSONPath expressions won't extract the data "fields" (ie. columns) correctly but "0 1 2 3 4" (one for each data point).

Steps to reproduce

- Set up a Visualisation File field with JSONPath expression $..amount.*
- Take example full_data.json by saving https://api-osmosis-01.stakeflow.io/cosmos/tx/v1beta1/txs/block/17633988
- Create a node and upload full_data.json, select any chart type (bar should be fine),
- See how fields "0 1 2 3 4" are extracted instead of "amount data".

To test the problem is not in my JSONPath syntax:
- go to https://jsonpath.com/
- add the contents of full_data.json in the inputs and $..amount.* as JSONPath,
- take the output and save it to filtered_data.json
- change the JSONPath configuration in the node field back to the default $[*]
- create a new node and upload the filtered_data.json this time
- see the amount & data fields (columns) correctly appear (as well as the graph after saving).

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Active

Version

3.0

Component

Code

Created by

🇮🇹Italy kopeboy Milan

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024