Is there a way to extract data from Atlassian Compass, either through an export feature, API, or int

Question

Our team is currently leveraging Compass to store application related info, and would like to be able to create custom dashboards in PowerBI to report this information - along with info from other applications such as Jira Core or Jira Service Management.

Has anyone done this before or know a solution?

Thanks!

Andrei_8eecdk · Answer

Hi @jessie_li

All of the data in Compass is available to consume using the Compass GraphQL API ( see https://developer.atlassian.com/cloud/compass/graphql/#overview ), so if you're comfortable building a pipeline that leverages that in order to export information, that should be able to get everything for you.

Depending on what the other products are, you might need to leverage their APIs ( per what @Sebastian Hesse mentioned above ), which can vary in terms of complexity.

If you don't mind me asking, what sorts of dashboards were you looking to create with this data? And do you happen to use Atlassian Analytics?

Sebastian Hesse_7i9tak · Answer

Hi @jessie_li , welcome to the community :-)

So, when you say "along with info from other applications", do you want to export your Compass components by including additional data from Jira? E.g. which Jira issues are connected to a specific component? I don't think that there's an out of the box solution. However, there was a similar question some while ago where they wanted to extract components into an Excel/CSV file and a script was posted to extract it via the GraphQL API: https://community.atlassian.com/t5/Compass-questions/Extract-Excel-from-Compass/qaq-p/2811552 Maybe that helps at least with one part of your question. You could extend that and make additional requests to Jira's REST API for each component.

Edit: We were missing such an export feature as well and hence, we have recently published an app Component Exporter to the marketplace which you can use to export your Compass component data to CSV, i.e. name, description, links, custom fields, etc. So everyone without time or scripting skills can export the data now as well :)  Maybe it helps in your specific case as well.