Hello, I’m from DevOps Tools Support Team. I’ve got the request from user. Is it possible to do from our Confluence Data Center v.9.2.20?
User request details: Aurélien Daunois
I would like an export of all images/videos/diagrams in our CEP confluence space.
I want the list of all these with, name, pagename and creator please.
I want all of them, except the one on “under review” section.
Hi @PiduguRishitha,
One CQL search covers most of it. Page with start until a page comes back short, because DC caps it at 200 per call once anything other than body is expanded, and the rest of the space won’t show up otherwise:
curl -H "Authorization: Bearer $PAT" "https://confluence.example.com/rest/api/content/search?cql=space%3DCEP%20AND%20type%3Dattachment&expand=container,history.createdBy,version.by&limit=200&start=0"
Then the fields. title is the file name. container.title is the page, history.createdBy the uploader.
No media type filter in CQL. I’d filter client-side on the extension (png, jpg, gif, svg, mp4, mov, drawio and so on) or on extensions.mediaType if your response carries it. Not run on 9.2.20 specifically.
“Under review” is the open bit. What marks it on your side: a label, a status lozenge in the page body, or a section of the page tree?
Hi @PiduguRishitha,
as this sound like a usual end-user request that you have to solve, just saying that this is the Atlassian Developer Community. https://community.atlassian.com/ is the other one. And this is as well not the official support.
Anyhow, as you are on data center, i think a custom HTML Export of the hole space is the fastest way for you to export the raw data incl. the related pages as static HTML (Export Content to Word, PDF, HTML and XML | Confluence Data Center 9.2 | Atlassian Documentation).
If you really need the other metadata, then the database is your friend. As a starting point, this might help you (How do I list all attachments in Confluence with their location and file sizes? | Confluence | Atlassian Support).