Using REST API Through HTTP Request and JMP Maps to Understand German Brewery Density (2020-EU-EPO-388)

[#1]

Level: Intermediate

Alexa Baltazar, JMP Data Scientist, JMP
Andy Zhou, JMP Technical Intern, SAS

Did you know that there are approximately 1,300 breweries in Germany producing over 5,000 brands of beer? With enough beer options to drink a different German beer every day for 15 years, we want to use JMP to understand the density of breweries in different German states.

In this presentation, you will learn how we used a REST API to bring German brewery data into JMP and then enhance it with geographic data to create interactive, density maps in JMP. REST API data requests can be executed using JMP’s HTTP Request, with the data often formatted as a JSON file. This JSON file can be imported into JMP using JMP 15’s newest feature, Import Wizards. JMP 15 has built in mapping tools that will allow us to show brewery density in Germany. These findings will then be published to JMP Live, JMP's collaborative analytics software for sharing interactive reports.

Prost!

[pauldeen]

Can you also share the jsl file behind this presentation?

[andyzhou]

@pauldeen 

The jsl file for the BreweryDB API is now attached as a file. There are two things to keep in mind before you give it a try:

• BreweryDB requires a paid monthly subscription in order to access the full database
• BreweryDB has a query limit of 200 pages per day, so running the full query will take more than one day as there's more than 200 total pages worth of breweries.

Let me know if you have any other questions!