Construct JSON using C#

Question

I am constructing a JSON Body for the POST method for my Odata endpoint call like below

 Newtonsoft.Json.Linq.JObject sample;
sample = new Newtonsoft.Json.Linq.JObject();

sample["status"] = "New";
sample[ "[email protected]"] = "["+"/PROJECT('" + prjBarcode + "')"+"]";

Where [email protected] is an array. I am looking that the JSON to be built like

 "status": "New",
 "[email protected]":["/PROJECT('PJ1')"]

But with my code above it is generating like

  "[email protected]":"[/PROJECT('PJ1')]"

Where the [] comes with in the "" how can I fix this

What's the type of sample and how is json generated?

Oleksandr
– Oleksandr

2019-02-04 16:24:09 +00:00
Commented Feb 4, 2019 at 16:24 — Oleksandr
– Oleksandr, Commented Feb 4, 2019 at 16:24
What is sample?

DavidG
– DavidG

2019-02-04 16:24:12 +00:00
Commented Feb 4, 2019 at 16:24 — DavidG
– DavidG, Commented Feb 4, 2019 at 16:24
@Alexander Sorry I updated my question now

trx
– trx

2019-02-04 16:26:31 +00:00
Commented Feb 4, 2019 at 16:26 — trx
– trx, Commented Feb 4, 2019 at 16:26
@DavidG I have updated my question

trx
– trx

2019-02-04 16:30:19 +00:00
Commented Feb 4, 2019 at 16:30 — trx
– trx, Commented Feb 4, 2019 at 16:30

DavidG · Accepted Answer · 2019-02-04 16:34:14Z

2

In JSON, square braces ([...]) denote an array, so you need to create one, for example:

var array = new Newtonsoft.Json.Linq.JArray(new string[] {"/PROJECT('" + prjBarcode + "')" });
sample["[email protected]"] = array;

You should also consider using interpolated strings, it makes your code a lot more readable:

var array = new Newtonsoft.Json.Linq.JArray(new string[] {"/PROJECT('{prjBarcode}')" });

Though, I wouldn't be building up JSON like this in the first place. You should create a concrete type to do it that matches your structure and serialise it. For example:

public class Data
{
    public string Status { get; set; }
    [JsonProperty("[email protected]")]
    public string[] Projects { get; set; }
}

var json = JsonConvert.SerializeObject(new Data
{ 
    Status = "New", 
    Projects = new string[] {$"/PROJECT('{prjBarcode}')" } 
});

edited Feb 4, 2019 at 16:34

answered Feb 4, 2019 at 16:26

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

2 Comments

trx Over a year ago

I am getting error Cannot implicitly convert type 'string[]' to 'Newtonsoft.Json.Linq.JToken'

DavidG Over a year ago

Fixed, and added a better option.

Oleksandr · Accepted Answer · 2019-02-04 16:32:16Z

0

You are passing string value for [email protected] key and you just need to pass an array

sample[ "[email protected]"] =  new JArray(new []{ "/PROJECT('" + prjBarcode + "')" });

or you can use another overload of JArray constructor

sample[ "[email protected]"] =  new JArray("/PROJECT('" + prjBarcode + "')");

edited Feb 4, 2019 at 16:32

answered Feb 4, 2019 at 16:26

Oleksandr

9,7601 gold badge22 silver badges45 bronze badges

1 Comment

trx Over a year ago

I am getting error Cannot implicitly convert type 'string[]' to 'Newtonsoft.Json.Linq.JToken'

Collectives™ on Stack Overflow

Construct JSON using C#

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related