Guide on transforming a list of fields into a JSON object

Question

Guide on transforming a list of fields into a JSON object

I am looking for a solution to convert my list of fields, stored as a string, into a JSON object. The fields are listed as follows:

[
"Container.Description",
"Container.Groups.12.Users.11.Name",
"Container.Groups.12.Users.12.Name",
"Container.Groups.13.Users.21.Name",
"Container.Groups.13.Users.22.Name"
]

The desired output should be in the following JSON format:

{
  "Container": {
    "Description": "",
    "Groups": [
      {
        "12": {
          "Users": [
            { "11": { "Name": "" }},
            { "12": { "Name": "" }}
          ]
        }
      },
      {
        "13": {
          "Users": [
            { "21": { "Name": "" }},
            { "22": { "Name": "" }}
          ]
        }
      }
    ]
  }
}

If anyone can assist with converting this code into TypeScript or C#, I would greatly appreciate it. Thank you in advance!

c#json typescript

Answer 1

Answer №1

While this may not be the most elegant solution, it does get the job done...

    processData(inputData: string[]) {
        const result = {};

        inputData.forEach(item => this.updateObject(result, item));

        return result;
    }

    private updateObject(currentObj: { [key: string]: any }, value: string) {
        const keyArray = value.split('.');
        let objPointer = currentObj;

        for (let i = 0; i < keyArray.length; i++) {
            const key = keyArray[i];

            // If the key exists
            if (objPointer[key]) {
                objPointer = objPointer[key];
                continue;
            }

            // If the key does not exist:
            // This is the final key
            if (i === keyArray.length - 1) {
                objPointer[key] = '';
            } else {
                // This is not the final key
                objPointer[key] = {};
                objPointer = objPointer[key];
            }
        }
    }

Answer 2

While this may not be the most elegant solution, it does get the job done...

    processData(inputData: string[]) {
        const result = {};

        inputData.forEach(item => this.updateObject(result, item));

        return result;
    }

    private updateObject(currentObj: { [key: string]: any }, value: string) {
        const keyArray = value.split('.');
        let objPointer = currentObj;

        for (let i = 0; i < keyArray.length; i++) {
            const key = keyArray[i];

            // If the key exists
            if (objPointer[key]) {
                objPointer = objPointer[key];
                continue;
            }

            // If the key does not exist:
            // This is the final key
            if (i === keyArray.length - 1) {
                objPointer[key] = '';
            } else {
                // This is not the final key
                objPointer[key] = {};
                objPointer = objPointer[key];
            }
        }
    }

Guide on transforming a list of fields into a JSON object

Answer №1

Similar questions

Contrast the validation process for a dropdown menu containing times in AM/PM format

The AutoComplete feature of MaterialUI Component fails to function properly even when there is available data

Exploring the detection of changes in variables using Aurelia

Is it possible to retrieve information from a json file?

Angular 4 yields an undefined result

Error: Virtual script not located; possibly absent <script lang="ts" / "allowJs": true / within the jsconfig.json.volar

Can you identify the specific syntax for a 'set' function in TypeScript?

What is the best way to switch from using AsyncTask to Retrofit in order to retrieve data from a WCF Webservice

Reading a 500KB JSON file within an Android operating system

Is there room for improvement in the way I handle concurrency?

Is there a way to change a typescript enum value into a string format?

Spring 4.0.x is returning a HTTP/1.1 error code 406 Not Acceptable in response to a JSON

Issue with Android: JSONObjects are only able to parse the last object within the file

Pause for a few moments prior to initializing Bootstrap and Angular 2

Using Google's PageSpeed API with the .NET framework

Clone a task or project in Asana

What is the best method to extract pictures from "Google Images" by utilizing the custom search API when the control panel restricts users to inputting only website URLs for searching?

Manipulating variables across various methods in TypeScript

Populate a cell in a dataframe with an array of values

What is the reasoning behind certain libraries offering methods that perform identical tasks, but one in synchronous and the other in asynchronous context?