Get a list of all pages updated in the last 24h via REST API

Question

Hi all, we're using Confluence Cloud as KB for our ITSM projects. Many of our customers rely on the KB but there is no way for them to be informed about any pages that we publish or updated. Unfortunately, a feature request that would allow customers to "watch" certain KB pages is not very high on any priority list (JSDCLOUD-5719). To take matters in our own hands, I wanted to query the last modified pages once a day (Power Automate) and then inform our users via an email list they can subscribe to. I'm struggling with the correct API call however: https://.atlassian.net/wiki/rest/api/content/search?cql=parent= order by lastmodified desc&limit=10&status=current this appears to work but does not order correctly and of course it's missing the limit to only tickets updated/created in last 24h. I would also need to exclude any pages that have restrictions applied to them or that are in draft. Has anyone done this successfully before? Any help would be greatly appreciated! Thanks, Thomas

Thomas · Answer

Sorry apps don't help me here. I need to get this through the REST API so I can parse and send an email to a distribution list. We have already built a KB page that is accessible to customers through the service desk, however, we have currently no way to inform them about new content, so they need to check the page manually.

Balázs Szakál [META-INF] · Answer

Hey @Thomas ,

We have an app that can showcase unread/updated pages for you and your team, while you can also filter for specific things like pages updated yesterday and many more.

This is Advanced Content Navigator, and I'm pretty sure you gonna love it! :)

If you need multi-space filtering, we have that too!

Let me know if you miss something!

Best Regards,

Balazs

Kristian Klima_gtcuat · Answer

Hi @Thomas

Take a look at Confluence Databases - as a temp solution.

You can use 'Import' feature and create an ad hoc DB with pages updates in a certain period of time.

You can further refine/filter the DB by space etc.

LImitation: Confluence DB currently doesn't support restrictions data so you would have to use a label on pages where you applied restrictions. Then you could filter by label.