Angular 6 : how to get specific data from Json array using Angular 6

Question

I have retrieved data from the JSON array in Angular 6 using GET method. I have this JSON data as an example and I want to find employee "TEST4KRWN" in which team(s) is located.

How can I write a JSON-query using angular 6?

My JSON looks like this:

{
    "teams": [
          {
            "EMPLOYEES": [
                "TEST4KRWN",
                "TESTV6A3M"
            ],
            "TEAM_LEAD": "TEST3L671",
            "TEAM_ID": 7,
            "TEAM_NAME": "Quantum Computing"
        },
        {
            "EMPLOYEES": [
                "TESTEK9H4",
                "TEST4KRWN",
                "TESTWIOTA"
            ],
            "TEAM_LEAD": "TESTB2SEA",
            "TEAM_ID": 8,
            "TEAM_NAME": "Language"
        },

        {
            "EMPLOYEES": [
                "TESTWJJ7W"
            ],
            "TEAM_LEAD": "TESTOOARS",
            "TEAM_ID": 10,
            "TEAM_NAME": "General Services"
        },
        {
            "EMPLOYEES": [
                "TEST1S09V",
                "TEST4KRWN"
            ],
            "TEAM_LEAD": "TESTYUK99",
            "TEAM_ID": 11,
            "TEAM_NAME": "Logistik"
        },
        {
            "EMPLOYEES": [
                "TEST7QTWJ",
                "TEST4KRWN",
                "TESTMKT1K"
            ],
            "TEAM_LEAD": "TESTVYTHP",
            "TEAM_ID": 12,
            "TEAM_NAME": "R&D"
        }

    ]
}

Christian Vincenzo Traina · Accepted Answer · 2019-05-15 11:02:28Z

2

You can use find() to do that in one line:

 const selectedEmployee = data.teams.find(
   t => t.EMPLOYEES.find(e => e === 'TEST4KRWN')
 );

edited May 15, 2019 at 11:02

Christian Vincenzo Traina

10.6k4 gold badges45 silver badges79 bronze badges

answered May 15, 2019 at 10:59

lingthe

5991 gold badge6 silver badges14 bronze badges

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

Comments

Padmapriya Vishnuvardhan · Accepted Answer · 2019-05-15 10:30:37Z

0

const selectedTeam = null;
teams.forEach((team) => {
    selectedTeam = team.EMPLOYEES.filter(function (employee, pos) {
        return employee === "TEST4KRWN";
    });
});

Now you could know the team from that you can access any object.

answered May 15, 2019 at 10:30

Padmapriya Vishnuvardhan

2,16616 silver badges18 bronze badges

1 Comment

Christian Vincenzo Traina Over a year ago

You can use some in place of forEach and return selectedTeam. In this way you avoid keep iterating if you have already found the selected team

Amrit · Accepted Answer · 2019-05-15 10:56:27Z

0

Let myjson be the json data of yours :

 let TEAM_NAME_list =[]
    for (let item of myjson.teams){
    if(item.EMPLOYEES.includes('TEST4KRWN')){
    TEAM_NAME_list.push(item.TEAM_NAME)}
    }

in TEAM_NAME_list you will get all team(s) who have employee "TEST4KRWN"

answered May 15, 2019 at 10:56

Amrit

2,1831 gold badge24 silver badges42 bronze badges

Collectives™ on Stack Overflow

Angular 6 : how to get specific data from Json array using Angular 6

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related