I agree that it's generally better to opt for individual columns for values rather than using JSON or XML or whatever else, however I've worked in places where it's very...

Pulling data in from a web service from within a database routine is an interesting idea, in fact I inherited an application that did exactly that in a previous job...