Updating a Confluence pages with information from different sources (json, csv, excel, etc.)

[GK]

We have a Docupedia Space (Confluence) which we use to spread knowledge about products. For each product we have one Docupedia page, based on same template.

The information which we have in these pages is coming from diverse storages, databases. They contain even deeper information about the products and the access is restricted. We put in Docupedia only brief information and unrestricted information.

When information has to be updated, we must update in the source of truth (databases) but then also in Docupedia pages.

I search for solution, which allows us to update the information in the Confluence pages automatically, e.g. by using excel, csv, json, etc.

Thank you very much.

[Stiltsoft support]

Hi @GK ,

Maybe your company uses our Table Filter, Charts & Spreadsheets for Confluence app to work with tables - please note that the plugin also provides the Table from CSV and Table from JSON macros.

They automatically recreate tables from attachments and URLs (you change the source data and the recreated table is also updated). Please check the links to the macro descriptions given above - maybe it will help your case.

[GK]

Thank you very much for the fast answer! :)

At least from my understanding of the given solutions, my use case is different. I will try to describe it better.

Each docupedia page is based on same template and contains: product name, responsible, short description, block diagram, etc... For each product, we have it's own docupedia page.

Assume we have csv file, which is an extract from a database and contains: product name, responsible, and short description for all the products. So the responsible and short description for each product, should be updated in the respective docupedia page which has the same title as the product name.

The block diagrams are saved in windows folders or in SharePoint. The links could be in the same csv file or in a different file. In docupedia pages, not the link, but the figure should be automatically updated.

So, in principle: information from csv file is spread in many pages, not in a table.

I hope, my second description is more understandable.

I am very new with Confluence, thank you very much for your support! :)

[Stiltsoft support]

Theoretically, you may insert the Table from CSV macro on any page and as many pages as you need. It will grab all the data that you have in your database.

And for each page there will be filters on top that will filter your big table and show only relevant data for each product. Once the database is updated, all the mirrored tables that you get using the Table from CSV macros are also updated and the applied filters continue to show only relevant data.

But the issue is in Sharepoint: our macro supports Google Sheets and your local databases, of course, but Sharepoint has some issues with authentication and is not supported by our app.

You may try to browse Atlassian Marketplace for some Sharepoint connectors or smth similar, because I really don't think that it is possible to achieve your case natively. And you may also create a new question with a more thorough description - maybe it will attract users with similar cases or other vendors (we also search for relevant questions here manually using the keywords).