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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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¯oNumber=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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Turns out its some internal proxy that is creating a bit of trouble for us :) Thanx!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hope you'll make everything work as expected!
Unfortunately, we don't have a Power BI instance to check the authorization peculiarities.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.