Your API Builds Are Boring (Until Now)


Extract. Transform. Read.

A newsletter from Pipeline: Your Data Engineering Resource

Hi past, present and future data professional!

Tired of playing with the same 3 APIs? At the end of this email you’ll find a list of 13 offbeat APIs to make ETL interesting again.

But before you make your first request, read my cautionary tale of accidentally racking up $300 in charges on 1 API. Clearly, APIs can seem like black boxes offering unlimited data; to efficiently access that data, you need to think about how you’re “talking” with your API service. If you receive one too many “unauthorized” errors, you may not be reading the docs closely; this guide tells you to approach API documentation reading like an SAT reading comprehension test.

Before Reddit started acting like a budget airline carrier nickel-and-diming customers, it offered an API perfect for beginning developers. Finally, if you want to go beyond ETL, you can do so much more with APIs, like reading and deleting emails (except this one, I hope!).

Get your offbeat API guide here!

If you’re like me and are undefeated in IT phishing tests, here are this week’s embedded links:

Thanks for ingesting,

-Zach

Extract. Transform. Read.

Reaching 20k+ readers on Medium and nearly 3k learners by email, I draw on my 4 years of experience as a Senior Data Engineer to demystify data science, cloud and programming concepts while sharing job hunt strategies so you can land and excel in data-driven roles. Subscribe for 500 words of actionable advice every Thursday.

Read more from Extract. Transform. Read.

Extract. Transform. Read. A newsletter from PipelineToDE Hi past, present or future data professional! After choosing a dataset, one of the most significant decisions you must make when creating displayable work is: How am I going to build this thing? For some, you may try to “vibe code” along with an LLM doing the grunt technical work. If you choose this approach, be warned: Nearly half of all “vibe code” generated contains security vulnerabilities and that’s before you even consider its...

Extract. Transform. Read. A newsletter from PipelineToDE Amid layoff announcements from Meta, Amazon and even UPS, it's job aggregator Indeed that signals a different concern for entry-level data job seekers. This week a post on Blind revealed Indeed’s plan to quietly reduce junior roles. They’re not necessarily going to stop hiring or layoff juniors (though they are losing 1300 employees by end of year)—they’re just going to stop paying attention to them. Specifically, Indeed will no longer...

Extract. Transform. Read. A newsletter from PipelineToDE Hi past, present or future data professional! I want to share the single most important realization I had back in the summer of 2021. I was burned out, juggling two part-time jobs, trying to plan a wedding, and drowning in full-time job applications. I felt overwhelmed and underprepared as I plunged into a sea of candidates I perceived to be more intelligent and better "fits" than me. My portfolio was full of the usual Titanic, Iris,...