Display CSV file on a page

Question

I have the following scenario:

* Daily generate a new copy of a CSV file in a cron job
* The CSV file will not always have the same number of rows
* Embed the CSV on a Confluence page, which has other information

Notes:

* The CSV will be generated on a Linux-based system in Python
* Would like to use the REST APIs to update the Confluence page in Python
* Would like to avoid any 3rd party tools or macros

Questions:

* Can I upload the CSV to be stored as content in Confluence, but is not directly viewable?
* Can I just create a Confluence page which references the stored CSV file?

Stiltsoft support · Answer

Hi @Jonathan G ,

The Table from CSV macro is dynamic: if you connect it to your Google Spreadsheet and make any changes there or update the page attachment that is reflected through the macro, your result table will be updated as well.

And you may also try the Table Spreadsheet macro: you'll be able to upload your existing csv/xlsx file and continue to work with it right in Confluence (cell formulas, filtration, conditional formatting, pivot tables and other Excel-like features are supported).

If required, you may then export your spreadsheet in csv/xlsx formats.

Jonathan G_nr12px · Answer

@Katerina Kovriga _Stiltsoft_   are you able to update the csv and have it update the file in Confluence, or is it static once uploaded?

mdwebber · Answer

Jonathan - I have a similar problem as you in this question from last year. Did you ever come up with a solution that you can share? I just have to get an existing csv off of a network share onto a Confleunce page. Problem I have is I work for a large Corp and everything is locked down, Admins told me to use a REST and that will do it. Of course no one will tell me what the API secret is etc. A freakin disaster for me. Any loopback you can share (please)? michael w colorado