Dynamically create confluence pages

[Samuel Ampipoikayil]

Hello all,

My requirement is I have all details to create a page based on details on an oracle database table.

My plan is to run a script which my page with all the markup language syntax and manually copy the output of the script to create a page. 

The output will be a predefined format in markup language.

I need advise,

- Can i directly use confluence to query the database from time to time and update the page 

- Can I do a Rest API call to update a page using the output file as I mentioned above(with markup language tags)

Regards,

leaumas

[Najjar _Innovura_ · Accepted solution]

Hi Samuel

We launched a new app that allows you to create pages from templates through Jira Workflow post-function and store the Confluence page in a Jira customfield to apply more actions like:

Workflow postfuntions

• Update page permissions
• Update page content
• Update page title

Workflow conditions

• Check if page was modified after a certain status transition
• Check if page still has a placeholder

And so much more.

Please give it a try, I believe it would streamline alot of repeated effort on your team

Jira Confluence Workflow Extensions (JCWE) 

Give it a try I am confident you'll love it.

If you have any inquires or requests please drop me an email at admin@innovura.io

[Pavel Potcheptsov · Accepted solution]

1)  you can't. There're plugins to query database but they won't help you to update page.

2) you have to prepare json file for Page and include content in storage format there, then you can update page with api.

[Samuel Ampipoikayil]

Thank you Pavel!

[Andrii Maliuta]

Hello Samuel.

You can try Confluence CLI (https://marketplace.atlassian.com/apps/284/confluence-command-line-interface-cli?hosting=cloud&tab=overview) to bulk update pages from prepared text files or files hierarchy etc.