Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Excerpt | ||
---|---|---|
| ||
Reuse existing tables from CSV files or Google Sheets. |
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 legacy 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
1. Insert the macro on a page:
- Start entering {Table from CSV} 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 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 & Spreadsheets app to process table data. |
Info |
---|
Combine the Table from CSV macro with other macros via the Table Toolbox macro to process table data. |
Handy Carousel |
---|
|
Table Excerpt | ||
---|---|---|
| ||
Storing authentication dataLogin 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 RDSIn Confluence Server/Data Center a secret key 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 Y our_Token
6. Save Request header
Info |
---|
In general, custom header consists of Auth_Type Your_Secret |
Handy Carousel |
---|