How to change JSON API label into number in .net

Question

So currently I'm using react-simple-map to make a map that with marker. It required this json format:

[{
   "coordinates":{
      "0":139.6917,
      "1":35.6480
   },
      "name":"Tokyo",
  },
  {
    "coordinates":{
      "0":101.9758,
      "1":4.2105
    },
    "name":"Malaysia",
}]

Then I'm trying to change the label in .net like this:

 public IQueryable<Object> GetCoordination()
        {
            return from a in _awContext.SalesTerritories
                   join p in _awContext.Coordination
                   on a.TerritoryId equals p.TerritoryID
                   select new
                   {
                       id = a.TerritoryId,
                       coordinates = new 
                       {
                           '0' = p.Lat,
                           '1' = p.Long,    
                       },
                       name = a.Name,
                       countryRegionCode = a.CountryRegionCode,
                       salesYtd = a.SalesYtd,
                       salesLastYear = a.SalesLastYear,
                       costYtd = a.CostYtd,
                       costLastYear = a.CostLastYear,

                   };
        }

What happen is the 0 & 1 have error.

Is there anyway to make it integer.

score 0 · Answer 1 · answered Nov 19 '21 at 08:51

0

you should not have array key

{
    "coordinates": [0.1234,1.2345]
}

Cheers !

answered Nov 19 '21 at 08:51

Djb

109
8

"lat": 139.6917, "long": 35.64. The json became like this. if I do coordinates = new { p.Lat, p.Long }, – tedeeee Nov 19 '21 at 08:56
Are you tested this? : coordinates = [p.Lat, p.Long] – Djb Nov 19 '21 at 09:03
Yes this 1 return invalid expression "[" – tedeeee Nov 19 '21 at 09:05
so i changed it to coordinates = new { p.Lat, p.Long } – tedeeee Nov 19 '21 at 09:06

How to change JSON API label into number in .net

1 Answers1