How to convert model list to json highchart map data

Question

I have a model list of data to map chart. But the map chart accepts value format like this:

data: [{id: 'London', lat: 51.50, lon: -0.12}]

But the below code produce a data like this

The Id value is in double quote what I need is single quote 'London' and it should not display like that '&quot'. The sample chart with data can be found here https://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/master/samples/maps/demo/flight-routes/

Model

[JsonObject(MemberSerialization.OptIn)]
    public class ShipmentLocationModel
    {
        [JsonProperty]
        public string id { get; set; }
        [JsonProperty]
        public decimal lat { get; set; }
        [JsonProperty]
        public decimal lon { get; set; }
    }

Controller

List<ShipmentLocationModel> LocationList = new List<ShipmentLocationModel>();
var stringWriter = new StringWriter();
var serializer = new JsonSerializer();
using (var writer = new JsonTextWriter(stringWriter))
{
    writer.QuoteName = false;
    serializer.Serialize(writer, LocationList);
}
ViewData["LocationList"] = stringWriter;

View

data: @ViewData["LocationList"]

hi @xdtTransform it is different my problem is the double quote. — Reynan, Jul 31 '19 at 07:03
You are using [the right method](https://stackoverflow.com/questions/7553516/json-net-serialize-property-name-without-quotes) to serialize your List with out the quoted name — xdtTransform, Jul 31 '19 at 07:04
@xdtTransform yes but the id value "London" should be 'London' single quote only — Reynan, Jul 31 '19 at 07:11
Someone messed with the standard. It's not Json anymore. More seriously expecting double quote in the value or you can assume a simple remplace should be enought? — xdtTransform, Jul 31 '19 at 07:15
@xdtTransform it works now. double or single quote works. thank you — Reynan, Jul 31 '19 at 07:53
Js exemple trend to use a mix of `'` and `"`. Those people seems to be afraid of escaping char. Most of the time they are equivalent. — xdtTransform, Jul 31 '19 at 07:56

score 0 · Answer 1 · answered Jul 31 '19 at 07:17

0

Use @Html.Raw() method:

data: @Html.Raw(ViewData["LocationList"])

answered Jul 31 '19 at 07:17

JMSilla

1,326
10
17

Hi the output was still double quote but it is not '&quot' anymore data: [{id: "London", lat: 51.50, lon: -0.12}] – Reynan Jul 31 '19 at 07:44
sorry it works now that is weird single or double quote works now. thank you. – Reynan Jul 31 '19 at 07:50

How to convert model list to json highchart map data

1 Answers1