Parse JSON issue

[Nicolas_1999]

Hello,

Im trying to make a flow which uses data from MS Graph.

Herefor I am using Parse JSON to devide the data but it won't list the field skuId to the sharepoint list.

This is the only field it won't show any idea why?

{
    "type": "object",
    "properties": {
        "body": {
            "type": "object",
            "properties": {
                "value": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "givenName": {
                                "type": "string"
                            },
                            "surname": {
                                "type": "string"
                            },
                            "jobTitle": {
                                "type": "string"
                            },
                            "country": {
                                "type": "string"
                            },
                            "mail": {
                                "type": "string"
                            },
                            "companyName": {
                                "type": "string"
                            },
                            "department": {
                                "type": "string"
                            },
                            "mobilePhone": {},
                            "postalCode": {
                                "type": "string"
                            },
                            "city": {
                                "type": "string"
                            },
                            "streetAddress": {
                                "type": "string"
                            },
                            "usageLocation": {
                                "type": "string"
                            },
                            "lastPasswordChangeDateTime": {
                                "type": "string"
                            },
                            "id": {
                                "type": "string"
                            },
                            "assignedLicenses": {
                                "type": "object",
                                "properties": {
                                    "disabledPlans": {
                                        "type": "string"
                                    },
                                    "skuId": {
                                        "type": "string"
                                    }
                                },
                                "required": [
                                    "skuId"
                                ]
                            },
                            "signInActivity": {
                                "type": "object",
                                "properties": {
                                    "lastSignInDateTime": {
                                        "type": "string"
                                    },
                                    "lastSignInRequestId": {
                                        "type": "string"
                                    },
                                    "lastNonInteractiveSignInDateTime": {
                                        "type": "string"
                                    },
                                    "lastNonInteractiveSignInRequestId": {
                                        "type": "string"
                                    }
                                }
                            }
                        },
                        "required": [
                            "id"
                        ]
                    }
                }
            }
        }
    }
}

[abm]

Hi @Nicolas_1999 

Could you post a screenshot of your flow? Is the below skuId you talking about? Check the default view of the list where you can see skuId. If not go to List Settings > Select the view > Edit View and add that skuId.

assignedLicenses": {
"type": "object",
"properties": {
"disabledPlans": {
"type": "string"
},
"skuId": {
"type": "string"
}
},
"required": [
"skuId"
]
}

Thanks

[Nicolas_1999]

Hi @abm ,

Here's a screenshot of the create item im referring to.

Like you said it uses the following.

assignedLicenses": {
"type": "object",
"properties": {
"disabledPlans": {
"type": "string"
},
"skuId": {
"type": "string"
}
},
"required": [
"skuId"
]
}

[abm]

Hi @Nicolas_1999 

Thanks for the screenshot. What is the SKUID column data type?

Thanks

[Nicolas_1999]

Hi @abm, 

When I generate a sample from Parse JSON it says its a Array.

Its a bunch of codes that represent licences in office for each user.

[Nicolas_1999]

bump 🙂

[Nicolas_1999]

Hi @abm,

Would you have an idea of what the issue might be?

[abm · Accepted solution]

Hi @Nicolas_1999 

Thanks for the screenshare. Following are the steps to resolve the issue.

1. Generate the Parse JSON schema and removed the mandatory elements tag.

2. Extend the schema to incorporate null values eg: [string, null]

3. Generate another schema for sku array values.

4. Append the sku values with comma and added appropriate IF condition to avoid commas for single sku values.

Hope it make sense.

Thanks

[Nicolas_1999]

Hi @abm,

Worked like a charm, thanks alot for the assistance.