'.' value in Attribute name used for mapping during Account Aggreation causing empty results

Hi All,

Hope everyone are doing great.

I’m working on extracting attribute values from a webservice source during account aggregation. I’m having issue extracting info from attribute with name as “urn:ietf:params:scim:schemas:extension:enterprise:2.0:User” in response. I’m thinking it’s because of the ‘.’ value in the name. Is there any way I can extract info from that dictionary without using rules.

I tried using the SCIM2.0 out of box connector but that’s throwing error (> ConnectorException: org.json.JSONException: A JSONObject text must begin with ‘{’ at 1 [character 2 line 1]) and it’s not working for me.

Below is the response format I’m receiving from that source.

Any suggestions would be really helpful.

Thanks in advance.

{
    "schemas": [
        "urn:ietf:params:scim:api:messages:2.0:ListResponse"
    ],
    "totalResults": 1,
    "Resources": [
        {
            "schemas": [
                "urn:ietf:params:scim:schemas:core:2.0:User",
                "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User"
            ],
            "id": "adfadfgdsg",
            "externalId": "sdfasdf",
            "addresses": [
                {
                    "locality": "asdfasd",
                    "region": "ds",
                    "postalCode": "4353434",
                    "country": "sd",
                    "type": "work"
                }
            ],
            "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User": {
                "value1": "235435",
                "value2": "dfsdf",
                "value3": "sdfsdfs",
                "value4": "sdfsdf",
                "value5": "sdfsdf",
                "value6": "sdfsdf",
                "value7": "businessArea",
                "location": {
                    "name": "personnelSubArea",
                    "address": {
                        "streetAddress": "sdfs",
                        "locality": "sdf",
                        "region": "sd",
                        "postalCode": "23423",
                        "country": "df",
                        "type": "work"
                    }
                }
            }
        }
    ],
    "startIndex": 0,
    "itemsPerPage": 20
}

$.Resources[0][urn:ietf:params:scim:schemas:extension:enterprise:2.0:User].location.name

1 Like