Give a name to an array of JSON objects

Question

I am new to JSON and i am trying to get data from database in Sql Server with Asp.net Web Api.

My Output json Array is Like this:

[ { "f0": 9608, "f1": 1461, "frbDescField_F56": "Jan", "f2": "1461", "f3": "179:48"}]

But the output of the Json should be similar to the following code:

{ "restaurants": [ { "f0": 9608, "f1": 1461, "frbDescField_F56": "Jan", "f2": "1461", "f3": "179:48"}] }

and My Code is:

public IEnumerable<VI_TimeTotalMontly> Get(int id, string id1)
{
    using (tfmisEntities Entities = new tfmisEntities())
    {
        var result = Entities.VI_TimeTotalMontly.Where(e => e.F0 == id && e.F2 == id1).ToList();
        return result;
    }
}

How do I change my codes?

Nkosi · Accepted Answer · 2017-11-20 13:06:31Z

6

You can build a strongly typed anonymous object to match the desired output. You would also need to change the return type of the action as IEnumerable<VI_TimeTotalMontly> would just return a collection, when you want an object response

public IHttpActionResult Get(int id, string id1) {
    using (var Entities = new tfmisEntities()) {
        var restaurants = Entities.VI_TimeTotalMontly
                              .Where(e => e.F0 == id && e.F2 == id1)
                              .ToList();

        var result = new {
            restaurants = restaurants;
        };

        return Ok(result);
    }
}

answered Nov 20, 2017 at 13:06

Nkosi

249k38 gold badges472 silver badges506 bronze badges

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

1 Comment

Abhishek Maurya Over a year ago

I would prefer this answer as it does not involve operations during runtime like when we use dynamic. It is better to get things done in compile time. Unless you have no other option try to use this method.

hardkoded · Accepted Answer · 2017-11-20 12:59:02Z

1

I would use a dynamic object to wrap your result:

dynamic output = new ExpandoObject();
output.restaurants = result;

return output;

answered Nov 20, 2017 at 12:59

hardkoded

22k3 gold badges64 silver badges78 bronze badges

1 Comment

Nkosi Over a year ago

This is fine but incomplete. You would also need to explain changing the action signature.

Collectives™ on Stack Overflow

Give a name to an array of JSON objects

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related