WCF web service returning json format data

Question

I have created a WCF webservice returning json format data. My code is like below:

String sJSONdata = "";

StreamReader reader = new StreamReader(data);
sJSONdata = reader.ReadToEnd();

//'now convert the JSON into a data table
DataTable dt = GetJSONTable(sJSONdata);
dt.TableName = "Customer";

Dictionary<string, string> dict = new Dictionary<string, string>();
foreach (DataRow rs in dt.Rows)
{
    dict = new Dictionary<string, string>();
    foreach (DataColumn col in dt.Columns)
    {
        dict.Add(col.ColumnName, rs[col].ToString());
    }
}
return (new JavaScriptSerializer().Serialize(dict));

And I get the following output:

{ "SampleServiceResult": "{\"Id\":\"1\",\"Name\":\"xyz\",\"email\":\"[email protected]\"}" }

But I want the output as below:

{ "SampleServiceResult": {"Id":"1","Name":"xyz","email":"[email protected]"} }

In the output it adds "\" escape character. How can I remove this and return valid json?

I have tried to replace "\" but it doesn't work.

Thanks

Any reason why you're using a table? Data looks more suited to being a proper class to serialize/deserialize to/from.... and where are you looking at the output? if inside the debugger then you'll see the quotes as \" as you have double quotes inside strings. Is this output actually what you see in the client? — GPW
– GPW, Commented Nov 9, 2017 at 9:44
On closer inspection, your result dictionary has a single entry with a key of "SampleServiceResult" and a value of "{\"Id\":\"1\",\"Name\":\"xyz\",\"email\":\"[email protected]\"}" (which is a single string). This suggests your actual problem is that the GetJSONTable() method is returning a single column whereas you appear to expect more than one? as I said above, serialize into a class that matches the data rather than trying to use a datatable unless the data varies by a lot. — GPW
– GPW, Commented Nov 9, 2017 at 9:47
@GPW, Yes I get same out put in client side. I have checked output in postman and in ios device. — Rajesh Pandya
– Rajesh Pandya, Commented Nov 9, 2017 at 10:15
Possible duplicate of How do I return clean JSON from a WCF Service? — GPW
– GPW, Commented Nov 9, 2017 at 10:46
See link - basically you shouldn't return JSON from Web services (create a RESTful service instead), but you should also return an OBJECT (don't try to turn it into a string yourself, let the service do the serialization for you). Finally, don't mess about with a dictionary. if you know what the data looks like, define a class that looks the same and use THAT instead - you then don't need to mess about with dictionaries and data tables. — GPW
– GPW, Commented Nov 9, 2017 at 10:48

Ajay2707 · Accepted Answer · 2018-03-12 12:29:37Z

4

I have got the expected out by applying following changes in my code:

Changed return type from String to Stream
Replaced the below code

return (new JavaScriptSerializer().Serialize(dict));

with

WebOperationContext.Current.OutgoingResponse.ContentType = "application/json; charset=utf-8"; return new MemoryStream(Encoding.UTF8.GetBytes(sData));

Thanks everybody for help and support. May it will help someone.

edited Mar 12, 2018 at 12:29

Ajay2707

5,8286 gold badges44 silver badges61 bronze badges

answered Nov 16, 2017 at 9:38

Rajesh Pandya

1,5504 gold badges22 silver badges33 bronze badges

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

Comments

S.Dav · Accepted Answer · 2017-11-09 14:32:53Z

It is better to let WCF take care of the serialization rather then doing it yourself.

You can use WebGet attribute and specify the response format for your operation contract.

Also, as pointed out in the comments, you could return your own .NET class instead of a Dictionary.

The operation contract could be something similar to this:

[OperationContract]
[WebGet(UriTemplate = "/GetCustomer", ResponseFormat = WebMessageFormat.Json,
BodyStyle = WebMessageBodyStyle.Bare)]
Customer GetCustomer();

with the following data contract:

[DataContract]
public class Customer
{
    [DataMember]
    public string Id { get; set; }
    [DataMember]
    public string Name { get; set; }
    [DataMember]
    public string Email { get; set; }
}

You could then implement the operation contract with code similar to this:

public Customer GetCustomer()
{
        Customer customer = GetCustomerData(); //Get the data and return a customer object
        return customer;
}

Collectives™ on Stack Overflow

WCF web service returning json format data

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related