Month: <span>July 2017</span>

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

Posted on July 17, 2017 by in c#, json, json.net, web-apis

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

Tagged with , , ,

Working with Large JSON Blobs Sanely Using SQL Server

Posted on July 11, 2017 by in json-1, sql

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

Tagged with ,