Cannot create javascript array from JSON response

Question

I am using Jquery and AJAX to call a web method in my C# code behind, which runs a stored procedure and then sends the data back as a string. This is all working perfectly.

When I have my values back and I try make an array out of them so I can select only certain objects out of the array, everything falls apart. I have made a quick FIDDLE of the problem I am having.

I receive a string like this from my Stored Procedure: 12, 1288, 1800, 3088, 26288

But when I try get the "12" only, I either receive the whole string or just the "1" from the 12.

I have tried everything from makeArray, stringify, split, replacing then splitting, making an array variable and push() into it... nothing seems to work.

Below is some of my scrap code which I have been commenting out as I try and I've also added an image of the code behind while stepping through:

 $.ajax({
                      type: "POST",
                      url: "LeadGraphGeneration.aspx/GetData",
                      contentType: "application/json; charset=utf-8",
                      data: strRequest,
                      dataType: "json",
                      success: function (msg) {
                          var returned = (msg.d);
                          //                          var returned = new Array();
                          //                          $(msg.d).each(function () {
                          //                              returned.push(this);
                          //                          });

                          ret1 = returned[1];

                          //                          var returnedd = JSON.stringify(msg.d);
                          //                          var returned = $.makeArray(returnedd);



                          //                          var ret1 = returned[0];
                          //                          var ret2 = returned[1];
                          //                          var ret3 = returned[2];
                          //                          var ret4 = returned[3];
                          //                          var ret5 = returned[4];


                          //data1 = dataArray[0];


                          $("#PaymentPeriod").text(ret1);
                          //                          $("#TotalInterest").text(ret2);
                          //                          $("#TotalFees").text(ret3);
                          //                          $("#TotalCost").text(ret4);
                          //                          $("#TotalPayment").text(ret5);

enter image description here (Right click, open in new tab for full size) I'm hoping you could help me figure out why I can't select individual objects from the array which I am struggling to build.

Please let me know if you need any more info.

try this var rett = $.parseJSON("["+returnedd+"]");

Anton
– Anton

2014-04-11 15:03:42 +00:00
Commented Apr 11, 2014 at 15:03 — Anton
– Anton, Commented Apr 11, 2014 at 15:03

T.J. Crowder · Accepted Answer · 2014-04-11 15:03:55Z

2

"but when I try get the "12" only, I either receive the whole string or just the "1" from the 12.."

If your string is "12, 1288, 1800, 3088, 26288" and it's in msg.d, then:

var returned = msg.d.split(/\s*,\s*/);

The regular expression tells split to split the string on any run of optional whitespace characters followed by a comma followed by optional whitespace characters.

answered Apr 11, 2014 at 15:03

T.J. Crowder

1.1m201 gold badges2k silver badges2k bronze badges

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

1 Comment

Fizor Over a year ago

Thanks TJ... This worked! I will accept the answer as soon as I can. I need to go brush up on my Regex so i dont sit for hours trying to sort something out. haha

Alex K. · Accepted Answer · 2014-04-11 15:12:18Z

1

var returnedd = "12, 1288, 1800, 3088, 26288"
var rett = $.makeArray(returnedd);

makeArray will not convert a string in that format to an array, rather use split:

var rett = returnedd.replace(/\s/g, "").split(",");
alert(rett[0])

As for

ret2 = returnedd[0];

This is calling [0] on a string which will give you the first char (just like .charAt(0))

answered Apr 11, 2014 at 15:12

Alex K.

177k32 gold badges275 silver badges298 bronze badges

Collectives™ on Stack Overflow

Cannot create javascript array from JSON response

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related