InfoPath Dev

Hi,

I m using IP 2010 Web form for data retrieval and submission. I have a web service that returns me the record for the user i/p ID value. So far my web service returns the data based on a user typed ID value. However when I try to add the data connection(receive) in the IP 2010, it errors out saying  

InfoPath was unable to create a schema from the results of the web Service call. On clicking the Details button, it shows:

The SOAP response indicates that an error occurred:

System.Web.Services.Protocols.SoapException: Server was unable to read request. ---> System.InvalidOperationException: There is an error in XML document (1, 402). ---> System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.Xml.XmlConvert.ToInt32(String s)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read1_GetPEFormDetailsForManila()
   at Microsoft.Xml.Serialization.GeneratedAssembly.ArrayOfObjectSerializer.Deserialize(XmlSerializationReader reader)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   --- End of inner exception stack trace ---
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
   at System.Web.Services.Protocols.SoapServerProtocol.ReadParameters()
   --- End of inner exception stack trace ---
   at System.Web.Services.Protocols.SoapServerProtocol.ReadParameters()
   at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()

My concern is my ID value's data type is  int in SQL table. The data type in IP form is Whole Number(integer). I m not sure why IP is complaining about data type conversion in the above error message. Any suggestions on what /where to look at to rectify this issue?

Here's what my web service returns :

<?xml version="1.0" encoding="utf-8" ?>

 I believe you should ask it in http://community.office365.com forums as well as to provide more details (where have you deployed your webservice, what are authentication methods enabled on that server, , etc.).

Having checked first similar discussions and quite notorious common-knowledge basics on using Sharepoint Online:

•  Error message when you connect an InfoPath form to an Office 365 SharePoint Online web service: "An error occurred while connecting to a Web Service"
  http://support.microsoft.com/kb/2674193?wa=wsignin1.0
  
  
  • "This issue occurs because loopback protection is enabled in the SharePoint Online environment. Loopback protection must be disabled for InfoPath forms to be able to connect to a SharePoint Online web service"
  • "Any time that you make a call to the same server from an InfoPath form, the requests to loop back. This works only when loopback protection is disabled. For security reasons, loopback protection is always enabled in SharePoint Online. This is a known limitation of InfoPath forms in the Office 365 SharePoint Online environment, and there is no workaround for this issue"