graph user, convert the output from object to array yo loop

[gmeunier]

Hi everyone,

I am calling the AD user list through the HTTP action.

The output is an object.

I parse it to JSON to have it as an array so that I can loop through the results.

Unfortunately, I am not managing to get an array.

That is the original flow before tempting to apply any type of solution.

The HTTP action in which I am calling extension attributes

The Parse JSON action with the schema generated from the prior output

The full schema below

{
    "type": "object",
    "properties": {
        "id": {
            "type": "string"
        },
        "displayName": {
            "type": "string"
        },
        "onPremisesExtensionAttributes": {
            "type": "object",
            "properties": {
                "extensionAttribute1": {
                    "type": "string"
                },
                "extensionAttribute2": {},
                "extensionAttribute3": {},
                "extensionAttribute4": {},
                "extensionAttribute5": {},
                "extensionAttribute6": {},
                "extensionAttribute7": {},
                "extensionAttribute8": {},
                "extensionAttribute9": {},
                "extensionAttribute10": {},
                "extensionAttribute11": {},
                "extensionAttribute12": {},
                "extensionAttribute13": {},
                "extensionAttribute14": {},
                "extensionAttribute15": {}
            }
        }
    }
}

How to transform this to be able to loop on the results ?

Many thanks for your help,

Gerald

[gmeunier · Accepted solution]

I found out

in order to get the value item above :

in the Parse JSON action instead of providing just a sample, provide the full output if the http action to generate the schema

[alrez]

Hi,

Thanks for your follow up post! I am glad that you were able to get this figured out. Hopefully this will prove useful to future communities users in the future who are having similar issues.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.