Use WebClient class.
Refer below example.
First import the Newtonsoft.Json namespace.
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
ServicePointManager.Expect100Continue = true;
ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;
WebClient webClient = new WebClient();
string json = (new WebClient()).DownloadString("https://raw.githubusercontent.com/aspsnippets/test/master/Customers.json");
DataTable dt = JsonConvert.DeserializeObject<DataTable>(json);
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
ServicePointManager.Expect100Continue = True
ServicePointManager.SecurityProtocol = CType(3072, SecurityProtocolType)
Dim webClient As WebClient = New WebClient()
Dim json As String = (New WebClient()).DownloadString("https://raw.githubusercontent.com/aspsnippets/test/master/Customers.json")
Dim dt As DataTable = JsonConvert.DeserializeObject(Of DataTable)(json)
End Sub
The use the DataTable to do rest of the task.
Refer below article for more details.
Read (Parse) JSON data from URL in ASP.Net using C# and VB.Net
As per your JSON use below code.
C#
DataTable dt = JsonConvert.DeserializeObject<DataTable>("[" + json.Replace("CREDENTIALS:", "") + "]");
VB.Net
Dim dt As DataTable = JsonConvert.DeserializeObject(Of DataTable)("[" + json.Replace("CREDENTIALS:", "") + "]")