Web Services

Re: Email Web Service Works in InfoPath 2007 but Doesn't Work on MOSS 2007

IPSeeker — Tue, 26 May 2009 23:02:37 GMT

Thank you Samir. I was able to convert my Web Service connection to a udcx file. However, I still get an error, (401) Unauthorized, when I submit the form. This brings me back to my post http://www.infopathdev.com/forums/t/11981.aspx.

Re: Email Web Service Works in InfoPath 2007 but Doesn't Work on MOSS 2007

Samir Farid — Tue, 26 May 2009 18:45:43 GMT

Hi IPSeeker,

The easiest way to create an udcx file is to let InfoPath do it for you. This article explains the process of creating an udcx file:

http://msdn.microsoft.com/en-us/library/ms772101.aspx

After following the article, there will be an udcx file in the Data Connection Library. If you download a copy of that file and open it. You will find all the necessary information like the <udc:SoapAction>.

Re: Email Web Service Works in InfoPath 2007 but Doesn't Work on MOSS 2007

IPSeeker — Tue, 26 May 2009 16:47:49 GMT

How do you create a udc file? How do you determine the <udc:SoapAction> element?

Re: Email Web Service Works in InfoPath 2007 but Doesn't Work on MOSS 2007

Samir Farid — Tue, 26 May 2009 10:15:32 GMT

Hi sschempp,

I have removed all unnecessary stuff from the udcx, for you it should look like this:

<?xml version="1.0" ?>
<?MicrosoftWindowsSharePointServices ContentTypeID="0x010100B4CBD48E029A4ad8B62CB0E41868F2B0"?>
<udc:DataSource MajorVersion="2" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">
     <udc:Name>SubmitForm</udc:Name>
     <udc:Description>This is the SubmitForm Webservice</udc:Description>
     <udc:Type MajorVersion="2" MinorVersion="0" Type="WebService" />
     <udc:ConnectionInfo Purpose="ReadOnly" AltDataSource="">
            <udc:WsdlUrl>http://az01-itmoss/_vti_bin/userprofileservice.asmx?wsdl</udc:WsdlUrl>
            <udc:SelectCommand>
                   <udc:ServiceUrl UseFormsServiceProxy="false">http://az01-itmoss/_vti_bin/userprofileservice.asmx</udc:ServiceUrl>
                   <udc:SoapAction>http://microsoft.com/webservices/SharePointPortalServer/UserProfileService/GetUserProfileByName</udc:SoapAction>
            </udc:SelectCommand>
            <udc:UpdateCommand />
     </udc:ConnectionInfo>
</udc:DataSource>

Re: Email Web Service Works in InfoPath 2007 but Doesn't Work on MOSS 2007

sschempp — Fri, 15 May 2009 19:17:31 GMT

Patrick, I have been struggling with this and need to know if anyone has been successful -- any ideas?

<?MicrosoftWindowsSharePointServices ContentTypeID="0x010100B4CBD48E029A4ad8B62CB0E41868F2B0"?>
<udc:DataSource MajorVersion="2" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">
<udc:Name>User Info</udc:Name>
<udc:Description>Format: UDC V2; Connection Type: WebService; Purpose: ReadOnly; Generated by Microsoft Office InfoPath 2007 on 2009-05-06 at 13:19:30 by NPLCC\sschempp.</udc:Description>
<udc:Type MajorVersion="2" MinorVersion="0" Type="WebService">
<udc:SubType MajorVersion="0" MinorVersion="0" Type="" />
</udc:Type>
<udc:ConnectionInfo Purpose="ReadWrite" AltDataSource="">
<udc:WsdlUrl>http://az01-itmoss/_vti_bin/userprofileservice.asmx?wsdl</udc:WsdlUrl>
<udc:SelectCommand>
<udc:ListId />
<udc:WebUrl />
<udc:ConnectionString />
<udc:ServiceUrl UseFormsServiceProxy="false">http://az01-itmoss/_vti_bin/userprofileservice.asmx</udc:ServiceUrl>
<udc:SoapAction>http://microsoft.com/webservices/SharePointPortalServer/UserProfileService/GetUserProfileByName</udc:SoapAction>
<udc:Query />
</udc:SelectCommand>
<udc:UpdateCommand>
<udc:ServiceUrl UseFormsServiceProxy="true" />
<udc:SoapAction />
<udc:Submit />
<udc:FileName>Specify a filename or formula</udc:FileName>
<udc:FolderName AllowOverwrite="" />
</udc:UpdateCommand>
<udc:Authentication><udc:SSO AppId='MyNPLSSO' CredentialType='NTLM' /></udc:Authentication>
</udc:ConnectionInfo>
</udc:DataSource>

