How to get the information from json array?

Question

1.00/5 (1 vote)

See more:

how to get result_code from this array ?

"Array\n(\n    [result] => false\n    [result_code] => TS-1027\n    [result_message] => There is no balance in the account\n)\n"

What I have tried:

JObject details = JObject.Parse(result);
string Code = (string)details["result_code"];

but this error appear Unexpected character encountered while parsing value: A. Path '', line 0, position 0

Posted 11-Aug-20 3:19am

Golden Basim

Updated 11-Aug-20 4:58am

Add a Solution

Comments

Richard MacCutchan 11-Aug-20 9:42am

As Chris C already explained, that is not JSON. You need to talk to the people who provide it to you.

3 solutions

Solution 1

That text isn't valid JSON output, that instead looks like the output from printing a PHP array. If you're encoding the array you should consider using the PHP json_encode[^] function instead which would produce a valid output similar to:

{ "result": false, "result_code": "TS-1027", "result_message": ".." }

Posted 11-Aug-20 3:24am

Chris Copeland

Comments

Golden Basim 11-Aug-20 9:36am

no, I'm not the code developer. i just get this result from the SMS service provider. so i should deal with this result anyway.

Chris Copeland 11-Aug-20 9:49am

That's unfortunate. Without being able to manipulate the output, I don't think there's any standard way in C# to decode a PHP array output to an object.

In this case you would probably need to either: a) manually parse the response character by character to extract the values you need; b) use regular expressions to extract the information from the text; c) use regular expressions to reformat the response into a valid JSON format and then attempt to deserialize it.

An example regular expression might be something like \[result\]\s+?\=\>\s+?(true|false)

Solution 3

You could use regex

C#

string text = @"Array\n(\n    [result] => false\n    [result_code] => TS-1027\n    [result_message] => There is no balance in the account\n)\n";
var matches = Regex.Matches(text, @"\[(\w*)\]\s=>\s([^\\]*)");

foreach (Match m in matches)
{
    string name = m.Groups[1].Value;
    string value = m.Groups[2].Value;

    System.Diagnostics.Debug.WriteLine(name + " = " + value);
}

result

result = false
result_code = TS-1027
result_message = There is no balance in the account

Posted 11-Aug-20 4:58am

F-ES Sitecore

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)

OriginalGriff · Accepted Answer · 2020-08-11T03:50:00

That isn't JSON, or even close to: you will have to either write your own parser for it or talk to whoever produced it and find out exactly what data specification should are working with (in fact, you pretty much want to do that anyway - you'll probably need it in order to write your own parser).
A JSON array of those would look like this:

{Array:[{"result":"false", "result_code":"TS-1027", "result_message":"There is no balance in the account"}]}

And would work with these classes:

C#

public class Array
{
    public string result { get; set; }
    public string result_code { get; set; }
    public string result_message { get; set; }
}

public class Example
{
    public IList<Array> Array { get; set; }
}

Have a look at these:
Create C# classes from JSON[^]
And
Create JSON from C# classes[^]