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!
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!
If the resulting storage format of the page contains no metadata about the way it was created via transformation, it is not possible to see this. What you try to do is to create some event listener and save data to logs/DB or some other way so that you will be able to retrieve it later.