Re: Email Web Service Works in InfoPath 2007 but Doesn't Work on MOSS 2007

Patrick Halstead — Mon, 07 Jan 2008 18:27:11 GMT

Browser forms do not need to be full trust to submit to a Web service. However, you will need to conver the data connection to a UDC one.

Here's an example of a UDCx that will submit to our Database Accelerator Web Service:

<?xml version="1.0" ?>

<?MicrosoftWindowsSharePointServices ContentTypeID="0x010100B4CBD48E029A4ad8B62CB0E41868F2B0"?>

<?mso-infoPathSolution PIVersion="1.0.0.0" name="urn:schemas-microsoft-com:office:infopath:UDCEditor:http---schemas-microsoft-com-office-infopath-2006-udc" solutionVersion="1.0.0.10" language="en-us" ?>

- <udc:DataSource MajorVersion="2" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">

<udc:Name>SubmitForm</udc:Name>

<udc:Description>Format: UDC V2; Connection Type: WebService; Purpose: WriteOnly; Generated by Microsoft Office InfoPath 2007 on 2007-01-31 at 21:54:37 by AUTONOMYSYSTEMS\pathal.</udc:Description>

- <udc:Type MajorVersion="2" MinorVersion="0" Type="WebService">

<udc:SubType MajorVersion="0" MinorVersion="0" Type="" />

</udc:Type>

- <udc:ConnectionInfo Purpose="WriteOnly" AltDataSource="">

<udc:WsdlUrl>http://formsboard.com:30794/dbxl/dbxldocumentserviceex.asmx?WSDL</udc:WsdlUrl>

- <udc:SelectCommand>

<udc:ListId />

<udc:WebUrl />

<udc:ConnectionString />

<udc:ServiceUrl UseFormsServiceProxy="true" />

<udc:SoapAction />

<udc:Query />

</udc:SelectCommand>

- <udc:UpdateCommand>

<udc:ServiceUrl UseFormsServiceProxy="true">http://formsboard.com:30794/dbxl/dbxldocumentserviceex.asmx</udc:ServiceUrl>

<udc:SoapAction>http://qdabra.com/webservices/SubmitDocument</udc:SoapAction>

<udc:Submit />

<udc:FileName>Specify a filename or formula</udc:FileName>

<udc:FolderName AllowOverwrite="" />

</udc:UpdateCommand>

- <!--

udc:Authentication><udc:SSO AppId='' CredentialType='' /></udc:Authentication

--> f(clean);

</udc:ConnectionInfo>

</udc:DataSource>

Re: Email Web Service Works in InfoPath 2007 but Doesn't Work on MOSS 2007

Matt Faus — Mon, 07 Jan 2008 16:17:40 GMT

Hi Seafox and welcome to the forums!

I thought I had read before that you could not submit to web services from a browser-enabled form, but maybe I am wrong. I found the following blog post that shows people doing this, but the form was set as full trust, maybe that has something to do with it:

http://weblog.vb-tech.com/nick/archive/2007/01/17/2100.aspx

Email Web Service Works in InfoPath 2007 but Doesn't Work on MOSS 2007

Seafox — Thu, 29 Nov 2007 20:52:59 GMT

We configured the web service. We tested it and submitted an email successfully. We created the submit to web service data connection in InfoPath 2007 and entered the URL for the web service. InfoPath found the Sendmail operation from the web service. We added the appropriate string fields for the email web service and then published the form to MOSS 2007 as a browser based form. When we submit the form we get an error from MOSS with no details. When we check the log for the webs service it shows that MOSS never called it. When we run the form native in InfoPath it submits without error and the email gets sent. Is there anything we need to do to configure MOSS to call the web service?