Macro to render external JSON data?

Rune Hellem_yzgslk

Anyone aware of a macro for Confluence that I can use to render json content, collected from a url? Have several json-files used to prepare various stuff such as DNS-aliases (easier to provide commands for the domain admins than a list of manual tasks).

But for documentation purposes, for all to know which aliases we have, I would like to render this on a page in Confluence.

Former user

Hi @Rune Hellem,

So, since pulling JSON files that are hosted somewhere is pretty much equivalent to a REST GET request, you could use our app PocketQuery for it. The thing about PocketQuery is that it tries to display your JSON as a table per default which means it expects it to be in this layout:

[
  {"columnA": 1, "columnB": 2, ...}, // row 1
  {"columnA": 10, "columnB": 20, ...}, // row 2
  ...
]

PocketQuery however allows you to write Converter functions which let you transform your JSON into something that can be displayed as a table with a few lines of JavaScript. If you have any questions about it don't hesitate to ask here or raise a ticket at our ServiceDesk - we're happy to help!

Cheers,
Sven

P.S. If you want a small example of how you could set this up I recommend reading this blog post about PocketQuery.