# JSONPath for list in attribute?

**URL:** <https://community.sailpoint.com/discuss/t/jsonpath-for-list-in-attribute/36857>\
**Category:** Implement & Extend\
**Tags:** identityiq, web-services, identityiq-8.4\
**Created:** [October 1, 2025, 9:27pm UTC](https://community.sailpoint.com/discuss/t/jsonpath-for-list-in-attribute/36857 "2025-10-01T21:27:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefan\_kristensen](https://avatars.discourse-cdn.com/v4/letter/s/3ec8ea/32.png) [@stefan\_kristensen](https://community.sailpoint.com/discuss/u/stefan_kristensen)\
**Post date:** [October 1, 2025, 9:27pm UTC](https://community.sailpoint.com/discuss/t/jsonpath-for-list-in-attribute/36857/1 "2025-10-01T21:27:53Z")

</div>

Hello Sailors

A web service is returning this data

```markup
{
    "Entitlements": [
        {
            "EntitlementID": "001",
            "DisplayName": "727.21.0.15_n1",
        },
        {
            "EntitlementID": "002",
            "DisplayName": "727.21.0.18_n1",
        },
        {
            "EntitlementID": "003",
            "DisplayName": "727.21.0.47b_n1",
        }
    ]
}

```

If I in my Connector Operations for Group Aggregations sets DisplayName to Entitlements[\*].DisplayName, I only get one entitlement with all the DisplayNames as value.

I can set rootPath in xml to Entitlement and then set DisplayName to DisplayName, and then I get all the correct entitlements.

Is this how it is supposed to be, or am I just doing something wrong in my mapping?

I know that Entitlements[\*] returns a list, so I understand why I only get one entitlement, but how would I solve this without rootPath?

Best regards  
Stefan

---

<div class="post-metadata">

**Author:** ![cinilsunny](https://sea3.discourse-cdn.com/sailpoint2/discuss/user_avatar/community.sailpoint.com/cinilsunny/32/17819_2.png) [@cinilsunny](https://community.sailpoint.com/discuss/u/cinilsunny)\
**Post date:** [October 2, 2025, 7:34am UTC](https://community.sailpoint.com/discuss/t/jsonpath-for-list-in-attribute/36857/2 "2025-10-02T07:34:17Z")

</div>

Yes, set root path to&nbsp;Entitlement&nbsp;. That is the correct way.

BTW, input is in incorrect json format. There is an additional ,

test it in :&nbsp;[Json Path Evaluator | SailPoint Developer Community](https://developer.sailpoint.com/tools/json-path-evaluator/)

Correct Input:  
{  
“Entitlements”: [  
{  
“EntitlementID”: “001”,  
“DisplayName”: “727.21.0.15\_n1”  
},  
{  
“EntitlementID”: “002”,  
“DisplayName”: “727.21.0.18\_n1”  
},  
{  
“EntitlementID”: “003”,  
“DisplayName”: “727.21.0.47b\_n1”  
}  
]  
}

JSON query:&nbsp;$.Entitlements[\*].DisplayName

---

<div class="post-metadata">

**Author:** ![stefan\_kristensen](https://avatars.discourse-cdn.com/v4/letter/s/3ec8ea/32.png) [@stefan\_kristensen](https://community.sailpoint.com/discuss/u/stefan_kristensen)\
**Post date:** [October 2, 2025, 9:53am UTC](https://community.sailpoint.com/discuss/t/jsonpath-for-list-in-attribute/36857/3 "2025-10-02T09:53:15Z")

</div>

Thank you, I was tired and stressed and did not see the Root Path field right in front of me, hence my question about the xml.

The JSON has been anonymized, so that is a copy paste error on my part.

Thank you again for answer, it is all working as expected now 🙂

Best regards  
Stefan