Confluence 6.2/Oracle : which database table contains content of Confluence pages

[Rafal Sojka]

Hi,

Do you know if this is possible to identify the database table name in which the content of all pages is stored ? We would like to implement application that connects with Confluence database in read-only mode (in this case it is Oracle,) and retrieve the content of a few pages for further analysis.

Thank you for help,
Rafal

[Nic Brough -Adaptavist- · Accepted solution]

The table is Bodycontent, but you really do not want to do this.

To make sense of the content, you're going to have to write a parser to read and interpret the content into something you can read and analyse properly.

If you do this the right way, instead of SQL, it will be far easier - use REST to get the content.

[Rafal Sojka]

Thank you Nic, I think you are right and we should switch to REST.  Do you know if there is any document showing how to get a page content using REST  ? 

Best regards,
Rafal

[Nic Brough -Adaptavist-]

Have a look through https://developer.atlassian.com/server/confluence/confluence-rest-api-examples/ and the docs around it

[Rafal Sojka]

Thank you, right, it will be very useful.