Where is the comment information stored?

[yoshihiro.hagihara]

I'm trying to use an RPA tool to extract data from comments entered on each page of Confluence, but I have the following issues and would like to know how to solve them.

1. What you want to solve

1-1. I can't understand the parent-child relationship of the comments.

All comments for each page are output, but in many cases there are multiple parent comments for one page, and it is unclear where the items indicating the parent-child relationships are stored.

1-2. The commenter is not output.

Nothing is output to the CreatedByUserName field in the Comments table, so it is not possible to know who made the comment.

2. Background

2-1. I want to output a file in CSV format that allows me to understand the comments on each page (design deliverable) created on Confluence and the child comments on those pages (parent-child relationships of comments).

2-2. I want to output the following items to a file.

3. Situation

3-1. All table Pages and Comments were output to a file. (However, it is unclear whether the output source is correct.)

3-2. I don't know how to identify the parent-child relationship of comments. (I couldn't find any items in the tables Pages and Comments that seem to fit that description.)

3-3. I don't know how to identify the commenter. (I guessed it was the CreatedByUserName field in the Comments table, but all the records are blank so I can't identify it.)

[Shawn Doyle - ReleaseTEAM]

Hi @yoshihiro.hagihara 

You are probably looking for authorId.

If you look at the API doc for the cloud,

https://developer.atlassian.com/cloud/confluence/rest/v2/api-group-comment/#api-custom-content-id-footer-comments-get

You can see the field names in the 200 Response box on the right side of the page.  While this is not 100% guaranteed to equal the database fields, it's usually correct or close enough to figure out.

[yoshihiro.hagihara]

Hi @Shawn Doyle - ReleaseTEAM 

Thanks for reply.

But what I'm looking for is table definition, because I'm trying to get data from table directly using RPA, not via API.