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…
try-catch-FAIL
Stories from the trenches of software development.
Month: <span>July 2017</span>
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…