how to format JSON by assigning values to node element in javascript/nodejs

Question

I have JSON like below which has every element with field _value

"batchControlInfo" : {
  "sender" : {
    "_value" : "MMRPT"
  },
  "recipient" : {
    "_value" : "AAZTE"
  },
  "fileSequenceNumber" : {
    "_value" : 30
  },
  "fileCreationTimeStamp" : {
    "localTimeStamp" : {
      "_value" : 20200904052019
    },
    "utcTimeOffset" : {
      "_value" : "+0630"
    }
  }
}

How to Convert it to like below, just to remove _value which is in common to every node element.

"batchControlInfo" : {
      "sender" : "MMRPT",
      "recipient""AAZTE",
      "fileSequenceNumber" : 30,
      "fileCreationTimeStamp" : {
        "localTimeStamp" :  20200904052019,
        "utcTimeOffset" : "+0630"
      }
    }

Derek Wang · Accepted Answer · 2020-10-22 09:21:02Z

3

This can be done recursively as follows.

const input = {
  "batchControlInfo" : {
    "sender" : {
      "_value" : "MMRPT"
    },
    "recipient" : {
      "_value" : "AAZTE"
    },
    "fileSequenceNumber" : {
      "_value" : 30
    },
    "fileCreationTimeStamp" : {
      "localTimeStamp" : {
        "_value" : 20200904052019
      },
      "utcTimeOffset" : {
        "_value" : "+0630"
      }
    }
  }
};

function getResult(input) {
  const output = {};
  for (const key in input) {
    if (input[key] && typeof input[key] === "object") {
      if ("_value" in input[key]) {
        output[key] = input[key]["_value"];
      } else {
        output[key] = getResult(input[key]);
      }
    }
  }
  return output;
}

console.log(getResult(input));

answered Oct 22, 2020 at 9:21

Derek Wang

10.2k4 gold badges20 silver badges40 bronze badges

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

1 Comment

Mark Baijens Over a year ago

This will fail when there are objects with values of different type then object that are not named _value. Al tough it works for OP case.You might want to fix that for future readers. Adding else { output[key] = input[key]; } to your first if will fix that.

Collectives™ on Stack Overflow

how to format JSON by assigning values to node element in javascript/nodejs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related