c# mvc 5 call json web service and save on database

Question

Greetings i want to call a web api that returns a json string from From Controller and i want to map it on a class so i can save the data on the database.But i dont understand how to map each data on the json with the class. I only get the message that is succeed. my code is:

public ActionResult API()
{
    var client = new WebClient();
    var text = client.DownloadString("https://www.example.com/api/all-users?name=user%20&pass=password");
    wclients wclients = JsonConvert.DeserializeObject<wclients>(text);

    if (wclients.message == "success")
    {
        ViewBag.name = ("name = " + wclients.name);
    }

    return View();
}

my view is this:

@foreach (var item in ViewBag.name) {
<tr>
    <td>
       @item
    </td>


</tr>

}

The Response from web api is:

{"status":true,"message":"success","data":[{"name":"test test","email":"[email protected]","phone":"1234567890","affiliated_id":null,"account":{"real":[{"login":"1001175","pass":"4pJccK8AUWw8"},{"login":"3001180","pass":"4AeCqasw7jX2"},{"login":"3001182","pass":"fS2tf6Gsej7C"}]

I am trying to get the value name so i have a list of names on the view, but what i get on wclients.name its null — Eni Spetsi
– Eni Spetsi, Commented Aug 2, 2017 at 12:23
I am not using any js, im trying to pass data through ViewBag. — Eni Spetsi
– Eni Spetsi, Commented Aug 2, 2017 at 12:24

Tejinder Singh · Accepted Answer · 2017-08-02 13:54:29Z

1

try the below code:

public ActionResult API()
{
    var client = new WebClient();
    var text = client.DownloadString("https://www.example.com/api/all-users?
    name=user%20&pass=password");
    var wclients = JsonConvert.DeserializeObject<dynamic>(text);

        if (wclients.message == "success")
        {
            var data = wclients.data;
        }
      return View();
}

edited Aug 2, 2017 at 13:54

answered Aug 2, 2017 at 12:45

Tejinder Singh

1,1203 gold badges8 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

16 Comments

Eni Spetsi Over a year ago

wclients.data its not on my class property, and i dont see how with a property data i can get the list of users.

Tejinder Singh Over a year ago

wclients contains the response you are getting from an api , right?

Eni Spetsi Over a year ago

wclients its the class that i am using to map the properties together.

Tejinder Singh Over a year ago

response you are getting from an api contains the data property, you can 't get the name without using the data. you can use var wclients = JsonConvert.DeserializeObject<wclients>(text); to access the data.

Tejinder Singh Over a year ago

@EniSpetsi, i have edited my code changed text to text.data

|

Darren Blaby · Accepted Answer · 2017-08-02 12:54:24Z

0

wclients.name will never contain anything because there is not a property called "name" at the top level of the JSON object structure.

To access the name property you would need to enumerate through the data array (which should exist as a property on the wclients class) and get the name from there.

Update

As per the example below:

public class wclients
{
    public bool status { get; set; }

    public string message { get; set; }

    public IEnumerable<Account> data { get; set; }
}

public class Account
{
    public string name { get; set; }
    public string email { get; set; }
    public string phone { get; set; }
}

public ActionResult API()
{
    var client = new WebClient();
    var text = client.DownloadString("https://www.example.com/api/all-users?name=user%20&pass=password");
    wclients clients = JsonConvert.DeserializeObject<wclients>(text);

    if (wclients.message == "success")
    {
        ViewBag.name = clients.data;
    }

    return View();
}

and in the view

@foreach (var item in ViewBag.name)
{
    <tr>
        <td>
           @item.name
        </td>
    </tr>
}

edited Aug 2, 2017 at 12:54

answered Aug 2, 2017 at 12:41

Darren Blaby

3042 silver badges6 bronze badges

1 Comment

Eni Spetsi Over a year ago

Sorry i did not understood that please can you share a example?

pookie · Accepted Answer · 2017-08-02 12:58:43Z

0

The JSON must map directly to your C# class.

For example, if the JSON has the following:

"name":"test test",
"email":"[email protected]"

Then your class (eg Person.cs) must have the same properties:

public class Person{
    public string name {get;set}
    public string email {get;set}
}

Then you would do:

Person person = JsonConvert.DeserializeObject<Person>(json);

In your example, you probably need wclients.data

if (wclients.message == "success")
{
    ViewBag.name = ("name = " + wclients.data.name);
}

Finally, the name wclients suggests there are multiple... in which case:

var names = new List<string>();
foreach(var client in wclients){
    if (client.message == "success")
    {
        names.Add("name = " + client.data.name);
    }
}

edited Aug 2, 2017 at 12:58

answered Aug 2, 2017 at 12:53

pookie

4,16213 gold badges61 silver badges120 bronze badges

Collectives™ on Stack Overflow

c# mvc 5 call json web service and save on database

3 Answers 3

16 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

16 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related