General

Re: The 1500k "Response Size" for Form Services

alberta — Thu, 19 Apr 2012 16:16:44 GMT

Thanks for the info, i will take a look into the REST web services first, if we could not get around it still, will take a look at Qdabra tools.

I did a very brief test of the RESTful API, quite unfortunate for us is that the lists we are pulling data from are *External Lists*, and it seems that the Restful API are not including those lists.

Any comment on this? thx

Wei

Re: The 1500k "Response Size" for Form Services

Jimmy — Thu, 19 Apr 2012 14:53:30 GMT

Hello again,

You are correct that InfoPath's built-in functions do not support filtering. Since the need to filter is an extremely common requirement for people, Qdabra has come up with some ready-made solutions to ease this pain, speed up your form and get around these limits.

DBXL is web service that resides on the server and allows you to perform filtered queries of SQL Server database and SharePoint list/library data, along with some other hefty features like mapping your XML data out to an SQL Server database.

qRules is managed code that resides in your InfoPath form and provides a whole slew of helpful features, one of them being a command that allows you to perform filtered queries of SharePoint list/library data.

Are you using the 2010 versions of both InfoPath and SharePoint? If so, you may be able to use a REST webservice to do a filtered query of SharePoint lists if you're looking to go completely codeless.

Re: The 1500k "Response Size" for Form Services

alberta — Wed, 18 Apr 2012 18:35:10 GMT

The data could be from sharepoint list or database. Right now we are pulling everything from them as we need to filter them based on User Input at run time.

Based on my search around this site, it seemed we need to have custom code if we cannot get around this 1500k limit, right?

Thx

Re: The 1500k "Response Size" for Form Services

Jimmy — Wed, 18 Apr 2012 11:37:31 GMT

Where is the data being pulled from. Do you need all of the thousands of rows in those data sources, or only a portion of them for any given document?

The 1500k "Response Size" for Form Services

alberta — Tue, 17 Apr 2012 20:21:38 GMT

It seemed to be not enough for our web browser form, we have a couple secondary data connections pulling in thousands of rows of data. I wonder whether other people is having similar problem, and what is the best solution besides increasing the Response Size.

Thanks,

Wei