General

Re: Web Service testing with ms infopath 2007

marcelis.joris — Fri, 07 Aug 2009 09:25:54 GMT

Thanks again for your reply Patrick.

I followed all your steps and when I press 'Preview" I get the following message

'Connection to data source failed' and the buttons 'Work offline', 'Connect' and details

after pressing 'Connect' I receive this error message

'There is a link between infopath and a data source but no data is received. The form is loaded without the requested data'

when I press on 'show details' I get the following error message

'the query can't be executed for the following dataobject : GetAtoms'

'the query can't be executed in infopath'

'Access denied'

but, when I press 'work offline' it seems to be working fine, in my return field I get all the Atoms

Any idea's on how to solve this ?

Is there a way to 'debug' this ?

Thanks again for your help with this.

Re: Web Service testing with ms infopath 2007

Patrick Halstead — Fri, 07 Aug 2009 07:19:44 GMT

Hi again,

Start InfoPath
Design a Form
Blank
Tools->Data Connections
Receive Data -> Web Service
Enter URL for your service
Choose GetAtom -> (fill in sample and default values if they exist) -> Next -> Next -> Close
Click Data Source in TaskPane
Select dropdown where Main shows up and choose GetAtom
Expand the data nodes
Drag nodes over to view
Click Preview

Result: XML is passed back from GetAtom as a string.

Just go t

Re: Web Service testing with ms infopath 2007

marcelis.joris — Fri, 07 Aug 2009 06:37:24 GMT

Hello,

Thanks for your reply.

So, did you wrote that code for it or did you just check that web service ?

Is there a way to test/check the data source ?

If it's not too much to ask, can you describe all the steps you've done, maybe I did something wrong ?

Thanks

Re: Web Service testing with ms infopath 2007

Patrick Halstead — Thu, 06 Aug 2009 20:27:53 GMT

Worked fine for me but that GetAtoms function returns an XML data as a string so you'll need to write code or use qRules to convert it into the main data source. Too bad they didn't just return the correct schema for the WebService - then you could just pull it into the view as structured XML...

Web Service testing with ms infopath 2007

marcelis.joris — Thu, 06 Aug 2009 15:09:14 GMT

Hello,

I'm new to Infopath (2007) and would like to test a web service.

I've found this free webservice http://www.webservicex.net/periodictable.asmx?wsdl to get back the atoms table "GetAtoms".

When I try this I've got the following error "A required data source is not available. Some form elements, such as drop-down lists, may be blank."

Does anybody know how to solve this ?

Thanks for your help.

Regards