Category: Data
-
Converting Books to JSON: A Digital Humanities Project
This post discusses a recent project where I scanned PDF issues of the Council of Literary Magazines and Presses (CLMP) Directory of Literary Magazines from 1995 to 2005 and converted those 10 directories into clean, well-structured JSON. The process encompassed several stages, including PDF to text conversion, data cleaning, and data extraction using Python scripts…
-
Excel Web Services and POST Requests
The purpose of this post is to demonstrate a less common approach to accessing data from a REST API with Excel and Power BI.
-
Get Data from the Airtable API the Easy Way
This article shows you how to engage with the AirTable API to pull data into your preferred analysis tool such as Excel Get and Transform or Power BI.
-
Get Survey Monkey Data Using the REST API
This article demonstrates how to engage with the Survey Monkey API to get form data.
-
Display WordPress Posts on Another Site with WP REST API
Overview Have a WordPress site and want to include your posts on an external site? In this tutorial, I will show you how to use the WordPress REST API to display your posts on a static site with just HTML, CSS, and Javascript. There are several scenarios where this might be useful but here are the…
-
Integrating Wikipedia Opensearch API with a Form Builder
Recently I wanted to allow autocomplete search of Wikipedia from a form field and, based upon the selection, populate other fields with relevant data from Wikipedia. Thankfully there’s an easy button for this using the Opensearch API. For this tutorial we will be autocompleting author info for a form using Wikipedia parameters based upon the selection…
-
Data Insights with the WordPress REST API
WordPress is moving closer to becoming a fully-fledged application framework. It has always been easy to publish with WordPress but accessing your data from external systems was often very difficult. But what is WordPress REST API anyway? Well here’s an excellent explanation but, to simply for our purposes, the WordPress API allows us to read data…