Page activity

Question

Hello. Which tables store the information displayed on Page Activity?

There is a need to get data in the following format:
contentid, title, version, status, date of status set or change, actor

Артём Шабрин · Answer

I found it:

select text_val from os_propertyentry where entity_key = 'com.comalatech.states'

Артём Шабрин · Answer

Unfortunately, the REST API is not suitable for me, because I need the information to fill the data mart

Alex Koxaras -Relational- · Answer

Hi @Артём Шабрин and welcome to the community,

I don't think that the tables on cloud are known to the public. You can use REST API to get all the available info https://developer.atlassian.com/cloud/confluence/rest/v1/intro/

Let me know if that helps.