Pass json formated data as json result

Question

0.00/5 (No votes)

See more:

I had data like this in database

{"city":"CAMBRIDGE","id":"xyz","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyz","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyz"}

{"city":"CAMBRIDGE","id":"xyo","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyo","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyo"}

i want to pass that data as json result from web api

What I have tried:

C#

public HttpResponseMessage GetLocationData(string Latitude, string Longitude, float Miles)
       {
           List<Location> locations = _dpDataLayerService.GetLocations(Latitude, Longitude, Miles);

           var locationData = string.Empty;
           foreach (var item in locations)
           {
               locationData += item.Json + ',';
           }
                     var result = new HttpResponseMessage { Content = new StringContent(locationData, System.Text.Encoding.UTF8, "application/json") };
           return result;


       }

i want to show that data in array, now it showing as it is.

Posted 6-Jul-16 11:33am

dhiraj mane

Updated 8-Jul-16 5:53am

Add a Solution

2 solutions

Solution 1

A JSON array of those objects would look like

"locations":[{"city":"CAMBRIDGE","id":"xyz","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyz","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyz"},{"city":"CAMBRIDGE","id":"xyo","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyo","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyo"}]

ref : JSON Syntax[^]

Posted 6-Jul-16 13:25pm

Garth J Lancaster

Updated 6-Jul-16 13:26pm

Comments

dhiraj mane 7-Jul-16 9:40am

Thanks, can u tell me how to add that data into locations. currently my locations list structure is
public class Location
{
public string StoreId { get; set; }
public string Json { get; set; }
public float Distance { get; set; }
}

Garth J Lancaster 7-Jul-16 20:58pm

well, even my JSON was wrong - if you use

{"locations":[{"city":"CAMBRIDGE","id":"xyz","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyz","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyz"},{"city":"CAMBRIDGE","id":"xyo","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyo","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyo"}]}

you can deserialise to

public class Location
{
public string city { get; set; }
public string id { get; set; }
public double latitude { get; set; }
public double longitude { get; set; }
public string phoneNumber { get; set; }
public string state { get; set; }
public string storeNumber { get; set; }
public string storeType { get; set; }
public string streetAddress { get; set; }
public string zip { get; set; }
public string storeName { get; set; }
}

public class RootObject
{
public List<location> locations { get; set; }
}

or the simpler JSON representation

[{"city":"CAMBRIDGE","id":"xyz","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyz","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyz"},{"city":"CAMBRIDGE","id":"xyo","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyo","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyo"}]

can serialise to

public class RootObject
{
public string city { get; set; }
public string id { get; set; }
public double latitude { get; set; }
public double longitude { get; set; }
public string phoneNumber { get; set; }
public string state { get; set; }
public string storeNumber { get; set; }
public string storeType { get; set; }
public string streetAddress { get; set; }
public string zip { get; set; }
public string storeName { get; set; }
}

but you have to do some manual work - which is why I prefer the List<locations> method .. is that what you were asking ?

Garth J Lancaster 7-Jul-16 21:47pm

so given

public class Location
{
public string city { get; set; }
public string id { get; set; }
public double latitude { get; set; }
public double longitude { get; set; }
public string phoneNumber { get; set; }
public string state { get; set; }
public string storeNumber { get; set; }
public string storeType { get; set; }
public string streetAddress { get; set; }
public string zip { get; set; }
public string storeName { get; set; }
}

and {"city":"CAMBRIDGE","id":"xyz","latitude":44.36164,"longitude":-72.11383,"phoneNumber":"","state":"MA","storeNumber":"142","storeType":"xyz","streetAddress":"330 RIVER STREET","zip":"02139","storeName":"xyz"} in a string 'json' you can do

Location aLocation = JsonConvert.DeserializeObject<location>(json);

dhiraj mane 8-Jul-16 11:49am

Thanks for Help. I use Deserialize technique for that

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

dhiraj mane · Accepted Answer · 2016-07-08T05:53:00

C#

public IEnumerable<locationmodel> GetLocationData(string Latitude, string Longitude, float Miles)
       {
           List<location> locations = _dpDataLayerService.GetLocations(Latitude, Longitude, Miles);

           List<locationmodel> locationModel = new List<locationmodel>();

           var locationData = string.Empty;
           foreach (var item in locations)
           {
               LocationModel _location = new LocationModel();
               _location.Json = JsonConvert.DeserializeObject<json>(item.Json);
               locationModel.Add(_location);
           }

           return locationModel;
       }