The goal of today’s task is to utilise Alteryx to download whisky auction data from the Whisky Hunter API. The Alteryx “Download” tool is ideal for connecting API using a simple drag-and-drop interface. You can use the “Download ” tool to build a connector that authenticates, downloads, transforms, and publishes data all in one workflow.

The Whisky API

The Whisky Hunter API is a public API that does not require any authentication or API key to get access. The primary URL is, and here is the detailed URL I am going to use. 

The data I want to download is the distillery auction information; The challenging part here is to first use the URL ” /distilleries_info​/ ” to get the distilleries name and then combine the distilleries name  and the distillery information URL “/distillery_data/{slug}/” to get the distillery auction information

The best way to start with the download tool is to create an ‘Input Data’ node, add a field for the API URL, and connect to the “Download” tool. Since this API is going to return the result in JSON format. I will connect the JSON parse tool after the download tool, and the Alteryx will parse the JSON data based on the key-value pare.

Here is my Alteryx workflow:

Key finding in the dashboard

  • It is found that the trading volume has increate almost 150 times in 2020 compared to 2006. By grouping the distillery by their first auction year to compare trading volume contributions annually across cohorts. The minimum auction date per distillery will give the first auction date. It is found that almost 88% of trading volume is contributed by the distilleries, which was the first auction in 2006
  • Looking at the Year over Year growth rate, we notice an average 45% YOY growth rate between 2006 and 2020. However, there the YOY growth rate dropped significantly after 2019, and the growth rate bottom at 4% at 2020
  • Let us use the 80/20 rule to analyze the distillery further; 20% of the distillery already generates 88% of the trading volume. And the top 1 distillery, which is Macallan, contributes 23.1 % of the trading volume. And the 2nd top Karuizawa , which was the first auction in 2007 and it contributed 7.5% of trading
  • I discovered that the low YoY growth rate is primarily attributable to top distilleries; specifically, the 2nd top Karuizawa found no YOY growth rate, and the recent new distillery has not become popular, as evidenced by the fact that the new product contributes less than 5% of the trading volume.

Based on the above founding, if you want to do business to sell the whisky of a particular distillery, the dashboard also shows the bull /bear trend regarding the trading volume for each distillery. If you are going to choose a whisky of distillery put on to auction, you may pick up a whisky for a bull trend with recent longest consecutive higher value

Gary Li
Author: Gary Li