Generating array of arrays

Question

I have a Web-API method that is returning JSON and I want the array structure to look like this: [ [123, 1.1], [222, 3.9] ]

My Web API controller is returning JSON in the following format: [{"CreatedDate":1314736440,"Reading":20.0}, "CreatedDate":1314779640,"Reading":7.9}]

Web API Controller:

[HttpGet]
 public HttpResponseMessage AllJson()
 {
     using (var ctx = new SomeContext())
     {
         var records = ctx.DataX.ToList();
         var dtos = Mapper.Map<...>(records);
         return new HttpResponseMessage
         {
             StatusCode = HttpStatusCode.OK,
             Content = new StringContent(JsonConvert.SerializeObject(dtos), Encoding.UTF8, "application/json")
         };
     }
 }

DTO

public class DtoModel
    {
        public int CreatedDate { get; set; }
        public double Reading { get; set; }
    }

Sample Javascipt:

var seriesData = [];
        $.getJSON("api/xxx/AllJson ", function (data) {
            $.each(data, function (key, val) {
                seriesData.push(val.CreatedDate.toString() + " ," + val.Reading.toString());
                console.log(val.CreatedDate + " ," + val.Reading);
            });
        });

Seany84 · Accepted Answer · 2015-09-25 20:09:54Z

1

You need to create an a single array containing many arrays of length 2.

See this code:

 $.getJSON("api/xxx/AllJson")
            .done(function (data) {
                var processedJson = new Array();
                $.map(data, function (obj, i) {
                    processedJson.push([obj.CreatedDate, obj.Reading]);
                });

                FunctionToDoSomethingWithYourDataStructure(processedJson);
            });

answered Sep 25, 2015 at 20:09

Seany84

5,5965 gold badges46 silver badges71 bronze badges

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

Comments

DRGA · Accepted Answer · 2015-09-23 22:06:03Z

0

I think this might solve your problem.. structure wise, this should look like [[a,b],[c,d]];

var createSeriesData = function(){
    seriesData = [];
    JSON_obj = JSON.parse('[{"CreatedDate":1314736440,"Reading":20.0},{"CreatedDate":1314779640,"Reading":7.9}]');

    for(var key in JSON_obj){
        if(JSON_obj.hasOwnProperty(key)){
            seriesData[key] = [];
            seriesData[key].push(JSON_obj[key].CreatedDate.toString());
            seriesData[key].push(JSON_obj[key].Reading.toString());
        }

    }

    console.log(seriesData);
}

answered Sep 23, 2015 at 22:06

DRGA

1696 bronze badges

Collectives™ on Stack Overflow

Generating array of arrays

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related