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

[jessie_li]

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]

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]

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.