Javascript Array unexpected '

Question

I'm trying to export some data generated by our server, and import it into Googles Column Chart.

I've read the documentation regarding using JSON to import from the server, however, I'm not using a pie chart, and they haven't given much information about how they generate the JSON, and the format it quite different between a pie and column chart.

My server is currently returning the following code:

[['Week', 'Present', 'Absent', 'Other'], 
 ['Week 1', 2, 0, 0],
 ['Week 2', 0, 0, 0],
 ['Week 3', 0, 0, 0],
 ['Week 4', 0, 0, 0],
 ['Week 5', 0, 0, 0]
]

Now, if I import this directly into the charts:

google.visualization.arrayToDataTable(response);

Then I get the error message 'Not an array'. Which I guess is true, actually being a string.

However, after googling, It would appear that using $.parseJSON would work. I've use this function on another Line graph google chart and its worked, however whenever I use $.parseJSON(response), all I get is

Uncaught SyntaxError: Unexpected token '

I cannot for the life of me see where the apostrophe is. All I want to do is import my server generated code into a chart.

Any help is always appreciated.

naloxx · Accepted Answer · 2013-10-01 14:56:43Z

6

For $.parseJSON you need to use " insted of '.

    var formatted = original.replace(/'/g, '"');

Have a look at this JSFiddle: http://jsfiddle.net/7pdgn/

edited Oct 1, 2013 at 14:56

answered Oct 1, 2013 at 14:48

naloxx

2211 silver badge7 bronze badges

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

2 Comments

Phil Cross Over a year ago

Unbelievable! Thank you very much for the answer, you've saved me from pulling out a lot of hair! I'll Accept the answer when I can

naloxx Over a year ago

It took me a while to figure this out myself a few months ago, I have to admit it's pretty annoying.

SLaks · Accepted Answer · 2013-10-01 14:48:50Z

3

That isn't valid JSON; JSON strings must be double-quoted.

You should change your server to use an actual JSON serializer instead of building strings by hand.

answered Oct 1, 2013 at 14:48

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

1 Comment

Phil Cross Over a year ago

Thanks @slaks very easy mistake to make. Fortunately, I dont need to use much JSON. Thank you very much for your quick answer :)

Collectives™ on Stack Overflow

Javascript Array unexpected '

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related