Worklflow : json path expression

[baoussounda (Ousmane N'DIAYE)]

with the following input :

 {
                "accountId": "test.admin",
                "accountOperation": "Create",
                "attributeRequests": [
                    {
                        "attributeName": "groups",
                        "attributeValue": "[111, 110]",
                        "operation": "Add"
                    }
                ],
                "provisioningResult": "Manual Task Created",
                "provisioningTarget": "Manual",
                "source": {
                    "id": "test5d68cb437eb86481c77e63751btest",
                    "name": "Profil _Metest",
                    "type": "SOURCE"
                },
                "ticketId": null
}

i want to retrieve attributeValue when attributeName == groups

I’m able to do that with filter :

$.attributeRequests[?(@.attributeName=='groups')].attributeValue

But i have the folling output :

I want to retrieve it in following format : [111, 110]

Is anyone have a solution for do that ?

[amishra97 (Abhinav Mishra)]

Hi @baoussounda ,

You’re using the correct JOSN path expression, which will return the desired value.

$.attributeRequests[?(@.attributeName == 'groups')].attributeValue

[baoussounda (Ousmane N'DIAYE)]

@amishra97 but i have following value :

And i want this format : [111, 110]

[colin_mckibben]

JSONpath cannot unpack that array since it is technically a string. If your attribute value looked like this (i.e. without the double quotes)

"attributeValue": [111, 110]

Then you could write this JSONpath expression

$.attributeRequests[?(@.attributeName=='groups')].attributeValue[*]

Which would produce the result you are looking for.

[baoussounda (Ousmane N'DIAYE)]

@colin_mckibben

$.attributeRequests[?(@.attributeName==‘groups’)].attributeValue[*]

Hi @colin_mckibben,

This expression : $.attributeRequests[?(@.attributeName==‘groups’)].attributeValue[*]

return an empty array as you can see here :

I think it’s due attributeValue that was string.

[colin_mckibben]

Yes that’s correct. That jsonpath express would only work if the attribute value was an array instead of a string. Ultimately, you can’t unpack that string the way you want with jsonpath.

[baoussounda (Ousmane N'DIAYE)]

I will see if i can found another solution.

I have a worfklow that use “Provisioning completed” trigger for specific delimited file and create automatically account in that source after manual action completion.

In my http request action i do post on /v3/accounts :

{
    "attributes": {
        "groups": "{{$.loop.loopInput.attributeRequests[?(@.attributeName=='groups')].attributeValue}}",
        "id": "{{$.loop.context.attributes.uid}}",
        "sourceId": "{{$.loop.loopInput.source.id}}"
    }
}

i’m able to create account on that source , but a multivalued entitlement attribute groups is populated like this :

But i can see that entitlement is correctly assigned, that means a ‘groups’ is correctly populated ?

[baoussounda (Ousmane N'DIAYE)]

With postman, i have the following value in groups

But with this two cases, entitlements are assigned correctly.

[baoussounda (Ousmane N'DIAYE)]

This populated my delemited file source entitlement with bad data :

[baoussounda (Ousmane N'DIAYE)]

Bonjour,

I resolve this problem by combine two workflows.

In my second workflow use define varaible for replace [ by empty and in my http call for create or update account i add [ and ].

With “[122,142]” ==> define variable output is : 122,142

and i call api with : [ 122,142]

Best regards