JSON string with custom dynamically columns. Appending in C#

Question

Have made the following piece of code

        var content = @ " {
          ""
          data "": {
            ""
            id "": 1000000,
            ""
            firstName "": ""
            John "",
            ""
            lastName "": ""
            Doe "",
            ""departments"": [2245],
            ""employeeGroups"": [],
            ""
            custom_186549 "": {
              ""
              name "": ""
              Pension_overenskomst "",
              ""
              type "": ""
              Boolean "",
              ""
              value "": false
            },
            ""
            custom_186550 "": {
              ""
              name "": ""
              Pension 1. arbejdsdag "",
              ""
              type "": ""
              Boolean "",
              ""
              value "": false
            }
          }
        }
        ";

        JObject names = JObject.Parse(content);

        IEnumerable < JToken > CustomColumnsFirst = names.SelectTokens("$.data");

        foreach(JToken item in CustomColumnsFirst) {
          Console.WriteLine(item);
        }

        IEnumerable < JToken > CustomColumnsNames = names.SelectTokens("$.data.*.name");
        IEnumerable < JToken > CustomColumnValues = names.SelectTokens("$.data.*.value");

I'm stuck here, managed to get the names and values into an JToken "Array" but kinda need both a way to combine the CustomColumnNames and the CustomColumnValues, but then also appending them back onto the main data. The content of the "customs" are inditical though but the custom name itself varies. The order of the values inside the customers are random aswell though

I'm quite new to C# coding, so don't know much of the basics yet.

I would need to return a json string with this format without typing in the "custom" column name as that one can differ based on what the API returns:

{
   "data":{
      "id":1000000,
      "firstName":"John",
      "lastName":"Doe",
      "departments": [2245],
      "employeeGroups": []
      "Pension_overenskomst":false,
      "Pension 1. arbejdsdag":false
   }
}

Is it an option to change your json so that the custom items are an array of objects instead of individual objects with unpredictable names? — Crowcoder
– Crowcoder, Commented Mar 5, 2022 at 13:40
@crowcoder, can't change anything, this is how i receive the response from the API unfortunately. The content of the "customs" are inditical though but the custom name itself varies. — Alexander Milland
– Alexander Milland, Commented Mar 5, 2022 at 15:22
That's an unfortunate misuse of json. At a glance it looks like Serge has shown you what to do. — Crowcoder
– Crowcoder, Commented Mar 5, 2022 at 15:43

Serge · Accepted Answer · 2022-03-05 18:34:37Z

2

try this

var data = ((JObject)JObject.Parse(content)["data"]);

JObject items = new JObject();
foreach (var item in data.Properties())
if ( item.Name.Contains("custom"))
//or, thanks to iSR5
 if ( item.Name.StartsWith("custom"))
        if (item.Name.StartsWith("custom"))
        {
          if ((string)item.Value["type"] == "Boolean")
                items.Add((string)item.Value["name"], item.Value["value"]);
            else if ((string)item.Value["type"] == "Text") items.Add("name", item.Value["value"]);
        }
else
        items.Add(item.Name, item.Value););


JObject newData = new JObject();
newData.Add("data", items);
content = newData.ToString();
//or
 content = newData.ToString(Newtonsoft.Json.Formatting.None);

new content json

{
  "data": {
    "id ": 1000000,
    "firstName ": "John",
    "lastName ": "Doe",
    "departments": [
      2245
    ],
    "employeeGroups": [],
    "Pension_overenskomst": false,
    "Pension 1.arbejdsdag": false,
    "name": "John Doe"
  }
}

edited Mar 5, 2022 at 18:34

answered Mar 5, 2022 at 15:04

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

9 Comments

iSR5 Over a year ago

item.Name.Contains("custom") would be better if changed to StartWith

Alexander Milland Over a year ago

Serge solution looks like it's doing the trick!

Alexander Milland Over a year ago

@iSR5 It's StartsWith right? Otherwise it doesn't seem to be a function

Alexander Milland Over a year ago

Do you know how i can return the JObject newData back into a jsonstring? Need to upload the result in a flat .json file

Serge Over a year ago

@AlexanderMilland content = newData.ToString(); I updated my answer

|

Collectives™ on Stack Overflow

JSON string with custom dynamically columns. Appending in C#

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related