Page activity

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

2 answers

0 votes

I found it:

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.