I tried to replicate the same configuration as yours and ended up fetching the entire JSON instead of the specific value. Check this existing public feature request and feel free to upvote on the feature to prioritize it accordingly.

For additional reference regarding the issue, you may refer to Extract JSON key-value pairs from secrets.