How to pass repeating field data from infopath to sql data base through web service
-
sábado, 16 de junho de 2012 02:12
Hi,
I have a requirement to send infopath form data to sql data base. I am using custom webservice to map the fields in the infopath form.I am able to send all the fields and repeating section data into sql by following this link.
http://www.bizsupportonline.net/infopath2007/how-to-submit-repeating-table-infopath-web-service.htm
I am not able to send data of repeating field created by using repeating property of the field.
Please provide me links to achieve this.
Thanks
Sireesha.
Todas as Respostas
-
segunda-feira, 18 de junho de 2012 09:13Moderador
-
terça-feira, 26 de junho de 2012 14:26
Hi sireeshab,
Given that when you have a repeating table or section you see the xml data in a format similar to this:
<my:group3>
<my:field6>a</my:field6>
<my:field7>b</my:field7>
<my:field8>c</my:field8>
</my:group3>And with a repeating field you will see the xml look like this:
<my:Field7>big</my:Field7>
<my:Field7>small</my:Field7>
<my:Field7>large</my:Field7>
<my:Field7>tiny</my:Field7>What you may need to do is wrap that repeating field within a group so that its formatted similarly to a repeating table. Next you will have to look at how you are sending that data. Are you sending as field for field or are you sending the entire xml subtree - however this may only pass only the first item. You may have to see what the different options are in the data connection when setting it up to the web service.
Regards, Aaron Suoja - Microsoft Online Community Support
- Marcado como Resposta Emir LiuMicrosoft Contingent Staff, Moderator sexta-feira, 29 de junho de 2012 11:15

