@sunnyt7, the JSON feed does contain the data that you need (using this json parser):
However, it won't be trivial to use it with using a Twig template, because the
users array does not use User ID as a key.
So, the way to tackle this would be to create a special SQL request in your Discourse Data Explorer plugin, and extract all fields that you need in a resulting rows.
A good side-effect to this would be the fact that you will only extract fields that you need to build your view, thus avoid passing unneeded data. This will save on traffic, so fetching might work a bit faster.