Atlassian

Beef up your JIRA and Confluence with custom scripts and automations. Create bespoke workflows, write scripts in scriptrunner, and build API integrations.
Data Engineering
28 Mar 2019

Building an ETL Pipeline: From JIRA to SQL

An example data pipeline which extracts data from the JIRA Cloud API and loads it to a SQL database.
Building an ETL Pipeline: From JIRA to SQL

Something we haven't done just yet on this site is walking through the humble process of creating data pipelines: the art of taking a bunch of data, changing said data, and putting it somewhere else. It's kind of a weird thing to be into, hence why the MoMA has been rejecting my submissions of Github repositories. Don't worry; I'll keep at it.

Something you don't see every day are people sharing their pipelines, which is understandable. Presumably, the other people who do this kind of stuff do it for work; nobody is happily building stupid pipelines in their free time

Continue Reading
Atlassian
31 Aug 2018

Recreate JIRA Service Desk in Python & Flask

When SaaS doesn't cut it, beat it down and take everything its got.
Recreate JIRA Service Desk in Python & Flask

When it comes to SaaS products in the realm of Service desks, JIRA Service Desk is at the very least, just as powerful as the next solution (Zendesk comes to mind). This naturally begs the question: Why is JIRA Service Desk's pricing model roughly 1/10th of that of it's competitor?

The answer lies within ease of use, but more importantly, presentation. While Atlassian's cloud offering is slowly playing catchup, Atlassian as a company has never quite seemed to nail down the importance of a friendly user interface, nor the importance of this when it comes to worldwide adoption. To

Continue Reading
Tableau
27 May 2018

JIRA Analysis in Tableau

Utilizing Tableau Desktop to visualize data pulled from JIRA.
JIRA Analysis in Tableau

Greetings to all my feathered friends upon this fine Memorial Day weekend. Seeing as how you're here, it appears as though we have a lot in common. Namely, we've chosen to spend our three-day weekends on the internet, as opposed to outside.

I've been meaning to build a  widget for this very blog for quite some time now. The vision is to embed a custom Kanban board, which would pull issues from our private JIRA instance to be publicly displayed and formatted to our liking. To my knowledge, nobody has bothered to attempt building something like this yet; probably for

Continue Reading
Python
01 May 2018

Python's Requests Library: Bring Your Scripts to the Web

Get familiar with what might become your most used Python library.
Python's Requests Library: Bring Your Scripts to the Web

Last episode we covered every programming noob's favorite 'A-ha' moment: making GET requests using AJAX. Stepping stones such as these can serve as great turning points in a career, but they also expose how little we still know. For instance, when we integrated the functional logic of APIs on the client side, we actually broke a cardinal rule: storing and passing private keys on the client side like an idiot. Does that make everything we learned useless? Not entirely, but kinda yeah.

Today we'll do the equivalent in Python by using the requests library. Requests is successor to Urllib, both

Continue Reading