Table Filter and Charts for Confluence
Space shortcuts
Page tree

Versions Compared

Old Version 37

changes.mady.by.user Katerina Rudkovskaya

Saved on

compared with

New Version Current

changes.mady.by.user Katerina Rudkovskaya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Table from CSV macro allows you to output a table from CSV or TSV data source.

The macro supports outputting data from a URL or an attached file.



Using the Table from CSV macro

1. Insert the macro on a page:

  • Start entering {Table from CSV} (or /Table from CSV in the new Cloud editor) and select the macro
  • Or on the editor pane, click Insert more content -> Other macros, find the macro and insert it on the page


Handy Carousel


2. Specify the CSV source option:

  • URL
  • Attachment
Info

If the URL is local, please add it to the Allowed URL list.


Info

You can use {pageId} variable in the URL, which means ID of the current page.


3. Find the attachment by typing the file name.

4. Or configure a URL:

  • Add a URL to CSV
  • Select the Authentication type

  • Optionally set the login and password settings, the authentication header, additional headers.


Info

The request headers format: 

Header name: header value
Another header: another value

The header name and its value should be separated by a colon, headers by line breaks.

5. Select an appropriate data format and encoding from the list or add it manually.

6. Specify a delimiter.

7. Save the macro and update the page.

Info

Combine the Table from CSV macro with other macros bundled in the Table Filter and Charts app to process table data.



Handy Carousel

Image Added



Table Excerpt
nameStoring auth data

Storing authentication data

Login and password or a custom authentication header are encrypted by the AES-256 algorithm using a secret key and are saved in the macro parameters.

In Confluence Cloud, a secret key is stored in the encrypted AWS RDS, and in Confluence Server/Data Center is generated individually for each Confluence instance.

The encrypted authentication data can be used only in your Confluence instance and only for the URL you specified when configured the macro, so it is impossible to steal it and use somewhere else.



Handy Carousel


Custom Authentication with a Bitbucket access token

1. Create a personal access token in your Bitbucket account.
2. Insert the Table from CSV macro on the Confluence page.
3. Add a URL to CSV.
4. Select the Authentication type: Custom. 
5. Use Bearer Auth without the username.
Change request header: Bearer Your_Token
6. Save Request header

Info
In general, custom header consists of Auth_Type Your_Secret



Handy Carousel