Web Service testing with ms infopath 2007 - InfoPath Dev
in

InfoPath Dev

Web Service testing with ms infopath 2007

Last post 08-07-2009 02:25 AM by marcelis.joris. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 08-06-2009 08:09 AM

    Web Service testing with ms infopath 2007

    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

  • 08-06-2009 01:27 PM In reply to

    Re: Web Service testing with ms infopath 2007

    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...

    Patrick Halstead
    Project Manager at Qdabra
  • 08-06-2009 11:37 PM In reply to

    Re: Web Service testing with ms infopath 2007

    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

  • 08-07-2009 12:19 AM In reply to

    Re: Web Service testing with ms infopath 2007

    Hi again,

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

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

    Just go t

    Patrick Halstead
    Project Manager at Qdabra
  • 08-07-2009 02:25 AM In reply to

    Re: Web Service testing with ms infopath 2007

    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.

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.