Re: Querying GetUserCollectionFromGroup Web Service With Runtime Parameter

swathip — Sat, 18 Apr 2009 06:08:32 GMT

Hi,

You will get three xsds when you add a data connection. GetUserCollectionFromGroup, GetUserCollectionFromGroup1, GetUserCollectionFromGroup2. Open the GetUserCollectionFromGroup xsd and search for query fields. Replace that element with the following.

<xsd:element name="queryFields">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="GetUserCollectionFromGroup">

<xsd:complexType>

<xsd:sequence>

<xsd:element minOccurs="0" maxOccurs="1" name="groupName" type="xsd:string"></xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

Now open the GetUserCollectionFromGroup1 and search for ‘GetUserCollectionFromGroup' and replace that element with the following.

<s:element name="GetUserCollectionFromGroup">

<s:complexType>

<s:sequence>

<s:element name="Users" minOccurs="0" maxOccurs="1">

<s:complexType>

<s:sequence>

<s:element minOccurs="0" maxOccurs="unbounded" name="User">

<s:complexType>

<s:attribute name="Notes" type="s:string"></s:attribute>

<s:attribute name="Name" type="s:string"></s:attribute>

<s:attribute name="IsSiteAdmin" type="s:string"></s:attribute>

<s:attribute name="Sid" type="s:string"></s:attribute>

<s:attribute name="ID" type="s:string"></s:attribute>

<s:attribute name="LoginName" type="s:string"></s:attribute>

<s:attribute name="Email" type="s:string"></s:attribute>

<s:attribute name="IsDomainGroup" type="s:string"></s:attribute>

</s:complexType>

</s:element>

</s:sequence>

</s:complexType>

</s:element>

</s:sequence>

</s:complexType>

</s:element>

Querying GetUserCollectionFromGroup Web Service With Runtime Parameter

pnewhook — Tue, 14 Apr 2009 19:00:11 GMT

I'm trying to query the GetUserCollectionFromGroup web service to fill a drop down list with users from a specific group. When I connect to the web service I cannot use it in a drop down because the web service doesn't generate a repeating structure. I followed the instructions found here, Which allows me to fill the drop down with a groups members. However, when I edited the XSD files of the data conection it turned the queryFields into user information as well. So now I cannot query by group name. I'm looking for a no code solution, editing XSDs is okay.

I've attached a screenshot of the dataconnection in infopath after editing the XSD

Thanks.

Data Connections

Re: Querying GetUserCollectionFromGroup Web Service With Runtime Parameter

Querying GetUserCollectionFromGroup Web Service With Runtime Parameter