How to list all the page titles along with creators?

[Wojtek Jurewicz]

Hi,

I have a confluence site, and I need to export the list of all the sites titles along with their modification dates and users that have modified it. I can see that REST API can help me achieving this, i.e. this:

/rest/api/content?spaceKey=SPACEKEY&limit=100

gives me the list of pages, and I can extract titles from there. That's nice, but what REST API call can give me creators, modifiers and modification dates? It doesn't have to be a single REST API call, but even on separate I didn't manage to achieve what I need:

/rest/api/content/246645515?expand=body.storage

 If there are any other (than REST API) better ways to achieve it, I'd be happy to find out. Thank you!

[Srinatha T]

Hi @Wojtek Jurewicz ,

Welcome to Atlassian community. 

You can get the details from the database .  Below KB has the queries. 

• How-to-obtain-a-list-of-all-pages-their-authors-and-related-information 

Have a good day!

Thanks,

Srinath T