Hi,
I have a request for a report/list of spaces created w/in Confluence that includes:
name of space
created date
Space owner
URL
Is there a way to do this w/in Confluence?
Thanks in advance.
I wrote this script to pull the data, you can copy and paste it into the browser javascript console after you have logged into Confluence and it will print out the data you are looking for.
jQuery.ajax({ contentType: 'application/json', type: 'POST', url: contextPath + '/rpc/json-rpc/confluenceservice-v2/getSpaces', success: function( spaceSummaries ) { jQuery(spaceSummaries).each(function() { if (this.type === 'global') { var spaceKey = this.key; jQuery.ajax({ url: contextPath + "/rest/prototype/1/space/" + spaceKey, dataType: "json", success: function(spaceData) { console.log("Space - " + spaceData.name); console.log("Key - " + spaceData.key); console.log("Created - " + spaceData.createdDate.friendly); console.log("Last Modified - " + spaceData.lastModifiedDate.friendly); if (spaceData.hasOwnProperty("home")) { console.log("Creator - " + spaceData.home.creator.name); console.log("Last Modifier - " + spaceData.home.lastModifier.name); } console.log("URL - " + spaceData.link[1].href); console.log("----"); } }); } }); } });
EDIT: Here is a version that waits for the previous connection to finish before requesting a new one (it doesn't put so much pressure on your Confluence instance).
var parseSpaces = function(spaceSummaries) { var spaceSummary = spaceSummaries.shift(); if (spaceSummary.type === 'global') { var spaceKey = spaceSummary.key; jQuery.ajax({ url: contextPath + "/rest/prototype/1/space/" + spaceKey, dataType: "json", success: function(spaceData) { console.log("Space - " + spaceData.name); console.log("Key - " + spaceData.key); console.log("Created - " + spaceData.createdDate.friendly); console.log("Last Modified - " + spaceData.lastModifiedDate.friendly); if (spaceData.hasOwnProperty("home")) { console.log("Creator - " + spaceData.home.creator.name); console.log("Last Modifier - " + spaceData.home.lastModifier.name); } console.log("URL - " + spaceData.link[1].href); console.log("----"); if ( spaceSummaries.length > 0 ) { parseSpaces(spaceSummaries); } } }); } if ( spaceSummaries.length > 0 ) { parseSpaces(spaceSummaries); } } jQuery.ajax({ contentType: 'application/json', type: 'POST', url: contextPath + '/rpc/json-rpc/confluenceservice-v2/getSpaces', success: function( spaceSummaries ) { console.log("Starting..."); parseSpaces(spaceSummaries); } });
Hi Stephen, I have tried this, but it's only showing a small % of all spaces. I removed (this.type === 'global') condition and yet it shows 15-20 out of 200 spaces.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Adolfo, Are you using Firefox? I tried it with Firefox and it seems like it runs OK, but it also cuts off some of the results. It might be better in IE or Chrome. I also put in a new version, that might work better.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, it's FF. That new version works OK. Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here are a couple of options:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.