How to get all child pages names, URLS, parent pages, page owner within Confluence space in Cloud

Question

How to get all child pages names, URLS, parent pages, page owner within Confluence space in Cloud.

Please share example CQL or steps(with screenshot would be fab!).

I found below links but didn't know where to start.

https://developer.atlassian.com/cloud/confluence/rest/#api-content-id-descendant-get 1.7k

https://developer.atlassian.com/cloud/confluence/rest/#api-content-id-descendant-type-get

I am looking to copy it over to excel.

Adrian Hülsmann - B1NARY · Answer

Hi @Niraj Rai

if your use case for exporting pages is content lifecycle management, you might check out the Confluence plugin Breeze.

Part of its extensive feature set is a CSV export containing all of your requested data, which can be easily further processed in Excel.

This blog post shows some use cases while the documentation explains which data is contained in the export.

Cheers, Adrian from B1NARY (developers of Breeze).

Humashankar VJ · Answer

Hi @Niraj Rai

You can give a try,

Check this post which provides a way to do it, but it's not pretty and it requires some scripting.

https://community.atlassian.com/t5/Confluence-questions/List-all-pages-in-a-space-showing-titles-of-page-and-IDs/qaq-p/855277

The below help is secondary:

https://confluence.atlassian.com/confkb/how-to-obtain-a-list-of-all-pages-their-authors-and-related-information-from-the-confluence-database-968687591.html

Happy to help further !!

Hope this helps

Thank you very much and have a fantastic day!
Warm regards