How to serialize json which has header and request inside parent header and request.

Question

1.00/5 (3 votes)

See more:

URL : https://demo.abcd.cloud/icr/service?cmd=UPLOAD&format=json[^]

Body message as bellow :
Below is my Text Visualizer of uploaddata string.

{Header: {WorkstationId: DC3397CC-A2B6-C704-032E-0154EC02C7E8}
,Request:{Command: Add,
Add: {
UploadType: 1,
MsgRequest: "{
Header: {
WorkstationId: DC3397CC-A2B6-C704-032E-0154EC02C7E8 },
Request: {
SaleCodeExt: 29CPQRSW,
WorkstationId: DC3397CC-A2B6-C704-032E-0154EC02C7E8,
AccountId: 42E6B6C1-6CF2-0788-033B-0154EC06FD9B,
ShipAccountId: 42E6B6C1-6CF2-0788-033B-0154EC06FD9B,
TransactionDateTime: 2016-05-31T11:36:43.264+0200 ,
TransactionType: 1,
Approved: true,
Paid: true,
Encoded: true,
Printed: true,
Validated: true,
SendOrderConfirmation: false,
CreateOrderConfirmation: false,
OrderDocTemplateId: null,
IncludeOrderConfirmationTickets: false,
PortfolioList: [{
WalletDeposit: 0,
PortfolioGroup: PF1 ,
MediaList: [{
MediaStatus: 0,
MediaType: 0,
MediaSerial: 1,
EncodeDateTime: 2016-05-31T11:36:43.264+0200 ,
EncodeFiscalDate: 2016-05-31 ,
ExclusiveUse: true,
MediaCodeList: [{
MediaCode: 1835EY41EP2PE8 ,
MediaCodeType: 0
}]
}]
}],
TaxInInvoice: false,
SaleItemList: [{
ChargeToWallet: false,
Quantity: 1,
UnitRawPrice: 100,
ProductId: C683CF77-8C88-B8F9-0F95-0150050EDE6B ,
UnitAmount: 100,
TotalAmount: 100,
TotalTax: 0,
GroupTicketOption: 1,
PerformanceTypeId: null,
TaxCalcType: 1,
PresaleUnitAmount: 0,
UnitTax: 0,
SaleItemDetailList: [{
Position: 1,
PortfolioGroup: PF1
}]
}],
PaymentList: [{
PaymentType: 2,
PaymentStatus: 2,
PaymentAmount: 100
}]
}
}"
}
}
}

System answer :
{"Answer":{"Add":{"UploadId":"E3EE30DF-0401-AB90-0244-015507753E3E"}},"Header":{"Ver":"8.3.11.7","RequestCode":"UPLOAD","ETime":62,"SystemTimestamp":"2016-05-31T17:36:12.141+0200","StatusCode":200,"Session":"EFEE7BA6BCE479477A7FE18294DDE203"}}

The target is to upload the data to the system which is on cloud.
Though status code is 200 (success) Error is coming header part which is inside.

Error message in back office of system is :

C#

Expected a ',' or '}' at 514 [character 515 line 1]
{                            Header: {                             WorkstationId: DC3397CC-A2B6-C704-032E-0154EC02C7E8     },

I have tried with other examples and if there is only single header with request code is executing without any error in back office.

What I have tried:

below code i have tried:

System.Net.Http.HttpClient client = new System.Net.Http.HttpClient();
client.BaseAddress = new System.Uri(SnAPIUrl);
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
System.Net.Http.HttpContent content1 = new StringContent(DATAUpload,UTF8Encoding.UTF8,"application/json");

HttpResponseMessage messge = client.PostAsync(SnAPIUrl, content1).Result;

if (messge.IsSuccessStatusCode)
{
string result = messge.Content.ReadAsStringAsync().Result;
Response.Write(result);
//return result;
}

Posted 31-May-16 5:43am

nipen.mehta

Updated 2-Jun-16 2:45am

v2

Add a Solution

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)

George Jonsson · Answer 1 · 2016-05-31T16:37:00

Solution 1

You need to put quotation marks around the variables and string values:

Java

