How to Display a HTML Table from a URL as a Confluence Table

Overview

This howto provides step-by-step instructions on how to display a table, scraped from a URL, as a table on a Confluence page.

Let’s assume there is one or more HTML-formatted tables, located on some Web page at some URL. To scrape and display one of the HTML tables on your Confluence page as Confluence table, follow the steps below.

Prerequisites

  1. Confluence (Server)

  2. SQL-Powered Table Transformer macro for Confluence installed

  3. Documentation: https://v-and-b.atlassian.net/wiki/spaces/PD/pages/1127186433/Table+Scraper+from+URL+Macro

Step-by-Step Instructions

  1. Create an empty Confluence page

  2. Edit the page

  3. Include “Table Scraper from URL“ user macro into the page

  4. Click the macro container and select “Edit” (Edit macro dialog will appear)

  5. In the Edit macro:

    1. set the URL parameter to the desired URL with a HTML table.

    2. set the Tables Selector parameter to the desired CSS-selector. If set to default (table), then all tables within any <table></table> tags will be selected.

    3. set the Table Index Number parameter to the index of the desired table in those, selected by the Tables Selector (first table’s index is 1, 2nd table’s index is 2, etc.). You can indicate only one index.

  6. Set other parameters as you desire (refer to https://v-and-b.atlassian.net/wiki/spaces/PD/pages/1127186433/Table+Scraper+from+URL+Macro )

  7. Save the macro.

  8. Save the page.

  9. When the page loads it will have the table, built from the table, scraped from the URL.