How to Retrieve Data from a Confluence Page with Table Transformer Macro via API

Confluence Development
1

Hello,

I am working with Confluence 8.5.12 (on-premise) and I need to extract data from a Confluence page that contains a table created using the Table Transformer Macro, which relies on SQL queries based on another table from a different Confluence page.

I have tried the following API calls:

  • /rest/api/content/XXXX?expand=body.storage
  • /rest/api/content/XXXX?expand=body.view

Additionally, I attempted to export the data in various formats like PDF and CSV, but I was only able to retrieve information about the macro itself or data from the original source table, not the processed results displayed by the Table Transformer.

Could you please advise on how to retrieve the transformed table data via the Confluence API? Any suggestions or guidance would be greatly appreciated.

Thank you very much in advance!

2

Have you tried to enclose all your tables in Table Excerpts and then use a Table excerpt include for each one to incorporate them into the new Table transformer? This works for me (ver 6.0 on-premise).