{
	"Header": {
		"WorkstationId": "DC3397CC - A2B6 - C704 - 032E-0154 EC02C7E8"
	},
	"Request": {
		"Command": "Add",
		"Add": {
			"UploadType": 1,
			"MsgRequest": {
				"Header": {
					"WorkstationId": "DC3397CC - A2B6 - C704 - 032E-0154 EC02C7E8"
				},
etc.

Look at the system answer.

See JSON Tutorial[^]

And this is one tool that can be used to validate JSON: JSONLint - The JSON Validator.[^]
Use this tool to test our JSON data to see if it is correct or not.

Posted 31-May-16 16:37pm

George Jonsson

Updated 31-May-16 16:39pm

v2

Comments

nipen.mehta 1-Jun-16 0:33am

@ George : I am using C# asp.net and posting the above mentioned json string. yes i agree with you that json require "" when it post data, that will handle by default by the code which i have tried above. In simple header and request I am not facing any problem in post data. Here I have header inside header.
I am looking for the solution where i can serialize the complete json before I execute PostAsync;
HttpResponseMessage messge = client.PostAsync(SnAPIUrl, content1).Result;

George Jonsson 1-Jun-16 5:39am

Do you mean serialize a C# object to JSON?
Your statements are confusing because the error code you have shown in the question is because of the lack of quotation marks (") and the JSON code you show is without them.

nipen.mehta 1-Jun-16 6:03am

Yes, serialize from C# to JSON. The code I have posted above is Text visualizer of DATAUpload variable. so it will not have "".

<pre lang="C#">System.Net.Http.HttpContent content1 = new StringContent(DATAUpload,UTF8Encoding.UTF8,"application/json");</pre>

C#.Net will do post from below code.

<pre lang="C#">HttpResponseMessage messge = client.PostAsync(SnAPIUrl, content1).Result;</pre>

And I am receiving Answer too as expected :

{"Answer":{"Add":{"UploadId":"E3EE30DF-0401-AB90-0244-015507753E3E"}},"Header":{"Ver":"8.3.11.7","RequestCode":"UPLOAD","ETime":62,"SystemTimestamp":"2016-05-31T17:36:12.141+0200","StatusCode":200,"Session":"EFEE7BA6BCE479477A7FE18294DDE203"}}

-- I am receiving the answer but transaction is failed in back office because of format.

The error is showing in backoffice system where the above post is happening.
I have checked with other request which has one header and request the same code is working properly and status success in backoffice too. I want to know how can i serialize this insider header and request which is giving me error in backoffice. It should have done by itself from C# only same like other normal request. But is not happening.

George Jonsson 1-Jun-16 10:46am

Well, that is not easy to know for anyone but you.
You say you get an error sending your JSON data, and the JSON structure you show is not in a valid format, so what am I supposed to think?
Have you tried to validate the true JSON output in the online tool I linked?
Just convert the data to a string or save to a file and then paste it into the validator. If you do that you might find the problem.
And why don't you ask the back office guys what is wrong with the format?

As you don't show the true JSON data it is difficult to give more help. This is weird though.
MsgRequest: "{
Header: {
What is the quotation mark doing there?

nipen.mehta 2-Jun-16 1:23am

Yes I have tried that link and validate json already. over there i have to put "" for sure because it will accept only tipical format of json. If you know about postman tool
[^] in that we don't require to put "". If I am doing the post request with postman it is posting data successfully in backoffice. Same way C#.Net also handle "" when I pass format <pre lang="XML">application/json</pre>

Please check here :
<pre lang="C#">System.Net.Http.HttpContent content1 = new StringContent(DATAUpload,UTF8Encoding.UTF8,"application/json");

HttpResponseMessage messge = client.PostAsync(SnAPIUrl, content1).Result;</pre>
I am formatting the content of DATAUpload into json and then with HttpResponseMessage I am posting result to specific URL. So there is no worry of "" from my client side (Asp.Net page)

MsgRequest: "{
Header: {

and in bottom of json also
PaymentStatus: 2,
PaymentAmount: 100
}]
}
}"
}
}
}

That I handle in C# code with regular expression.
@"{Header: {WorkstationId: DC3397CC-A2B6-C704-032E-0154EC02C7E8}
,Request:{Command: Add,
Add: {
UploadType: 1,
MsgRequest: ""{
Header: {
.......
.....
}
}""
}
}
}";

