How do I combine two JSON strings so it can later be parse?

Question

0.00/5 (No votes)

See more:

This is the first JSON string:

{
    "ContractID": 140,
    "EndpointIdentifier": "24.2452",
    "ErrorMessage": "",
    "LogFileCollection": [
        "C:/Gaston/GrandScheme/MicroLog4.txt",
        "C:/Gaston/Grandscheme/MicroLog2.txt"
    ],
    "MethodName": "TestModeExit",
    "OperationBegan": "/Date(092120-0400)/",
    "OperationCompleted": "/Date(092120-0400)/",
    "OperationID": 1,
    "Outcome": 0,
    "Parameters": [
        {
            "Name": "ESPN",
            "Value": "23.4.39447",
            "VariableType": "System.String"
        }
    ],
}

And my second JSON file:

{
    "CellRelayESN": "VR-[26::AB::]",
    "CellRelaySerialNumber": "[26::AB::]",
    "ContractID": 0,
    "DeviceClassName": "GastonGrand",
    "EndpointIdentifier": "2.3532.432",
    "ErrorMessage": "",
    "IsAuthenticated": true,
    "IsRegistrationProcessComplete": false,
    "LastDeregistered": "/Date(092120-0500)/",
    "LastRead": "/Date(092120-0500)/",
    "LogFileCollection": [],
    "MethodName": "RegistrationInformation",
    "OperationBegan": "/Date(092120)/",
    "OperationCompleted": "/Date(092120)/",
    "OperationID": 2,
    "Outcome": 0,
    "Parameters": [
        {
            "Name": "jobManager",
            "Value": "jobFoundYesOrNo",
            "VariableType": "String"
        },
        {
            "Name": "ESPN",
            "Value": "2.16.839447",
            "VariableType": "String"
        }
    ],
    "ReturnType": "RegistrationInfoResult",
    "Server": "Host-1",
    "ServiceTypeID": 1,
    "Status": "Registered",
    "TestRunID": 3206,
    "TokenID": null
}

What I have tried:

Currently I am storing these two JSON files into one single columned DataTable that I later convert into a string to be parse with JToken.Parse. However, when I do try to parse it, I encounter the error:

Additional text encountered after finished reading JSON content: {. Path '', line 2, position 0.'

at the

JToken token = JToken.Parse(table);

line. I am wondering, how do I correctly combine these two JSON files into the same string so it can be correctly parse? Here's the rest of my code:

public static List<string> CleanOperationsTable(string liteConString)
        {
            List<string> cleanedList = new List<string>();
            SQLiteConnection liteCon = new SQLiteConnection(liteConString);
            liteCon.Open();
            DataTable dtbl = new DataTable();

            string select = "SELECT ResponseBody FROM Operations LIMIT 2";

            SQLiteCommand cmd = new SQLiteCommand(select, liteCon);
            SQLiteDataAdapter sqliteDAP = new SQLiteDataAdapter(cmd);
            sqliteDAP.Fill(dtbl);

            /// Converts the 1 column DataTable into a single string to 
            /// it's easier to parse with JSON
            string table = string.Join(Environment.NewLine, dtbl.Rows.OfType<DataRow>().Select(x => string.Join(" ; ", x.ItemArray)));

            JToken token = JToken.Parse(table); // ERROR HERE


            return cleanedList;
        }

Posted 22-Sep-20 3:11am

stevenlam505

Updated 22-Sep-20 4:31am

Add a Solution

Comments

Richard MacCutchan 22-Sep-20 9:31am

You should print out the combined text to ensure it is correctly formatted.

stevenlam505 22-Sep-20 9:35am

I believe I encounter an error because of the leading and ending curly braces in each of them. Do you know how I could remove them?

Richard MacCutchan 22-Sep-20 9:43am

You need to look at what you are doing with the data that you extract from your database. What you suggest could be true, but you need to examine the actual data to be certain.

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)

Richard Deeming · Accepted Answer · 2020-09-22T04:31:00

Solution 1

Try something like this:

C#

var rows = dtbl.Rows.Cast<DataRow>().Select(r => Convert.ToString(r[0]))
JArray token = new JArray(rows.Select(r => JToken.Parse(r)));

Posted 22-Sep-20 4:31am

Richard Deeming

Updated 22-Sep-20 4:41am

v2

Comments

stevenlam505 22-Sep-20 10:39am

I assume that I'm supposed to replace the JToken line with that code, but when I do, I receive this error: Severity Code Description Project File Line Suppression State
Error CS1929 'DataRow' does not contain a definition for 'GetString' and the best extension method overload 'DataReaderExtensions.GetString(DbDataReader, string)' requires a receiver of type 'DbDataReader' SQLiteExtractor C:\Users\MainUser\source\repos\SQLiteExtractor\SQLiteExtractor\Program.cs 140 Active

Richard Deeming 22-Sep-20 10:41am

Try Convert.ToString(r[0]) instead of r.GetString(0).

stevenlam505 22-Sep-20 10:47am

That works, thanks so much! Could you explain what this code does?

stevenlam505 22-Sep-20 10:40am

Here's what it looks like https://imgur.com/a/Gk8Ot4o