Solved

InfoPath 2010 Repeating Table - Webservice

Posted on 2013-10-28
7
582 Views
Last Modified: 2014-01-15
Hi!

I am retrieving data through a web service into my browser based infopath form.  The connection is good and data is pulling in but not all rows.

How do I get all rows to display in the table?
0
Comment
Question by:Annette Wilson, MSIS
  • 4
  • 3
7 Comments
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
How many rows do you get compared to what you think you should get.
by default you get all rows that match your query. The more common problem is getting all rows when you want less
also some web services have a set count that will limit what is returned.
0
 

Author Comment

by:Annette Wilson, MSIS
Comment Utility
Thank you for responding clayfox.  I only get one row back.  The first row.
0
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
So you go through the receive data connection wizard?

some times there are multiple methods such as read and read multiple.

what kind of web service is it?

is the control a repeating table or section?
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:Annette Wilson, MSIS
Comment Utility
When I go through the receive data connection wizard,  there are no options to retrieve multiple.

It's a SOAP service

I have a repeating table

It looks like only the last row of the data is being displayed.
0
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
Comment Utility
Are you confident that the web service works?

Do you have a way to verify it?

You do not have any formatting on the repeating table that would filter anything?

Do you have query parameters or does it return all values?
0
 

Assisted Solution

by:Annette Wilson, MSIS
Annette Wilson, MSIS earned 0 total points
Comment Utility
I see what the problem is.  My webservice code was only calling for one row.  I will correct this.
0
 

Author Closing Comment

by:Annette Wilson, MSIS
Comment Utility
I saw that through using the main data set that I could only retrieve one row.  When I Use the secondary datasource  and added a repeating table from the secondary datasource, I was able to return all rows.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now