If I have simple header and request then no issue. Even C#.Net is not giving me any error when I execute this code which i have posted. If you see, I have also posted Answer in bold format, this is coming in result.
<pre lang="C#">string result = messge.Content.ReadAsStringAsync().Result;</pre>

Error is coming in back office and data is not uploading and giving me format error issue. And I am sure this error is at insider header only. because when i try to some format change its giving me error there only. Can you please help me with any other example reference which has this kind of format of double header and request.I really appreciate your time and effort. Thank you very much. This is really choking issue for me, need help.

George Jonsson 2-Jun-16 1:37am

If you are so sure your JSON format is correct, you better talk to the guys at back office.
Send the JSON string in a mail and ask why it is not accepted.

nipen.mehta 2-Jun-16 9:05am

My friend, the format which is communicating with back office system will be convert through C#.Net code.
StringContent(DATAUpload,UTF8Encoding.UTF8,"application/json");
HttpResponseMessage messge = client.PostAsync(SnAPIUrl, content1).Result;

The same json will not go in this format to post data. I think we are not on same page yet. Anyways thank you so much.

George Jonsson 2-Jun-16 10:06am

We are definitely not on the same page.
My point is that if you extract the JSON data as a string, using the debugger or saving it to a file, and then send it as a mail to the administrator of the receiving system, they could tell you if your JSON data is valid or not.

nipen.mehta 2-Jun-16 10:11am

I have checked it with Postman tool. with help of it i can make post request to url with json. It worked properly. Postman is tool for web api.

George Jonsson 2-Jun-16 10:15am

So what is the difference between the JSON data from the Postman tool and the JSON data you create in your code?
And don't tell me there is no difference if one way works and the other doesn't.

nipen.mehta 2-Jun-16 10:36am

Postman is third party tool which accept body message and url request and send us answer back.

I have already achieved Save Account post in back office and below is my json.

{Header: {WorkstationId: DC3397CC-A2B6-C704-032E-0154EC02C7E8, RequestCode: SaveAccount}, Request: {
Command: SaveAccount,
SaveAccount: {
EntityType: 15,
MetaDataList: [{
Value: Fabio
}, {
Value: Jackson
}, {
Value: name@email.com
}]
}
} }

System.Net.Http.HttpClient client = new System.Net.Http.HttpClient();
client.BaseAddress = new System.Uri(SnAPIUrl);
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));

System.Net.Http.HttpContent content1 = new StringContent(DATA, UTF8Encoding.UTF8, "application/json");
HttpResponseMessage messge = client.PostAsync(SnAPIUrl, content1).Result;

if (messge.IsSuccessStatusCode)
{
string result = messge.Content.ReadAsStringAsync().Result;
return result;
}
else
{
return null;
}

If you see above my C# .Net code is same.Through this code json string will parse in json format. It has in build functionality.
I did not get error in back office because i have just one header and inside just one request. If you see my posted json example, it has two header and request, this is what is not able to handle by my code.

George Jonsson 2-Jun-16 10:48am

So the Postman tool and your back office system doesn't agree on the correct JSON format?
Then you have to adapt to the format the back office system requires.
As far as I know, double quotes surrounding a variable name are required.
See JSON Syntax[^]

nipen.mehta 2-Jun-16 10:56am

Yes double quotes surrounding a variable name is required. I am agree with that. But the json before going to back office system will format by C#.Net code which i have posted above.

The scenario is from asp.net client page i got form data like name,last name and email. when i do submit it will post request to back office system through web api. and the communication will be in json format. So in the above json string with the help of variable i can pass my data and then with the help of C#.Net code below it will make the whole string into json format and will do PostAsync. You can consider it as string also which will become proper formatted json before it post in back office.

Communication is through json only in back office.

George Jonsson 2-Jun-16 17:31pm

So what does the JSON string look like AFTER it has passed the C# code?
I'm not going to execute the code. That is your job.

So you don't have any support channel to the back office??? That's kind of weird.

nipen.mehta 5-Jun-16 3:27am

I have already mentioned that communication is in json.
I am not expecting any code execution from you. I have asked many times regarding scenario of header inside header format json string which i have in my example but did not find any comments regarding that. Please do comment if you can say about this scenario. Thank you.