Grouping values by category with results from two Rest APIs

Hello,

I am a new EazyBI user and am having a hard time consolidating information from two rest apis and displaying it in a report.

The case is as follows:

I have an api that returns JSON with team members.
In this api I have the idmember and idteam values with member details.

In a second api I have the return in JSON but this time with idteam and team details.

I need to display a list of teams with the total members of each team.

Can anyone help me?

I’ve tried a lot and read a lot of the documentation but to no avail.

Thanks