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

Question

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.

Katerina Rudkovskaya _Stiltsoft_ · Answer

Hello @GK

In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality:

CSV/JSON import via URL will be moved out of the main app due to platform-specific constraints. However, it will remain available to all customers for free through a fully compatible companion app — Live Tables from CSV & JSON, developed and maintained by our team.

This app allows you to import CSV, TSV, or JSON not only directly from attachments, but also from URLs, connect external sources like APIs or Google Sheets, and automatically keep data updated.

Stiltsoft support · Answer

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).

GK_tmgug6 · Answer

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! :)