//Healthfacilities public void GetProcessedHealthFacilitiesFromJSON() { try { var client = new WebClient(); var json = client.DownloadString(@"http://www.otvorenipodatoci.gov.mk/datastore/dump/505db453-4de2-4761-8a81-2800f7820b06?format=json"); var jsonResponse = JObject.Parse(json); var records = JArray.Parse(jsonResponse.GetValue("records").ToString()); foreach (var rec in records) { dynamic obj = JsonConvert.DeserializeObject(rec.ToString()); var Name = obj[2]; var Municipality = obj[6]; var Address = obj[9]; var Email = obj[10]; var Phone = obj[11]; var Type = obj[5]; HealthFacility healthFacility = new HealthFacility(); //Name, Municipality, Address, Type, Email, Phone healthFacility.Name = Convert.ToString(Name); healthFacility.Municipality = Convert.ToString(Municipality); healthFacility.Address = Convert.ToString(Address); healthFacility.Type = Convert.ToString(Type); healthFacility.Email = Convert.ToString(Email); healthFacility.Phone = Convert.ToString(Phone); _service.AddFacility(healthFacility); } } catch (Exception e) { _logger.LogInformation(e.Message); throw new Exception("Cannot process health facilities from JSON." + e.Message); } }