ISE 2.7(p4) API request get sxpconnection don't return IpAddress field

[aserov]

Hello!

The main goal is to export all our sxp connections (some hundreds) for importing them to another deployment by csv.

But GUI do not allow to do it. We decided to get all connections by API, but there is a problem too. The API do not return IP addresses of peers.

Could you please advise why ISE 2.7 do not return IpAddress field in the  get request ?  https://developer.cisco.com/docs/identity-services-engine/2.6/#!sxp-connections/get-by-id

According documentation it should, but it don't (

the response is looks like

{'id': 'xxxxxxx',
 'sxpPeer': 'xxxxxx', 
 'sxpVpn': 'default', 
 'sxpNode': 'xxxxxx', 
 'sxpMode': 'LISTENER', 
 'sxpVersion': 'VERSION_4', 
 'enabled': True, 
 'link': {'rel': 'self', 
          'href': 'https://xxxxxx:9060/ers/config/sxpconnections/xxxxxx', 
          'type': 'application/json'}
}

Even an sxpPeer do not correspond to NAD names, it is just SXP connection description

[Mike.Cifelli · Accepted solution]

I just ran some tests using curl against a 2.7p5 cluster and I noticed the same discrepancies.  Could possibly be a document bug.  I would work with TAC to get their input.  I did notice that when running queries against sxp local bindings API you can get the ip address by id, not exactly what you are looking for, but just as an FYSA.

curl -k --include --header 'Content-Type:application/json' --header 'Accept: application/json' --user xx:xx -request GET https://x.x.x.x:9060/ers/config/sxpconnections/fcxxxxxx-3f68xxxx24f04

{
"ERSSxpLocalBindings" : {
"id" : "fcxxxxxx-3f68xxxx24f04",
"ipAddressOrHost" : "x.x.3.2/32",
"sxpVpn" : "legacy-eps",
"sgt" : "ACAS_Service (13/000D)",
"link" : {
"rel" : "self",
"href" : "https://x.x.x.x:9060/ers/config/sxplocalbindings/fcxxxxxx-3f68xxxx24f04",
"type" : "application/json"
}
}