Redis and Grafan: JSONPath not returning JSON object correctly

[willychrisza]

Redis and Grafan: JSONPath not returning JSON object correctly

[mikhail-vl]

@aengusrooneygrafana Please contact the Redis team @K-Jo.

[aengusrooneygrafana]

Hi @mikhail-vl is this an issue we could collaborate on?

[chavalikesavanand]

@aengusrooneygrafana any updates on this pls

[slorello89]

Hi @willychrisza - curious if this is related to #283 - are you actually using the JSON data type? or are you are saving strings in redis and pulling out certain paths client side (not certain from the way the issue is phrased) - I've found that it appears that JSON operations (e.g. JSON.GET) only seem to work with clean scalar strings, or objects that will break down somewhat nicely.

Curious what your thoughts are on how a result would look if one of these paths were used. JSON is by its nature schemaless so mapping it into the tabular format that the grafana frames expect is at least somewhat problematic. I've opened a PR to fix the issue with other scalars (booleans and numbers) but will need some more time to consider what this will look like for non-scalars (arrays/complex-nested objects).