Microsoft.SharePoint.SoapServer.SoapServerException on SharePoint 2010 InfoPath

Question

I'm trying to modify my list InfoPath form to connect to a data of a SharePoint Web Service Lists.GetListItems

On the part where I'll specify the parameters, I get the following error:

Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Root element is missing.

I think my parameters are correct since I got the IDs from SharePoint Manager. What could be causing this error? Thanks

Answer 1

The quotes from the article InfoPath: Use SharePoint Web Services :

• "Why won't InfoPath work with SharePoint Web Services? It comes down to the fact that InfoPath doesn't recognize that some web services, such as Lists.asmx's GetListItems requires strings (which InfoPath handles just fine) and XmlNodes (which InfoPath can't seem to figure out)"

• "The solution? Create a Proxy Web Service that takes in strings representing the Xml code and create XmlNodes from them"

  Read more there...

Update:
Don't kill the messenger...

The answer of Office365 support in discussion Has anyone succeeded using webservice in InfoPath on office 365? is:

• The root cause of this problem is that "Business Data Connectivity Service" feature is required when trying to get data using web service in InfoPath. However, currently, for security purpose, the Business Data Connectivity Service is not part of the Office 365 SharePoint Online offering. You can find the available features in SharePoint Service Description, which can be found at following link:

  Office 365 for Enterprise Service Descriptions
  http://www.microsoft.com/download/en/details.aspx?id=13602

  For a workaround, you may refer to Sky’s suggestion to build an external webservice. If you have any concern about this future, I suggest you submitting a feedback at
  http://mymfe.microsoft.com/Microsoft%20Online%20Services/Feedback.aspx?formID=210