Hackers and Slackers

APIs

11 Posts
Consuming and building APIs.

Extract Nested Data From Complex JSON

The Pythonic way of working with JSON objects

We're all data people here, so you already know the scenario: it happens perhaps once a day, perhaps 5, or even more. There's an API you're working with, and it's great. It contains all the information you're looking for, but

Python Author imageTodd Birchard Author imagetodd Oct 10
Read

Working with a Postgres instance on Google Cloud

Deep Dive into Cloud SQL and its out-of-the-box API

Well folks, I have a confession to make. I've been maintaining an affair with two lovers. That's right; they're none other than Postgres, and Google Cloud. While such polygamy may be shunned by the masses, I believe that somehow, some

Google Cloud Author imageTodd Birchard Author imagetodd Aug 10
Read

Abusing Tableau to Handle ETL Workflows

Weaponizing APIs against tyrannical software

Before we get into the specifics of how to sadistically abuse Tableau, let's clear the air: there's something about inaccessible, expensive, proprietary enterprise software that tends to put me in a touchy mood. As we know, B2B software pricing has

Tableau Author imageTodd Birchard Author imagetodd Aug 03
Read

Extract Massive Amounts of Data from APIs in Python

Abusing APIs for all they’re worth

Taxation without representation. Colonialism. Not letting people eat cake. Human beings rightfully meet atrocities with action in an effort to change the worked for the better. Cruelty by mankind justifies revolution, and it is this writer's opinion that API limitations

Python Author imageTodd Birchard Author imagetodd Jul 04
Read

Working with XML trees in Python

Because you'll probably have to

Life is filled with things we don't want to do; you're a developer so you probably understand this to a higher degree than most people. Sometimes we waste weeks off our lives thanks to an unreasonable and unknowledgable stakeholder. Other

Python Author imageTodd Birchard Author imagetodd Jun 19
Read

Build Your Own API in AWS

Using API Gateway to create complex APIs

Enough with the 101 tutorials, it's time to step our game up… we're going to build an API. All those other posts? They were just wax-on wax-off... classic Mr. Miyagi maneuver. This is what separates the men from the boys,

APIs Author imageTodd Birchard Author imagetodd May 06
Read

Python's Requests Library for APIs

Get familiar with what might become your most used Python library

Last episode we taught you how to make GET requests using Ajax, where you learned to store and pass private keys on the client side like an idiot. Today we'll do the equivalent in Python by using the requests library

Python Author imageTodd Birchard Author imagetodd May 01
Read