Hello,
I wanted to ask if there are ways to access the Confluence Database via a Plugin (using REST or some Manager classes etc.)
I want to be able to send Querys via a UI and return the table in the ui aswell
it needs to be dynamical (so no hardcoded connection string or something)
thank you for your time !
To access the Confluence database via a plugin using the Atlassian SDK, you typically need to use Active Objects (AO) or direct SQL queries through the Plugin Framework. Active Objects is the recommended approach as it provides an abstraction layer for database interactions. Ensure your plugin has the necessary permissions and dependencies configured in the atlassian-plugin.xml file.
What I’m doing is allowing the admin to write their query in the UI, and then, via a button, it’s directed to the code where it should send the query to the database and retrieve the result so I can present it as a table in the UI. The part I’m missing is how I can access the database through the Plugin Framework. What additional permissions and dependencies do I need to add in the atlassian-plugin.xml? (Sorry, I’m fairly new to developing plugins using the Atlassian SDK. In Jira, it was fairly easy, but not in Confluence.)