How make web api return json in needed format?

Question

I'm using following code in web api to return json:

So, here is dto class. But it's not clear how to map it to result.

public class grafikresult
{
    int kodg { get; set; }
    string name { get; set; }
    DateTime data { get; set; }
    byte pax { get; set; }
    byte ch { get; set; }
}

Here is controller code:

// GET api/Grafik/5
    public IHttpActionResult GetGrafik(int id)
    {
        PhuketEntities db = new PhuketEntities();
        xTourist t = db.xTourist.Find(id);
        var result = from a in db.Grafik
                     join b in db.Exc on a.Excursion equals b.Kod
                     join c in db.Dates on a.Kodd equals c.kodd
                     join d in db.Staff on a.Guide equals d.Kod
                     where c.Date > t.ArrDate && c.Дата < t.DepDate
                     select new { kodg = a.Kodg, name = d.Name, data = c.Date, pax = t.Pax, ch = t.Child };
        return Ok(result);
    }

This returns new json like that:

{
    "$id": "1",
    "$values": [{
        "$id": "2",
        "kodg": -1643387437,
        "name": null,
        "data": "2014-02-07T00:00:00",
        "pax": 2,
        "ch": 0
    }, {...}]
}

How should I change web api controller code to be able get this json:

{
    "$id": "1",
    "kodg": -1643387437,
    "name": null,
    "data": "2014-02-07T00:00:00",
    "pax": 2,
    "ch": 0
    }, {...}
}

Community · Accepted Answer · 2017-05-23 10:26:02Z

You could try using AutoMapper.

1. Create classes for your Json

Before you use that you WILL need to convert your JSON object to C# classes. Try this or this.

In case you are having trouble defining classes, here is what I think should work for you.

Class for first json.

public class JsonClassA
{
    int id{ get; set; }
    Details values { get; set; }
}  

public class Details
{
    int kodg { get; set; }
    string name { get; set; }
    DateTime data { get; set; }
    byte pax { get; set; }
    byte ch { get; set; }
}

Class for second json.

public class JSONClassB
{
    int kodg { get; set; }
    string name { get; set; }
    DateTime data { get; set; }
    byte pax { get; set; }
    byte ch { get; set; }
}

2. Deserialize using JavaScriptSerialize:

JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
JsonClassA jsonClassA = jsonSerializer.Deserialize<JsonClassA>(jsonInput)

3. Map using Automapper

Say your first Json represent class JsonClassA and your second JSON represents class JSONClassB.

Using Automapper this could easily be done as follows and be returned from your controller.

JSONClassB finalOutput = AutoMapper.CreateMap<JsonClassA, JSONClassB>()
      .ForMember(dest => dest.prop1, opts => opts.MapFrom(src => src.propAAA))
      .ForMember(dest => dest.prop2, opts => opts.MapFrom(src => src.propBBB));
return Ok(finalOutput );

your solution, is it similar to this one? stackoverflow.com/questions/21657122/…
@andrey.shedko No, i saw the link you posted its a completely different question and answer. Did this solution work for you ?
jsonInput should be result of the LINQ query (var result), right?

Claudio Redi · Accepted Answer · 2014-03-26 12:51:23Z

2

Create a DTO class having the exact structure you need to return. Then you would map the structure of the items on result to PhuketDTO and assign the DTO list to Ok as you currently do for result.

edited Mar 26, 2014 at 12:51

answered Mar 26, 2014 at 12:41

Claudio Redi

68.5k15 gold badges138 silver badges161 bronze badges

3 Comments

andrey.shedko Over a year ago

Claudio, my background based on vb.net and linq, so I will be appreciate a lot if you can show any example of that.

Claudio Redi Over a year ago

@andrey.shedko: check the structure of the json you need to return an translate that to a C# class structure. If you have troubles with that come again and I'll be glad to help.

andrey.shedko Over a year ago

To say honestly, yes, I have troubles with that.

Collectives™ on Stack Overflow

How make web api return json in needed format?

2 Answers 2

1. Create classes for your Json

2. Deserialize using JavaScriptSerialize:

3. Map using Automapper

6 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1. Create classes for your Json

2. Deserialize using JavaScriptSerialize:

3. Map using Automapper

6 Comments

3 Comments

Linked

Related