ant0n
1
I am trying to extract a JSON document stored in REDIS.
My redis server responses as follows,
> json.get user_8f8d5553f95e4cd689af4634e5b2df76:match
"{\"events\":[{\"eventPlayer\":\"pxBMqYpgNuXjuGXfmaMg0eOBz1f2\",\"eventTimeStamp\":0,\"eventIsRebound\":false,\"eventIsAssist\":false,\"eventIsFGM\":false,\"eventIs3PA\":false,\"eventIs3PM\":false,\"eventIsHighlight\":false,\"eventHighlightLength\":0,\"highlightType\":null,\"highlightText\":\"\",\"eventIsFGA\":false},{\"eventPlayer\":\"Nk35vBx8FDSDFzrYPGcR8mjtXj12\",\"eventTimeStamp\":4,\"eventIsRebound\":false,\"eventIsAssist\":true,\"eventIsFGM\":true,\"eventIs3PA\":false,\"eventIs3PM\":true,\"eventIsHighlight\":false,\"eventHighlightLength\":0,\"highlightType\":null,\"highlightText\":\"\",\"eventIsFGA\":false}]}"
when I preview the query I get something that is expected according to JSON.RESP | Redis
In the response preview I also see the results but I cannot access the data from other queries.
Preview screen:
Null data in other query / transformer:
Hi @ant0n!
Odd that your query displays data in preview mode but that you can't access it elsewhere 
what does the data look like in the left panel of your app?
ant0n
3
I fixed it by pulling the data from Redis and then having a javascript function that performs a JSON.parse() on the rawData. See screenshots.
It would be nice if that could happen directly from the redis query.
The raw redis data is as follow,
> get match_events:23
"[{\"eventTimeStamp\":12,\"eventIsRebound\":false,\"eventIsAssist\":false,\"eventIsFGM\":false,\"eventIs3PA\":true,\"eventIs3PM\":true,\"eventIsHighlight\":true,\"eventHighlightLength\":10,\"highlightText\":\"Amazing 3PT\",\"eventIsFGA\":false,\"eventPlayer\":\"pxBMqYpgNuXjuGXfmaMg0eOBz1f2\",\"highlightType\":\"3PT\"},{\"eventTimeStamp\":19,\"eventIsRebound\":false,\"eventIsAssist\":false,\"eventIsFGM\":false,\"eventIs3PA\":true,\"eventIs3PM\":true,\"eventIsHighlight\":true,\"eventHighlightLength\":12,\"highlightText\":\"It's raining 3PT\",\"eventIsFGA\":false,\"eventPlayer\":\"N6Bi98x0QHgqK3gYtGWuz86JzU52\",\"highlightType\":\"3PT\"}]"
1 Like
