How to return JSON not associative array

Question

I'm writing simple API which returns array of JSON objects:

[
    {
        "Id": 134649,
        "Type_id": 6,
        "Latitude": 56.904220,
        "Longitude":14.823440
    },
    {
        "Id": 134660,
        "Type_id": 6,
        "Latitude": 56.884040,
        "Longitude":14.761320
    }
]

This is generated by Response.MapEntries model I wrote:

class MapEntries
{
    public ulong Id { get; set; }
    public int Type_id { get; set; }
    public decimal Latitude { get; set; }
    public decimal Longitude { get; set; }
}

And filled and returned like this:

List<Response.MapEntries> entries = new List<Response.MapEntries>();
using (IDbConnection db = Connection.Instance())
{
    db.Open();
    entries = db.Query<Response.MapEntries>(query.ToString(), parameters).ToList();
}

return entries;

PROBLEM

JSON response has useless information like JSON object's names. By one request it can return up to 20000(1.2MB) records (demo image: https://i.sstatic.net/Corw5.jpg).

I think I can save around 40% of data transfer, if I change JSON to not associative arrays. But I don't know how to do that, because I'm new with C# and strict typed languages.

Response I want: [[134649, 6, 56.884040, 14.761320],[134649, 6, 56.884040, 14.761320]]

Guffa · Accepted Answer · 2013-09-12 09:35:32Z

5

As you are mixing data types, return each item as an array of objects:

List<object[]> entries;
using (IDbConnection db = Connection.Instance()) {
  db.Open();
  entries = db.Query<Response.MapEntries>(query.ToString(), parameters)
    .Select(e => new object[] { e.Id, e.Type_id, e.Latitude, e.Longitude })
    .ToList();
}

return entries;

edited Sep 12, 2013 at 9:35

answered Sep 12, 2013 at 8:48

Guffa

703k111 gold badges760 silver badges1k bronze badges

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

1 Comment

Ernestas Stankevičius Over a year ago

Ah, Linq. YES! How I haven't thought about it... Thanks mate!

Collectives™ on Stack Overflow

How to return JSON not associative array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related