Home > other >  JSON string with custom dynamically columns. Appending in C#
JSON string with custom dynamically columns. Appending in C#

Time:03-06

Have made the following piece of code

        var content = @ " {
          ""
          data "": {
            ""
            id "": 1000000,
            ""
            firstName "": ""
            John "",
            ""
            lastName "": ""
            Doe "",
            ""
            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",
      "Pension_overenskomst":false,
      "Pension 1. arbejdsdag":false
   }
}

CodePudding user response:

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"))

    items.Add((string) item.Value["name"],  item.Value["value"]);
else
    items.Add(item.Name, item.Value);

JObject newData = new JObject();
newData.Add("data", items);
content = newData.ToString();

new content json

{
  "data": {
    "id ": 1000000,
    "firstName ": "John ",
    "lastName ": "Doe ",
    "Pension_overenskomst": false,
    "Pension 1.arbejdsdag": false
  }
}
  • Related