Storing Api data response in database

I am able to fetch api data , but the response is coming in collection form, how should i loop through first array and store only that information . The response which i am receiving from api is as follows:

{"ngodetails":[{"id":"DL\/2017\/0165260","name":"\tASSOCIATION FOR SOCIAL SERVICE AND REHABILITATION OF THE AGED ASSRA","registrationNumber":"42540 OF 2002","panNumber":"Available","panVerifyStatus":"V"}],"memberdetails":[{"name":"NAMITA SAHOO","designation":"President","aadhaarNumber":"Available","aadhaarVerifyStatus":"V","panNumber":"Available","panVerifyStatus":"V","LastUpdated":"13-10-2017 07:00:17"},{"name":"PRASHANTA GHADAI","designation":"Vice President","aadhaarNumber":"Available","aadhaarVerifyStatus":"V","panNumber":"Available","panVerifyStatus":"V","LastUpdated":"13-10-2017 07:00:09"},{"name":"ANIL KUMAR ROY","designation":"Secretary","aadhaarNumber":"Available","aadhaarVerifyStatus":"V","panNumber":"Available","panVerifyStatus":"V","LastUpdated":"14-10-2017 11:36:20"}]}

public ActionResult Index()
{
List ngo = new List();
string baseurl = "https://ngodarpan.gov.in/ngodarpanws_ndci/apin/getngo/DL_2017_0165260";
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseurl);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage Res = client.GetAsync(baseurl).Result;
if (Res.IsSuccessStatusCode)
{
var response = Res.Content.ReadAsStringAsync().Result;
ngo = JsonConvert.DeserializeObject>(response);
}
return View(ngo);
}
}
@model IEnumerable
@{
ViewBag.Title = "Index";
}
Index
@foreach(var i in Model)
{







}

Id Name Registration Number PanNumber PanVerifyStatus
@i.id @i.name @i.registrationnumber @i.panNumber @i.panVerifyStatus

Id	Name	Registration Number	PanNumber	PanVerifyStatus
@i.id	@i.name	@i.registrationnumber	@i.panNumber	@i.panVerifyStatus

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sunny kumar7y ago
sorry bro, but i am not able to understand your code, pls check the error in my code if possible
Hari Murugesan7y ago
Hi Sunny Kumar,

Pls follow the below code to store a database
public
function saveMatches() {
$matches = $this - > getMatches();

collect($matches) -
  > each(function($match, $key) {
   Match::create([
    'match_id' => $match['id'],
    'homeTeam' => $match['homeTeam']['name'],
    'awayTeam' => $match['awayTeam']['name']
   ]);
  });
}

Storing Api data response in database

Index