Extract JSON data to object from REDIS response

ant0n · September 23, 2022, 4:19pm

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:

Kabirdas · September 26, 2022, 9:57pm

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 · September 27, 2022, 5:29pm

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\"}]"