Integrating Jira and Google Data Studio - Part 2
This is the second article in a series on using Google Data Studio with Jira Cloud.
See the first installment here:https://www.dhirubhai.net/pulse/integrating-jira-google-data-studio-part-1-william-kennedy
I find working with Jira data in this way beneficial because it exposes deep attributes (custom field IDs) and offers an opportunity to work with standard data in a new way. Additional benefit may come from separating your reporting from Jira, or blending data from other sources.
With this method, we can craft structured calls to Jira, turning the JSON response into a table and use the resulting tables as a data source in Data Studio.
If you follow along or download the provided examples, we should have:
- Basic connection details, including your new API Token (need Admin access)
- Google Sheets (tabs) suitable for multiple essential API calls (Myself, Projects, Users, Groups, Issuetypes, Fields and configuration scheme information)
- Data Studio Wallboard to show your users with elevated privileges.
In the first article, we prepared a basic google sheet with credentials and a call to the 'field' REST endpoint.
You should have at hand:
- A new Jira API Token for this exercise (https://id.atlassian.com/manage-profile/security/api-tokens and encode using Base64 a string with your username and API token separated by a colon (username:token)
- Jira Springboard sheet - you can save some time and use this one: https://docs.google.com/spreadsheets/d/1jvNO3wRJWk_JjOE9oTZobQVtB423Jq1-gXi3YW65AsE
Edit cell B4 to contain your encoded username:token string and verify your username is returned:
You can read more about importjson.gs here:
Now let's create a data source in Google Data Studio!
Access Google Data Studio: https://datastudio.google.com
Click 'Create' button, then select 'Data source'.
Select the spreadsheet you created earlier, and in the Options panel, provide the range to ignore on import and uncheck import hidden fields. Provide this range: a5:zzz99999 (modify as needed).
Click 'Add'
Review the fields and click 'Create report'
For this example, we'll modify the table view that is created by default to explore some of the charting capabilities available.
Here's my example - you will need to change the datasource to your copy of the springboard spreadsheet: https://datastudio.google.com/reporting/dba7ab1f-e1d1-4a59-b47c-032e6a36da42
You can also embed these reports in Google Sites: https://sites.google.com/view/a9-top20-marketplace/home
Join me in Part 3 where we will explore creating a Google Sites dashboard using Jira data
