Month: <span>July 2017</span>

Dealing with Horrid, No-Good, Very-Bad APIs Using JSON.NET

I already mentioned how I’m working on a big data integration project. Sadly, one of the systems involved exposes what I would describe as a “less-than-ideal” API. It’s buggy, poorly-documented… I could go on, but probably shouldn’t. ? But the big thing that got me was the lack of consistency. Not just across endpoints, but…

Read More

Working with Large JSON Blobs Sanely Using SQL Server

Have you ever wished that you could query a large JSON document? I wished that very thing recently while working with a 3rd party API. One particular API call was returning mountains of data, and I needed to get a list of distinct values of a particular property buried within the objects of this JSON…

Read More