Auto update JIRA reporting in Spotfire®

Introduction

In this quick tutorial video we will show how to visualize a JIRA custom report or filter in Spotfire^® and keep the data up to date using automation services.

Script example

The powershell script mentioned in video 

function Encode-Credentials([string]$username, [string]$password) {
  $credentials = "{0}:{1}" -f $username, $password
  $bytes = [System.Text.Encoding]::UTF8.GetBytes($credentials)

  return [System.Convert]::ToBase64String($bytes)
}
 
$url = "URL COPIED FROM JIRA"

$request = [System.Net.WebRequest]::Create($url)
$request.ContentType = "application/json"
$request.Method = "GET"

$credentials = Encode-Credentials -username "*******" -password "*******"

$request.Headers.Add("Authorization", "Basic " + $credentials)

$response = $request.GetResponse()
$stream = $response.GetResponseStream()
$sr = New-Object System.IO.StreamReader $stream

$sr.ReadToEnd() | Out-File C:\Users\Administrator\test4.csv ##save locally

Copy-Item -Path C:\Users\Administrator\test4.csv -Destination \\SPOTFIREDEMO\myshare ## copy to sahred folder