How to convert raw data to json data ? .

Question

1.00/5 (3 votes)

See more:

Example:

Output:

Raw Data:

{"NewsByIdResult":"[{\"NewsID\":4,\"CompanyID\":0,\"CompanyIds\":null,\"CompanyId\":160,\"CompanyIdVal\":null,\"Topic\":\"280\",\"Industry\":83,\"CompanyLegalName\":\"TCS BUSINESS INFORMATION\"}]"}

Json Data:

{
"NewsByIdResult": "[{"NewsID":4,"CompanyID":0,"CompanyIds":null,"CompanyId":160,"CompanyIdVal":null,"Topic":"280","Industry":83,"CompanyLegalName":"TCS BUSINESS INFORMATION"}]"

}

What I have tried:

var JsonNews = Newtonsoft.Json.JsonConvert.SerializeObject(Lstnews);
return JsonNews;

Using above code for converting List of Objects to Json Data. But i'm getting the output raw data only not like json data. Kinly help i would like json data.

Posted 17-Jun-16 1:29am

Thiyagu Arockiasamy

Updated 20-Jun-16 1:55am

Add a Solution

Comments

F-ES Sitecore 17-Jun-16 7:37am

Does it matter? As long as it is valid json that's what counts.

Thiyagu Arockiasamy 17-Jun-16 8:02am

Okay, then how can to remove the \ symbol in raw data. i couldn't able to bind the value.

F-ES Sitecore 17-Jun-16 9:07am

The "\" isn't really there, VS just adds it when it is showing you the text to let you know that the quote following is a literal quote and not a quote that denotes the start\end of a string.

Thiyagu Arockiasamy 18-Jun-16 1:36am

Okay sir but its not working. i implement joson data with HTML page using jquery its not work.i added my HTML page jquery code please help sir

<script type="text/javascript">
$(document).ready(function () {
debugger
$.ajax({
crossDomain: true,
async: true,
cache: false,
type: "GET",
url: 'http://localhost:25012/ProjectRestService.svc/NewsById/4',
data: JSON.stringify(),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
alert(response.d);
},
failure: function (response) {
alert(response.responseText);
}
});
}
);
</script>

Thiyagu Arockiasamy 17-Jun-16 8:04am

i only got output in raw data i want to need joson data. i used code

var JsonNews = Newtonsoft.Json.JsonConvert.SerializeObject(Lstnews);
return JsonNews;

its only get raw data, but i need json data

{"NewsByIdResult":"[{\"NewsID\":4,\"CompanyID\"Blush | :O ,\"CompanyIds\":null,\"CompanyId\":160,\"CompanyIdVal\":null,\"Topic\":\"280\",\"Industry\":83,\"CompanyLegalName\":\"TCS BUSINESS INFORMATION\"}]"}

Nathan Minier 17-Jun-16 8:27am

It would probably help if the array wasn't being defined as a string.

And if the CompanyID were valid data.

Thiyagu Arockiasamy 17-Jun-16 8:47am

CompanyID No need sir

xszaboj 17-Jun-16 9:09am

are you sure that the raw data is in this format?
{"NewsByIdResult":"[{\"NewsID\":4,\"CompanyID\"Blush | :O ,\"CompanyIds\":null,\"CompanyId\":160,\"CompanyIdVal\":null,\"Topic\":\"280\",\"Industry\":83,\"CompanyLegalName\":\"TCS BUSINESS INFORMATION\"}]"}

what about that smile there? DO you have any control about this data?

Thiyagu Arockiasamy 17-Jun-16 9:13am

Its not a smile Its "CompanyID\":0, In this ID No need

xszaboj 17-Jun-16 9:43am

In that case only thing that you need to do is remove "" around. the array. "[{.....}]" to be [{...}] and then it is valid Json.
JSON.parse('{"NewsByIdResult":[{\"NewsID\":4,\"CompanyID\":0 ,\"CompanyIds\":null,\"CompanyId\":160,\"CompanyIdVal\":null,\"Topic\":\"280\",\"Industry\":83,\"CompanyLegalName\":\"TCS BUSINESS INFORMATION\"}]}')

Thiyagu Arockiasamy 18-Jun-16 1:04am

How can i remove "" . please tell me

Thiyagu Arockiasamy 18-Jun-16 1:48am

Sir, i implement joson data with HTML page using jquery its not work.i added my HTML page jquery code please help me

<script type="text/javascript">
$(document).ready(function () {
debugger
$.ajax({
crossDomain: true,
async: true,
cache: false,
type: "GET",
url: 'http://localhost:25012/ProjectRestService.svc/NewsById/4',
data: JSON.stringify(),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
alert(response.d);
},
failure: function (response) {
alert(response.responseText);
}
});
}
);
</script>

xszaboj 18-Jun-16 15:20pm

where do you get the raw data from?

Thiyagu Arockiasamy 20-Jun-16 0:41am

I get raw data in below code.

