Web Request: GetUserCollectionFromGroup

[janasmuth]

Hello everybody,

I'm struggeling to get the Web Request action to work with the GetUserCollectionFromGroup request  (https://mytenant.sharepoint.com/_vti_bin/usergroup.asmx ) and hope someone of you can give me some advice on this.

I used the RemoveUserCollectionFromGroup request before and it was working fine, but I'm not able to get all users with the other request. Basically I implemented all my steps similar to this example How to Get All the Users From a Specific SharePoint Group Using NINTEX Workflow 

Here is what I did in Nintex for Office 365:

Here are the results:

The group "Managers" has currently 3 members but when I log the collection it looks pretty empty. Regarding to the status code the request was successful.

I might have done something wrong in the Query XML step. Is there any way to see the full XML response that is cut off in the log?

Thanks,

Jan

[Chris_Ben]

Hi Jan,

Can you email the XML to yourself instead of using the logging action (which has a character limit)?  Or if the email fails, write the XML to a multi-line field on a list somewhere.

Cheers,

Chris

[janasmuth]

Thanks for your reply Chris. I tried this already before but the email and also the multi line field remained empty. I will try it again it must be some issue with the data type...

[TomaszPoszytek · Accepted solution]

I agree with Ben - try to send the response body to your email to be sure it does contain what you expect.

Second thing - what "Content Type" in request header are you using? It should be: application/soap+xml; charset=utf-8.

And the last thing - try changing Method from "SOAP 1.2" to "POST".

I would also recommend you to use the following xPath Query when working with the XML:

//*/@LoginName‍

Yours doesn't seem to work for the response body XML as the Name Space differs.

Regards,

Tomasz

[TomaszPoszytek]

I do receive the following XML when testing using postman‌ app:

Verify if you are getting the similar response body for your group.

Regards,

Tomasz

[Admin_Maraicar]

Hi TomaszPoszytek

I have following the same steps and unable to get response.

I am getting the response as attached and Query XML was failing.

I have tried with the Xpath as well

/defaultNS:GetUserCollectionFromGroup/defaultNS:Users/defaultNS:User/@Name
/defaultNS:GetUserCollectionFromGroup/defaultNS:Users/defaultNS:User/@Email
//defaultNS:GetUserCollectionFromGroup/defaultNS:Users/defaultNS:User/@Name
/defaultNS:GetUserCollectionFromGroup/defaultNS:Users/defaultNS:User/@Email
/defaultNS:GetUserCollectionFromGroupResult

[vaibhavk]

@Admin_Maraicar 

please try to use

 //*/@LoginName

This worked for me. The xml collection then needs to be iterated in a foreach. 

Let me know if that works.

[Admin_Maraicar]

HI @vaibhavk 

Did you get XML response as above.
Did you use SOAP 1.2 or SOAP 1.1 or POST

[Admin_Maraicar]

Thanks a lot.

It started working fine now.

Sometime, suddenly getting 403 Forbidden for the same account. Do you have any ideas about it or faced it.

[TomaszPoszytek]

You could as well use this query (to exclude all records from your group that are not a regular users, but for ex. a claim or an ad group):

//*[contains(@LoginName,'@')]/@LoginName‍

but from what I recall when testing xpath in Nintex "Query XML" none from the functions worked, as the xpath syntax is not fully supported. But you can give it a try

Regards,

Tomasz