With this month’s release of PocketQuery for Confluence Cloud we have made significant progress closing down the gap between the Server & Cloud versions, working towards the magical state of feature parity! 🦄 Just like with the last Task Reminder Cloud release, we are once more dropping 3 big new features that will help you be more productive in Confluence! So, let’s have a look at what’s been added.

Charts 📈 📊

Yes! They’re here! Transform your plain PocketQuery tables into beautiful charts, using the powerful Google Charts engine. We’ve added a new part to our getting started guide to show you how easy it is to use them. You can check it out here. If you’re interested in learning more details about what types of charts there are, and how they can be customized, we recommend taking a look at the PocketQuery Chart API documentation.

Visualize your Query results with charts!

JavaScript API ⚙️

You probably know already that PocketQuery results can be rendered into just about everything, using the powerful Apache Velocity language. But for certain parts, such as charts, using JavaScript is often an easier way to go. For this reason, you’ll now find three new JavaScript API functions that you can use in Templates to render your PocketQuery result via JavaScript:

  • PocketQuery.queryJson() - Get the Query result as JSON.

  • PocketQuery.queryArray() - Get the Query result as an Array.

  • PocketQuery.queryColumns() - Get all columns (table headers) of your Query result.

You can find the full documentation for them here.

OAuth2 Support 🔀

One of the great features of PocketQuery is its versatility when it comes to connecting to different types of external datasources. You can connect it to just about any external system - be it a REST API or a JDBC database. With this release, we doubled down on that and implemented support for REST APIs that require OAuth2 authentication. If you are interested to learn more, check out this page.

PocketQuery now supports OAuth2!

That’s it for now! We hope to see you with more amazing features soon. Stay tuned!

What’s next?