So i have created a custom connection that access the sharepoint rest api to get sharepoint user group information.
The results produce a nested collection. I cannot figure out how to access the data in the nested collection either in a table or looping through the items to concatenate a column like LoginName.
Thank you...
Button:ClearCollect(userGroupData,OpenAPIProgram.GetuserGroups("924","spar","application/json; odata=nometadata"))
json returned:
{
"value": [
{
"Id": 3,
"IsHiddenInUI": false,
"LoginName": "SharePoint Assistance Request Owners",
"Title": "SharePoint Assistance Request Owners",
"PrincipalType": 8,
"AllowMembersEditMembership": false,
"AllowRequestToJoinLeave": false,
"AutoAcceptRequestToJoinLeave": false,
"Description": "",
"OnlyAllowMembersViewMembership": true,
"OwnerTitle": "Nickerson, Samuel",
"RequestToJoinLeaveEmailSetting": ""
},
{
"Id": 5,
"IsHiddenInUI": false,
"LoginName": "SharePoint Assistance Request Visitors",
"Title": "SharePoint Assistance Request Visitors",
"PrincipalType": 8,
"AllowMembersEditMembership": false,
"AllowRequestToJoinLeave": false,
"AutoAcceptRequestToJoinLeave": false,
"Description": "",
"OnlyAllowMembersViewMembership": true,
"OwnerTitle": "SharePoint Assistance Request Owners",
"RequestToJoinLeaveEmailSetting": null
}
]
}
Collection CreatedRoot of collection
sub Collection
You could try to open a support ticket here:
hi @Anonymous I'm sorry to hear about this issue but thank you for posting it in the forum.
Please take a look at the following thread. It is not your exact scenario, but may include some helpful workarounds. If that does not help, please consider submitting a ticket using the link supplied above.
@Anonymous