I am working with APIs and sending information via a URL. For this one new client, the response they send us uses JSON, which I've never used before.
I can send the data ok, but the response comes in the form of a file. It doesn't even seem to have an extension but I can open it manually in notepad. I need to know how to read this file programatically so I can use the data. If I can read this data back into SQL Server, I'll be ok from there.
Any assistance much appreciated.