Is there a way to export a list of all space keys?

[Cindy]

Is there a way to export a list of space keys (including personal spaces) in Confluence? Or a way to run a JQL query for this data?

Thanks!

[AnnWorley · Accepted solution]

I didn't find a way in the Confluence interface but if you have access to the database you can run a SQL query:

select spacename, spacekey from spaces;

[Cindy]

Thank you!!

[Davin Studer]

You could use the REST API.

http(s)://{your server}/rest/api/space?limit=500