Missing parentid in csv export

Question

Hi!

I have exported an entire space, but when I'm reviewing the "content" csv, I noticed there are over a thousand pages that do not have a value in the parentid column. I looked a few of them up, and they are located in folders which appear on the content list with content ids. Any ideas as to why this information would be missing in the export? Thanks!

Aron Gombas _Midori_ · Answer

With the Better Content Archiving app, you can add the "Parent" column to all content list views. This column displays folder type parents, as well:

And when you export the list to CSV (see the icon under the list), the resulted CSV contains:

* the "Parent URL" column (where URLs also contain the ID)
* the "Parent ID" column (with only the ID itself)

Both these columns work for folders with no difference.

(Discl. this paid and supported app is developed by our team. Free for 10 users.)

Ahmed Oyeleke · Answer

Thank you, Martin! I will try this approach.

Martin Runge · Answer

Hi @Ahmed Oyeleke

I believe this limitation of the space export CSV in Confluence Cloud arises because, since Atlassian added folders as a content type, pages within folders sometimes lack the folder's content ID in the parentid column. The export, designed around a traditional page hierarchy, may not accurately reflect folder parentage.

To get reliable parent information, u could try using the Confluence v2 REST API instead:

GET /wiki/api/v2/pages?space-id={spaceId}&limit=250

Cheers, Martin