Creation of dynamically populated tables

[Steve Hodson]

I have pages held within Confluence that describe my company's IT solution based in AWS.  As such this data in AWS sometimes changes, additional networks or virtual machines, and at the moment the way to make sure this data is kept in-sync with the solutions in AWS is by hand.

It would be great to be able to write a script that can gather and display this data and have the confidence that this displays the latest information.  There are many hurdles to cross, namely how would I write a script and upload to Atlassian and once there how would it authenticate but these are all solvable.

I was wondering if the community knows of a macro or technique I could employ to achieve this.

Thanks in advance,

Steve

[Katerina Kovriga {Stiltsoft} · Accepted solution]

Hi @Steve Hodson ,

If you have the possibility to somehow pull your data out of the AWS in CSV or JSON format, then you can browse the Atlassian Marketplace for the apps that allow you to create tables based on such files (I think there even will be free add-ons).

Our app - Table Filter and Charts for Confluence - is generally used for filtration, data aggregation, visualization and table calculations. But we also provide the Table from CSV and Table from JSON macros that allow you to create dynamically changing Confluence tables based on CSV, TSV and JSON data sources (attachments and URLs, the latter option may really suit your case).

[Steve Hodson]

Thank you @Katerina Kovriga {Stiltsoft} the suggestion of using Table from CSV does fit my use case.