Dabbling with the Mastodon API

I’ve been meaning to get all the stuff that used to be automated to Twitter to work with Mastodon. I took about 15 minutes1 after reading a Mastodon-related post from Alan to mess around and see what I could figure out. Now I’ve got 15 minutes to write it down. Consider that half an hour […]

Read More… from Dabbling with the Mastodon API

Google Sheets JSON the Long Way

Ever since Google turned off direct access to the JSON data from Google Sheets, I’ve used a couple of App Script workarounds. They were a bit clumsy for what I was doing but better than re-writing the entire page. I find going through the whole oAuth and Google project process to be more hassle than […]

Read More… from Google Sheets JSON the Long Way

All the TAGS Twitter Avatars

I have someone who gathered a bunch of tweets for their research using Martin’s TAGS aggregator. She wanted to show all the avatars. Once I published the spreadsheet, here’s all the javascript needed to make that happen. It’s lightly annotated for your reading pleasure and the functioning codepen example is included below. See the Pen […]

Read More… from All the TAGS Twitter Avatars

PHP Middleware for Keeping Your JS API Secrets Secret

Screenshot of a design context website where the weather data is being pulled via API.

Origin Story We were looking to pull in live weather data for a eco-related design contest that VCU Qatar is hosting. I found a free API for weather but wanted a way to use it via javascript and not expose any secrets. That led to the script below. Many APIs have query strings that require […]

Read More… from PHP Middleware for Keeping Your JS API Secrets Secret