Web Services

Re: Return value from Web Service submit

craig.j.comeau — Tue, 04 Mar 2014 17:59:10 GMT

Hi Patrick How would one go about creating a receive data connection that submits through qrules? Which i have.

Re: Return value from Web Service submit

Patrick Halstead — Thu, 02 Jun 2011 16:59:29 GMT

I'm confused what "this scenario" refers to. If you just need to get back a return value from a Web Service, you can create a Retrieve data connection that submits and that will return results. You can use code or qRules to access those results.

The original poster seemed more interested in submitting repeating data to a Web service. We have a generic Web service (DBXL) that supports this and we pass the XML as a string when we call it. The Web service is smart and parses out the repeating data and maps to SQL based on a user-defined XML-to-SQL mapping (it's data driven). Seems like the original poster needs a similar approach.

Re: Return value from Web Service submit

ajay.sawant@prosares.com — Thu, 02 Jun 2011 12:17:16 GMT

Hi,

Any possibility of getting this scenario working in InfoPath 2010 ?

Thanks

Ajay Sawant

Re: Return value from Web Service submit

MonteMcD — Mon, 16 Feb 2009 22:06:03 GMT

I am running into the same issue. The query params are locked for the receive DC and you have to use a rule action to assign the values (one by one) *and* it doesn't seem to accept repeating values. Is there any way to do both without resorting to code? I need to submit a repeating table (lineitems) and get back a record ID to put back into the form.

Re: Return value from Web Service submit

Greg Collins — Wed, 07 Feb 2007 00:26:09 GMT

The receive DC should provide query parameters as well. Are you seeing a difference in the query parameters between a receive DC and a submit DC to the same data source?

Re: Return value from Web Service submit

tbrentlong — Wed, 31 Jan 2007 20:35:40 GMT

Greg,

Can you elaborate on using the Receive Data Connection? I've created a Receive DC, but don't know how to assign value to the input parameter for the web service (it doesn't let you select the receive service when specifying submit options).

Re: Return value from Web Service submit

Greg Collins — Wed, 17 Jan 2007 17:22:39 GMT

Great! Glad to hear you got it working!

Re: Return value from Web Service submit

jdogan — Wed, 17 Jan 2007 14:38:00 GMT

Thanks Greg,

Before I saw your reply, I ended up adding a web reference to my web service, and then adding custom submit code that invokes the method on the web service directly instead of utilizing a data connection at all.

<Code Snippet>
public void FormEvents_Submit(object sender, SubmitEventArgs e)
{
XPathNavigator nav = MainDataSource.CreateNavigator();
XPathNavigator idNode = nav.SelectSingleNode("/XPath/Node/That/Stores/The/FormId", this.NamespaceManager);
// We need to capture the return value of the submit, so that we can update the FormId.
InfoPathService.IInfoPathForm IPService = new InfoPathService.IInfoPathForm();
XPathNavigator responseNode = nav.SelectSingleNode("/XPath/Node/That/Contains/The/Response", this.NamespaceManager);
Guid FormId = IPService.SubmitInfoPathForm(responseNode.InnerXml);
idNode.SetValue(FormId.ToString());
e.CancelableArgs.Cancel = false;
}
</Code Snippet>

This looks like it does what I need, so I'll run with that for now.
Thanks again!

Jason

Re: Return value from Web Service submit

Greg Collins — Tue, 16 Jan 2007 23:40:19 GMT

You can probably do what you want by using a Receive Data connection rather than a Submit Data connection. Both allow submit, the difference is that the Receive one lets you get data back as a result.

Return value from Web Service submit

jdogan — Mon, 15 Jan 2007 14:59:57 GMT

Hello,

I am wondering if it is possible to handle a web method return value after submitting a form? Basically, I have a web method

Guid Submit(){...}

When submitting a new form, the Guid returned is the new Id in the database, which I would like to capture and store in a form dataField so that if the user clicks the Submit again, it will update the existing database record instead of creating a new record.

I am assuming this requires custom submit code, if its even possible. If anyone has advice, it would be much appreciated!

Jason