I need to be able to export a table from Confluence into CSV or Excel file?

[Lynn Crush]

Either from an Excel file that I post or from a native Confluence table.  Either way I have to have an editable file on a confluence page that can have the data exported out.

[Katerina Kovriga _Stiltsoft_]

Hi @Lynn Crush ,

We can suggest trying our Table Filter and Charts for Confluence app (the app is developed by our company).

You'll be able to export your tables in the CSV format using the Table Filter macro and/or CSV/XLSX formats with the help of the Table Spreadsheet macro.

[Dave Fey]

can the csv export be done programatically?  I see how to manually export but was hoping to export/import directly through a gsheet

[Stiltsoft support]

Hi @Dave Fey ,

Unfortunately, the export can't be done automatically.

What concerns import from Google Sheets, it is possible to connect your sheet via the Table from CSV macro. Then any changes made to the Google Sheet will be automatically visible in Confluence.

[Tommy Strømme]

Any update on this?

I work with Power BI. I find that a dashboard for our projects is is lightning fast  there compared to the filtered dashboard i have created in Confluence.

I use Table filter and Table Transformer to filter my page properties report. I have used the "Copy the filter URL" tool and I have the result as a favourite in Edge. This means I can go directly to that , click on export to csv, click ok again to export the csv.

I then have to move it to onedrive (as it defaults to Download folder without option to change) and then rename it to the name of the csv which is automatically picked up by Power BI. 

I really need to get this automated so it exports and overwrites every hour or so. We're running DataCenter version. Surely there must be somewhere I can feed that URL into and specify some parameters for interval, save-location and overwriting?

[Alexey Mikhaylov _Stiltsoft_]

Hello @Tommy Strømme,

Please be informed that we have a task in our backlog to provide REST API for CSV Export in Confluence Data Center. I've added your vote for it. If this is implemented in future, we will let you know.

[Stiltsoft support]

Hi @Tommy Strømme ,

Finally, we are here with the update regarding the Export to CSV API - please check this abstract from our documentation with the description of the new feature.

Hope it helps your cases.

[Tommy Strømme]

Hi, 

Glad this is in place and finally I have some time to implement this :-) 

I created a URL from the documentation and it straight away downloaded the correct CSV :)

However, I want Power BI do do this and I have created a PAT in Confluence and tried to create a new data source following chatgpt's suggesions..however it fails all the time. This is the reciepe i have been trying (we got datacenter btw). I believe its the authentication that fails somehow. Any idea how to get this right?

let
url = "http://urlthatworksinthebrowswer/macroName=table-filter&macroNumber=1",
authHeader = "Bearer MY_PERSONAL_ACCESS_TOKEN",

Source = Web.Contents(url, [
Headers = [Authorization = authHeader, #"User-Agent" = "Power BI"]
]),

CSV = Csv.Document(Source, [Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None]),
PromotedHeaders = Table.PromoteHeaders(CSV, [PromoteAllScalars=true])
in
PromotedHeaders

[Stiltsoft support]

If the manual url downloads the data as expected, seems that the feature is working.

You may exclude our url from the script and and try something simple to check the permissions.

[Tommy Strømme]

Turns out its some internal proxy that is creating a bit of trouble for us :) Thanx!

[Stiltsoft support]

Hope you'll make everything work as expected!

Unfortunately, we don't have a Power BI instance to check the authorization peculiarities.

[Tommy Strømme]

Hi Stillsoft!

We managed to get by the proxy stuff and now the api is working. One quesitons though. In the old days where we did it super manual and clicking on the "Export to CSV" on the table filter, the CSV would have the full URL to the confluence page in the title field. LIke this:

=HYPERLINK("https://XXXXXX/XXXX-Pilot")

Using the API its only listing: "Pilot" in the TItle field. Very nice an clean for most of the fields, but when you would like to be able to click on the titles in Power BI for instance, you would also need the URL to the actual page. 

Is there any trick I'm not seeing in order to get the URL from the page properties csv export?

Best Regards

TOmmy

[Stiltsoft support]

Hi @Tommy Strømme ,

Currently the parameter to fetch URLs is not supported in the API request.

We've created a new ticket for our internal backlog though. Once the feature is implemented, we'll get back here. 

[Tommy Strømme]

Much appreaciated!