Export page history for a specific page ID

[Roberta Bortolotti]

Hi,

I need to export the page history for specific pages within a space. I found this information that references the SQL query for the whole space: https://confluence.atlassian.com/confkb/how-can-i-export-page-version-history-details-for-a-given-space-965567214.html

A few question:

1) does anyone know if the information we see in a page history can be exported to a spreadsheet?

2) in this SQL query, how or where do I specify the pageID?

3) does anyone have this same issue? How did you solve it?

Thanks,

Roberta

[Brant Schroeder · Accepted solution]

@Roberta Bortolotti I would suggest using the API to pull page history via the REST API in JSON and transforming it to CSV which could be opened in a spreadsheet.  

https://docs.atlassian.com/atlassian-confluence/REST/6.6.0/#content-getHistory