Is ScriptRunner able to access a Confluence database content and actions?

[Sean]

I'm new to ScriptRunner and want to create a script that will listen for a new page created with a specific label and then dynamically add an entry to a Confluence Database with fields from that page.

A small example would be a database named "Product Info" with fields "Page Link", "Text: [Name Field]", "Media: [Image Field]"

Where the Page Link is the link to the confluence page, Name is a field on the page properties for the page, and Image is a field on the page properties.

Is there a way to have ScriptRunner update this database dynamically when these pages are created?

[Kristian Walker _Adaptavist_ · Accepted solution]

Hi Sean,

I can confirm that ScriptRunner for Confluence Cloud can only interact with Confluence Cloud via the Confluence Cloud Rest API's.

This means if there is an API to insert into the database, you can use this in your script; otherwise, your requirement will not be met. 

Looking at the database API, it does not look like Atlassian provides any APIs to update databases which means this requirement is not possible to achieve.

I hope this information helps.

Regards,

Kristian

[Sean]

Thanks, Kristian. This is what Iw as expecting. Confluence has a lot of work to bring their database feature up to par with other services.

[Trudy Claspill]

Hello @Sean 

Welcome to the Atlassian community.

When I search the Scriptrunner for Confluence Cloud documentation for "database", no results are found. Drilling down into individual feature pages in the documentation I also don't see any references to interacting with Confluence Databases.

My deduction is there is no support for interacting with Confluence Databases.

But you might want to confirm that by opening a support case directly with Adaptavist (unless some of their team members within this community respond to your question here first).

https://docs.adaptavist.com/sr4cc/latest/get-help/support

[Sean]

Thanks, Trudy! I will check over there and see if they have any ideas. I was expecting that there wasn't much yet since this feature is still relatively new.