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!