public string NewsById(string NewsID)
{
string Status = TokenHelper.IsValidateToken();
using (DbConnection con = db.CreateConnection())
try
{
con.Open();
List<newss> Lstnews = new List<newss>();
DbCommand cmd = db.GetStoredProcCommand("spNews_GetValues", NewsID);
cmd.CommandTimeout = int.MaxValue;
SqlDataReader objnewsRead = (SqlDataReader)db.ExecuteReader(cmd);
while (objnewsRead.Read())
{
Lstnews.Add(new Newss()
{
NewsID = objnewsRead.GetInt32(objnewsRead.GetOrdinal("NewsID")),

NewsCompId = objnewsRead.GetInt32(objnewsRead.GetOrdinal("NewsCompId")),
CompanyId = objnewsRead.GetInt32(objnewsRead.GetOrdinal("CompanyIds")),
CompanyLegalName = objnewsRead.GetString(objnewsRead.GetOrdinal("CompanyLegalName")),

}
var JsonNews = Newtonsoft.Json.JsonConvert.SerializeObject(Lstnews);
return JsonNews;

}
finally
{
con.Close();
}
}

Its my service code

Please help me

xszaboj 20-Jun-16 5:17am

ok that looks fine, so when you call this function what kind of data will you get?
I dont believe it is the raw data.
you have to wrap the raw data somewhere, don't you?

xszaboj 20-Jun-16 5:29am

here is my demo of your code.
https://github.com/xszaboj/convertToJsonDemo

so if you run it, you can see it return valid json, so problem is somewhere else in your code

Thiyagu Arockiasamy 20-Jun-16 6:19am

Dear sir, i check it, you demo output is fine its a valid joson. but my output of json is

{"NewsByIdResult":"[{\"NewsID\":4,\"CompanyId\":160,\"NewsCompId\":7,\"CompanyLegalName\":\"TCS BUSINESS INFORMATION\"}]"}

please how can i remove array of "". if i remove " " its work fine. please help me sir

Thiyagu Arockiasamy 20-Jun-16 6:06am

okay sir thanks a lot.And one more question , How to get json data in html page using jquery.

xszaboj 20-Jun-16 6:26am

for example like this:
$.get( "test.php", { id: 1 } );
documentation here:
https://api.jquery.com/jquery.get/

one more question for you. How do you host your service? Are you using WEB API? or MVC project? or something else?

Thiyagu Arockiasamy 20-Jun-16 6:39am

i am using wcf rest service sir.

Thiyagu Arockiasamy 20-Jun-16 7:02am

i am using wcf rest service WEB API

Thiyagu Arockiasamy 20-Jun-16 6:41am

my rest service code is

[OperationContract]
[WebGet(UriTemplate = "NewsById/{NewsID}", ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped)]
string NewsById(string NewsID);

And my Jquery code of Html page :

<script type="text/javascript">
$(document).ready(function () {
debugger
$.ajax({
crossDomain: true,
async: true,
cache: false,
type: "GET",
url: 'http://localhost:25012/NewsRestService.svc/NewsById/4',
data: JSON.stringify(),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
alert(response.d);
},
failure: function (response) {
alert(response.responseText);
}
});
}
);
</script>

Thiyagu Arockiasamy 20-Jun-16 8:12am

dear sir if i deserialize this JSON the array. "[{.....}]" is displayed. how to remove " " sir. code below

var JsonNews = Newtonsoft.Json.JsonConvert.SerializeObject(Lstnews);
var jobject = sonConvert.DeserializeObject<List<newss>>(JsonNews);
return JsonNews;

xszaboj 20-Jun-16 8:34am

check the solution on github, it is working exactly as you need it

Thiyagu Arockiasamy 21-Jun-16 2:47am

Thanks a Lot sir . IT's working fine to me. Thanks again

Thiyagu Arockiasamy 21-Jun-16 3:20am

Thanks A Lot sir, really you save my lot of time sir..... Thank You very much sir........ It's working fine to me sir.

xszaboj 21-Jun-16 11:20am

Glad to help ;)

1 solution

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)

xszaboj · Accepted Answer · 2016-06-20T01:55:00

I know what your problem is now.
the problem is that you use:

C#

WebGet(UriTemplate = "NewsById/{NewsID}", ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped)]

try it like this:

C#

WebGet(UriTemplate = "NewsById/{NewsID}", ResponseFormat = WebMessageFormat.Json]

it will return the data in this format:
"[{\"NewsID\":3,\"NewsCompId\":2,\"CompanyId\":1,\"CompanyLegalName\":\"demo 1\"},{\"NewsID\":97,\"NewsCompId\":98,\"CompanyId\":99,\"CompanyLegalName\":\"demo 2\"}]"

and you can deserialize this JSON easily with:

JavaScript

JSON.parse("[{\"NewsID\":3,\"NewsCompId\":2,\"CompanyId\":1,\"CompanyLegalName\":\"demo 1\"},{\"NewsID\":97,\"NewsCompId\":98,\"CompanyId\":99,\"CompanyLegalName\":\"demo 2\"}]")

But what I think, you really wanted is this:

C#

[OperationContract]
        [WebGet(UriTemplate = "WrappedListNewsById/{value}", ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped)]
        List<Newss> GetList(string value);

The WCF service is smart enough to serialize the whole list into json for you so you don't have to use

C#

var JsonNews = Newtonsoft.Json.JsonConvert.SerializeObject(Lstnews);

at all.

View my updated github example on:
GitHub - xszaboj/convertToJsonDemo: convertToJsonDemo[^]