Generate list from JavaScript object

Question

This is my data:

var tabledata = {
0: {Name: "Server1", PRPName: "NO_PRP", OperatingSystem: "Linux", SLA: "SILVER", Environment: "Accept"}
1: {Name: "Server2", PRPName: "services", OperatingSystem: "Linux", SLA: "SILVER", Environment:"Accept"}
2: {Name: "Server3", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"}
3: {Name: "Server4", PRPName: "services", OperatingSystem: "Linux", SLA: "GOLD", Environment: "Accept"}
4: {Name: "Server5", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"}
5: {Name: "Server6", PRPName: "sql", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"}
6: {Name: "Server7", PRPName: "services", OperatingSystem: "Linux", SLA: "GOLD", Environment: "Production"}
7: {Name: "Server8", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Production"}
8: {Name: "Server9", PRPName: "sql", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Production"}

And i need to create a list from Name: like this.

servernames = ["Server1","Server2","Server3","Server4","Server5","Server6","Server7","Server8"]

You should be having an array, instead of an element, and even if you want to have an element then your field names are invalid. Once you fix your JSON, you can use the map function and return the names of the elements in that list. — Afzaal Ahmad Zeeshan
– Afzaal Ahmad Zeeshan, Commented Oct 3, 2019 at 10:12
Is this something you need? const servernames = Object.values(tabledata).map(({ Name }) => Name) — Sebastian Kaczmarek
– Sebastian Kaczmarek, Commented Oct 3, 2019 at 10:12
Objects with keys 0 to 8 desire to be arrays. Object.values(tabledata).map(({ Name }) => Name);. — Shilly
– Shilly, Commented Oct 3, 2019 at 10:12
Your snippet contains JavaScript syntax errors -- I am assuming you are constructing an array referred to with tabledata, but you need to separate element definition with commas, and you are missing a closing curly bracket. — Armen Michaeli
– Armen Michaeli, Commented Oct 3, 2019 at 10:23

Alberto Trindade Tavares · Accepted Answer · 2019-10-03 10:27:29Z

3

As pointed out by the others, you have a JavaScript object (a map between numbers and objects representing server data), and not a JSON.

To get the server names from this object, you can use Object.values to first extract the object's property values with server information and then map to get only the server name, generating an array with those:

var tabledata = {
  0: {Name: "Server1", PRPName: "NO_PRP", OperatingSystem: "Linux", SLA: "SILVER", Environment: "Accept"},
  1: {Name: "Server2", PRPName: "services", OperatingSystem: "Linux", SLA: "SILVER", Environment:"Accept"},
  2: {Name: "Server3", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
  3: {Name: "Server4", PRPName: "services", OperatingSystem: "Linux", SLA: "GOLD", Environment: "Accept"},
  4: {Name: "Server5", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
  5: {Name: "Server6", PRPName: "sql", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
  6: {Name: "Server7", PRPName: "services", OperatingSystem: "Linux", SLA: "GOLD", Environment: "Production"},
  7: {Name: "Server8", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Production"},
  8: {Name: "Server9", PRPName: "sql", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Production"}
};
var servernames = Object.values(tabledata).map((server) => server.Name);

console.log(servernames);

edited Oct 3, 2019 at 10:27

answered Oct 3, 2019 at 10:14

Alberto Trindade Tavares

10.5k6 gold badges42 silver badges49 bronze badges

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

1 Comment

oygen Over a year ago

var servernames = Object.values(tabledata).map(server => server.Name); get rid of the parenthesis around the args inside map function to make it even more shorter

Archit Garg · Accepted Answer · 2019-10-03 10:17:34Z

Your JSON:

var tabledata = {
"0": {Name: "Server1", PRPName: "NO_PRP", OperatingSystem: "Linux", SLA: "SILVER", Environment: "Accept"},
"1": {Name: "Server2", PRPName: "services", OperatingSystem: "Linux", SLA: "SILVER", Environment:"Accept"},
"2": {Name: "Server3", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
"3": {Name: "Server4", PRPName: "services", OperatingSystem: "Linux", SLA: "GOLD", Environment: "Accept"},
"4": {Name: "Server5", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
"5": {Name: "Server6", PRPName: "sql", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
"6": {Name: "Server7", PRPName: "services", OperatingSystem: "Linux", SLA: "GOLD", Environment: "Production"},
"7": {Name: "Server8", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Production"},
"8": {Name: "Server9", PRPName: "sql", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Production"}
};

You could use Object.values to get an array of values of your tabledata object and then apply Array.prototype.map to transform the values to server names like so:

const serverNames = Object.values(tabledata).map((server) => server.Name);
console.log(serverNames);

It will print:

["Server1", "Server2", "Server3", "Server4", "Server5", "Server6", "Server7", "Server8", "Server9"]

cccn · Accepted Answer · 2019-10-03 10:16:30Z

Try this one:

var tabledata = {
0: {Name: "Server1", PRPName: "NO_PRP", OperatingSystem: "Linux", SLA: "SILVER", Environment: "Accept"},
1: {Name: "Server2", PRPName: "services", OperatingSystem: "Linux", SLA: "SILVER", Environment:"Accept"},
2: {Name: "Server3", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
3: {Name: "Server4", PRPName: "services", OperatingSystem: "Linux", SLA: "GOLD", Environment: "Accept"},
4: {Name: "Server5", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
5: {Name: "Server6", PRPName: "sql", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Accept"},
6: {Name: "Server7", PRPName: "services", OperatingSystem: "Linux", SLA: "GOLD", Environment: "Production"},
7: {Name: "Server8", PRPName: "NO_PRP", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Production"},
8: {Name: "Server9", PRPName: "sql", OperatingSystem: "Windows", SLA: "GOLD", Environment: "Production"}
}

const result = Object.keys(tabledata).map(el => tabledata[el].Name)
console.log(result)

Collectives™ on Stack Overflow

Generate list from JavaScript object

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related