Create a JSON object from simple string in C#

Question

I am getting a string as a response from my command line. I want to convert it into a json string , which i will later use to convert to a c# object.

The string Response(sub variable has this string as value) 
Access Token      00D0E00000019dU!
Alias             accp
Client Id         SalesforceDevelopmentExperience
Connected Status  Connected
Id                00D
Instance Url      https://my.salesforce.com
Username          ankur

tried converting it into json by below code

string[] subArray = sub.Split('\n'); 
            string output = JsonConvert.SerializeObject(subArray);                       
            var result = JsonConvert.DeserializeObject<Token>(output);

Token Class

public class Token
    {
        public string AccessToken { get; set; }
        public string Alias { get; set; }

    }

It Gives this error

Cannot deserialize the current JSON array (e.g. [1,2,3]) into type 'Token' because the type requires a JSON object (e.g. {"name":"value"}) to deserialize correctly.
To fix this error either change the JSON to a JSON object (e.g. {"name":"value"}) or change the deserialized type to an array or a type that implements a collection interface (e.g. ICollection, IList) like List<T> that can be deserialized from a JSON array. JsonArrayAttribute can also be added to the type to force it to deserialize from a JSON array.
Path '', line 1, position 1

.

Converted JSON

["Access Token      00D0E00000019dU!AQU","Alias             accp","Client Id         SalesforceDevelopmentExperience","Connected Status  Connected","Id                00D","Instance Url      https://my.salesforce.com","Username          ankur"]

Any Help to convert the string into a JSON/C# object?

yes sub is the string which has the value.Edited the question — ankur
– ankur, Commented Jul 6, 2018 at 12:24
other than .Spliting on new lines - have you tried parsing it differently? — Daniel A. White
– Daniel A. White, Commented Jul 6, 2018 at 12:25
No i have not tried any thing else, I am open for suggestion . Can you put a example of other approach and paste it as a answer — ankur
– ankur, Commented Jul 6, 2018 at 12:27
What is the gap between the property name and value? It looks like spaces so you're going to have to split that string by length. — DavidG
– DavidG, Commented Jul 6, 2018 at 12:30

DavidG · Accepted Answer · 2018-07-06 12:35:26Z

1

It looks far simpler to forget about JSON and parse manually. For example:

//split up the source string into name value pairs
var nameValues = sub.Split('\n')
    .Select(s => new
    {
        Name = s.Substring(0, 18).Trim(), 
        Value = s.Substring(18).Trim() 
    });

//Create the token object manually
var token = new Token
{
    AccessToken = nameValues.Single(v => v.Name == "Access Token").Value,
    Alias = nameValues.Single(v => v.Name == "Alias").Value
};

answered Jul 6, 2018 at 12:35

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

2 Comments

ankur Over a year ago

it worked like a charm. Many thanks for your help. Can you explain this s.Substring(0, 18) how did you came up with the number 18 here

DavidG Over a year ago

Substring just takes a portion of a string. In this case we take the first 18 characters which is the left part of each line, then all the characters are the first 18 for the value.

Michał Stachyra · Accepted Answer · 2018-07-06 12:51:41Z

First of all you should parse this 'sub' string in different way. Second you should create JObject not trying serialize Array of strings.

Try this

// Splitting into string lines
var subArray = sub.Split('\n')
    .Where(x => !string.IsNullOrEmpty(x));

JObject tokenJObj = new JObject();
foreach (var oneSub in subArray)
{
// I assume that the value will be after the last empty character
    tokenJObj.Add(
        oneSub.Substring(0, oneSub.LastIndexOf(' ')).Trim(), 
        oneSub.Substring(oneSub.LastIndexOf(' ') + 1));
}
string tokenStringJson1 = tokenJObj.ToString();
// or
string tokenStringJson2 = JsonConvert.SerializeObject(tokenJObj);

Then just add correct attribute on propteries inside your model

public class Token
    {
        [JsonProperty("Access Token")]
        public string AccessToken { get; set; }

        // In this property attribute is not requied
        [JsonProperty("Alias")]
        public string Alias { get; set; }
    }

Collectives™ on Stack Overflow

Create a JSON object from simple string in C#

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related