nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Nic Brough -Adaptavist-

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.

All comments

Nic Brough -Adaptavist-

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence