How to get all values of a key from objects in a list?

[jfpelletier]

Hello all,

I'm a bit blocked at the moment, hopefully someone can help me again... 🙂

This time I have simple objects stored in an array that looks like this:

[
	{
		"language": "German",
		"id": "43251-1-2"
	},
	{
		"language": "French (Europe)",
		"id": "43251-1-3"
	},
	{
		"language": "Italian",
		"id": "43251-1-4"
	}
]

From that list, I need to extract the values of the "language" keys and put them in a list like this:

["German", "French (Europe)","Italian"]

I suspect that I need to use the .reduce function on the array first, then get the value of the "language" keys, but all my attempts failed... I must say that I'm not very familiar with the .reduce function, I'm just hoping that I was in the right direction... And it's probably much simpler than I think it is...

Thanks in advance for your help! 🙂

JF

[jfpelletier]

Hello @tbranco,

Thanks a lot, that's awesome! I'll share this with my team so that we can all learn.

Just one thing however... The reduce() method seems to work, but it's also returning an error message:

Is this just a typo, or we can safely ignore the message?

Kind regards,

JF

[tbranco]

Hi JF,

Yes you can safely ignore this message.

Toni

[jfpelletier]

Thanks a lot again, Toni!

JF

[jfpelletier]

Thanks also, @koryknick

I tried using jsonPath, but I was getting nowhere... The solution using map is very simple and clear, I'll continue using it, but thanks a lot for your suggestion too! 🙂

Kind regards,

JF

[koryknick]

Here is a short video showing how I proposed using JSONPath.