@WillPage Really appreciate your solution, using I can get some first-level details/values
But what if I want to get second-level values from the JSON.
Assume I have the below schema to get "Title" and Name from the Permission JSON.
{
"type": "object",
"properties": {
"d": {
"type": "object",
"properties": {
"results": {
"type": "array",
"items": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"uri": {
"type": "string"
},
"type": {
"type": "string"
}
}
},
"Member": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"uri": {
"type": "string"
},
"type": {
"type": "string"
}
}
},
"Alerts": {
"type": "object",
"properties": {
"__deferred": {
"type": "object",
"properties": {
"uri": {
"type": "string"
}
}
}
}
},
"Groups": {
"type": "object",
"properties": {
"__deferred": {
"type": "object",
"properties": {
"uri": {
"type": "string"
}
}
}
}
},
"Id": {
"type": "integer"
},
"IsHiddenInUI": {
"type": "boolean"
},
"LoginName": {
"type": "string"
},
"Title": {
"type": "string"
},
"PrincipalType": {
"type": "integer"
},
"Email": {
"type": "string"
},
"Expiration": {
"type": "string"
},
"IsEmailAuthenticationGuestUser": {
"type": "boolean"
},
"IsShareByEmailGuestUser": {
"type": "boolean"
},
"IsSiteAdmin": {
"type": "boolean"
},
"UserId": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"NameId": {
"type": "string"
},
"NameIdIssuer": {
"type": "string"
}
}
},
"UserPrincipalName": {
"type": "string"
}
}
},
"RoleDefinitionBindings": {
"type": "object",
"properties": {
"results": {
"type": "array",
"items": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"uri": {
"type": "string"
},
"type": {
"type": "string"
}
}
},
"BasePermissions": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"High": {
"type": "string"
},
"Low": {
"type": "string"
}
}
},
"Description": {
"type": "string"
},
"Hidden": {
"type": "boolean"
},
"Id": {
"type": "integer"
},
"Name": {
"type": "string"
},
"Order": {
"type": "integer"
},
"RoleTypeKind": {
"type": "integer"
}
},
"required": [
"__metadata",
"BasePermissions",
"Description",
"Hidden",
"Id",
"Name",
"Order",
"RoleTypeKind"
]
}
}
}
},
"PrincipalId": {
"type": "integer"
}
},
"required": [
"__metadata",
"Member",
"RoleDefinitionBindings",
"PrincipalId"
]
}
}
}
}
}
}
from the above code, i can able to get Title property values
if(equals(item()?['Member']?['Title'],null), '-', item()?['Member']?['Title'])
but we would like to get Name property which is under RoleDefinitionBindings
if(equals(item()?['RoleDefinitionBindings']?['Name'],null), '-', item()?['RoleDefinitionBindings']?['Name'])
if(equals(item()?['Member']['RoleDefinitionBindings']?['Name'],null), '-', item()?['Member']['RoleDefinitionBindings']?['Name'])
if(equals(item()?['RoleDefinitionBindings']['results']?['Name'],null), '-', item()?['RoleDefinitionBindings']['results']?['Name'])
if(equals(item()?['d']['results']['RoleDefinitionBindings']['results']?['Name'],null), '-', item()?['d']['results']['RoleDefinitionBindings']['results']?['Name'])
but no luck
Can you assist me how can I get Name property value from RoleDefinitionBindings