You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I recently had to download all the .swf file from our confluence site.
The solution online sent me to a page that showed the attachments and then I had to click someting to download it.
This gave me a direct link to every file I needed.
Below is the PostgreSQL query created to assist me in this task.
SELECT title, version, pageid, 'https://your-server-here/download/attachments/' || pageid || '/' || title || '?version=' || version as URL FROM content WHERE contenttype = 'ATTACHMENT' AND title like '%.swf' AND prevver IS NULL AND spaceid IS NOT NULL ORDER BY lastmoddate DESC
From here you could do all kinds of things like generate a CURL command and pull every file down.
For me I just emailed the URL column to myself and clicked each link.