API results for IP addresses (CMDB Feed)

Customizations
1

I am trying to gather a bunch of data (hardware, custom properties, IP) from machines to help feed the CMDB with more data. So we are taking some of the properties from BigFix and trying to feed them over to service now. A process on the service now side will take the results and put the data with the specific assets.

Here is the API query I have been testing with and it provides results but if a machine has multiple IP address it comes as multiple results.

https://server:52311/api/query?relevance=(values of results (it, bes property “Computer Name”), values of result (it, bes properties “IP Address”) ) of bes computers

<Result>
			
<Tuple>

<Answer type="string">Machine1</Answer>
			
<Answer type="string">10.1.1.1</Answer>
			
</Tuple>
<Tuple>
				
<Answer type="string">Machine2</Answer>
				
<Answer type="string">10.1.2.1</Answer>
			
</Tuple>
			
<Tuple>
				
<Answer type="string">Machine2</Answer>
				
<Answer type="string">10.1.2.2</Answer>
			
</Tuple>

What I am looking for is all results for on a single line similar to below, not sure if its possible or if I need to “offload” this work to the process ingesting the data in Service Now.

<Tuple>
				
<Answer type="string">Machine2</Answer>
			
   <Answer type="string">10.1.2.1 10.1.2.2</Answer>
    			
    </Tuple>
2

Ugh my phone won’t lwt me copy/paste from a forum post.

Try
concatenation " " of values of results (it,
For the ip address property