cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gmeunier
Frequent Visitor

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

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

gmeunier_0-1615814907632.png

 

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

gmeunier_1-1615814985338.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
gmeunier
Frequent Visitor

I found out

 

gmeunier_0-1615816171931.png

 

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

 

View solution in original post

2 REPLIES 2
gmeunier
Frequent Visitor

I found out

 

gmeunier_0-1615816171931.png

 

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

 

View solution in original post

alrez
Community Support
Community Support

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.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,059)