Inserting programatically pages into confluence

[Jochen "Joe" Herrmann]

Hi all,

for documentation purposes we want to be able to insert data from a RDBMs system into conflucence and(!) want to be able to programatically update them daily.

Any idea whether this is possible and how this could be done ?

TIA,

Joe

[Stephen Deutsch]

Hi Joe,

I see two options for you:

1. Since your data is in a relational database, you could use a Marketplace app that can read SQL and bring it into Confluence. This would ensure that your pages are always up-to-date:

https://marketplace.atlassian.com/search?product=confluence&query=sql

There are even a few free ones (filter using the options on the left).

2. You could write a small script that reads from the DB and updates your page(s) using the REST API. You can see some examples of how to do so here:

https://developer.atlassian.com/server/confluence/confluence-rest-api-examples/#update-a-page

[Jochen "Joe" Herrmann]

Hi Stephen,

thanks for your reply. Will stroll a bit on the marketplace :-)

Only if I can't find something that fits, I will throw an eye on the  rest api.

Thanks again, Joe

[Jochen "Joe" Herrmann]

Hi there,

found another easier way: {html-include} combined with an entry in the whitelist.

As it's all internal , there is nearly no risk.

Thx, Joe

[Stephen Deutsch]

Sounds like a good solution when you can expose the information as HTML. Glad that you figured something out.