Retrieve a record from a collection in Foundry Object Mapping

Volt MX Version: 10
Operating System: Windows

I create one object in Foundry named Players with two fields: Name and score, and a mapping to retrieve the values from a Integration Service.

{“idMatchIntern”:245258,“time”:“Dec 13,2025 10:00:00 AM”,“localId”:493120,“visitId”:493121,“teams”:[{“teamIdIntern”:493120,“shortName”:“CEL”,“players”:[{“actorId”:8571846,“teamId”:83242,“name”:“HAM”,“playerInternTeam”:493120,“dorsal”:“0”,“timePlayed”:25,“inOut”:12,	“teamScore”:51,“oppScore”:40,“data”:{“type”:0,“score”:2,“valoration”:2},{“actorId”:8571847,“teamId”:83242,“name”:“TYS”,“playerInternTeam”:493120,“dorsal”:“2”,“timePlayed”:15,“inOut”:19,	“teamScore”:51,“oppScore”:40,“data”:{“type”:0,“score”:5,“valoration”:4}}]}]}

It has a collection of players and within each element a record called “data” with the field score.

I used a XML Response Mapping with this syntax:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<mapper xmlns="http://www.kony.com/ns/mapper">      
  <map inputpath="response_in" outputpath="response_out">            
    <map inputpath="teams" outputpath="">                  
      <map inputpath="players" outputpath="jugadores">                        
        <set-param inputpath="name" outputpath="Nombre"/>                                          
        <set-param inputpath="data.score" outputpath="Puntos"/>                                          
      </map>            
    </map>      
  </map>
</mapper>

and it’s return the name of the player but not the score. ¿How can I retrieve the score value from data?

Thanks!

@Jordi

Thanks for posting the query in this forum.

We need to analyze how the integration service and Object service is configured hence can you kindly provide the complete screen shots of both Integration service and object services or if possible can you upload the foundry app to this forum post so that we can check it further.