any way to embed MongoDB query results into Confluence?

[Jeff Behl]

I'd like to embed some content from a MongoDB query into a Confluence page, much in the same way you can embed arbitray SQL query results. Anyone think of a clever way to do this? There doesn't seem to be a plugin to do it directly, so that not being available, is there some sort of widget to be used to do it?

[Renjith Pillai · Accepted solution]

How about using {beanshell} macro, stuff in some Java code to pull out the JSON objects from DB, and do out.println in the Wiki format of Confluence? Haven't tried this myself, but should work.

[Jeff Behl]

Thanks Renjith, I wasn't aware of these macros (including hte Groovy one). As long as I have the driver jar available this should work fine. Thanks much