Stephen Bubb (Customer) asked a question.
Using the generic REST Account Collector, I am getting a JSON response that contains a key value pair that is a multi-string array. When mapping this response path to a parameter, it only maps the last string in the array.
Example:
"value": [
{
"id": "00000000-1111-2222-3333-444444444444",
"displayName": "Group",
"description": "Description",
"groupTypes": [
"DynamicMembership",
"Unified"
]
},
When mapping response path $.value[*].groupTypes to a parameter, it will only return the last string, in this case "Unified". Does anyone know if it's possible to have the first value in the array mapped to the parameter? I have tried making the response $.value[*].groupTypes[0] but that did not work.
We are running RSA G&L version 8.0.0.188061 P08
I've tried this JSON on v8 P9
{
"value": [
{
"id": "00000000-1111-2222-3333-4444444",
"displayName": "Group1",
"description": "Description1",
"groupTypes": [
"DynamicMembership",
"Unified"
]
},
{
"id": "00000000-1111-2222-3333-555555555",
"displayName": "Group2",
"description": "Description2",
"groupTypes": [
"DynamicMembership",
"Unified"
]
}
]
}
With this config:
Changed the config to $.value[*].groupTypes[1]
Results:
However it seems that there is a problem (or limitation) when the number of records in the array is different per object
Interesting, that must be the limitation I am running into, as our live data looks like your last example above, with the records having a different number of objects in this array.
My goal here was to be able to identify which Entra ID groups were Unified vs Dynamic Unified vs Security within G&L, but with this limitation the best I can do is to identify Unified vs Security.
I will open a ticket with support to see if they can verify if this is a bug or limitation of the REST collector. Thanks for looking into this.