Cannot read nested information from FOLocation, addressNavDEFLT object, using SailPoint ISC and SuccessFactors VA-Based connector

[othornewill (Oliver Thornewill von Essen)]

Hello,

I am trying to read the zipCode field of a location using the FOLocation foundation object.

This is an example of the FOLocation Data using Postman to query the API directly:

{
    "d": {
        "results": [
            {
                "__metadata": {
                    "uri": "https://<API-Server>/odata/v2/public/FOLocation(externalCode='KO_SEO',startDate=datetime'1990-01-01T00:00:00')"
				},
                "externalCode": "KO_SEO",
                "createdBy": "admin_name",
                "addressNavDEFLT": {
                    "__metadata": {
                        "uri": "https://<API-Server>/odata/v2/public/FOCorporateAddressDEFLT(314M)",
                        "type": "SFOData.FOCorporateAddressDEFLT"
                    },
                    "address1": "#803, 8th FL., PAN-PACIFIC B/D, 197-21",
                    "address2": "Guro-dong, Guro-gu",
                    "city": "Seoul",
                    "zipCode": "152-050"
                }
			}
			
		]
	}
}

In ISC I have the following query under Additional Attribute Mapping For Label:

• Schema Attribute: zipCode
• Data Source Path: fo_FOLocation?$format=json&$select=externalCode,addressNavDEFLT

Using the following SailPoint Documentation: Advanced Settings

It seems, that the zipCode attribute is nested under addressNavDEFLT and I am not able to read it. I also tried other combinations such as:

• fo_FOLocation?$format=json&$select=externalCode,addressNavDEFLT["zipCode"]
• fo_FOLocation?$format=json&$select=externalCode,addressNavDEFLT.zipCode
• fo_FOLocation?$format=json&$select=externalCode,addressNavDEFLT/zipCode
• fo_FOLocation?$format=json&$expand=addressNavDEFLT&$select=externalCode,addressNavDEFLT/zipCode

Everything has been without success.

I am able to read the createdBy attribute, but I must read the values inside addressNavDEFLT.

Do you know what I am doing wrong? Thank you in advance and best wishes,
Oliver