InfoPath Dev

Hi -- I have a relatively large list (9k items) that needs to be a data source for another form library. I need to be able to query that list via a partial match of a text string to a column. I have researched and setting a REST data connection to the list and quering based on substringof works as intended if I leave it as a client form. In a browser form it errors out. Does anyone know of my options here? Thank you, Jason

If this is Office 365, you aren't going to be able to use REST in a browser form, I'm afraid - a lot of the SharePoint web services are blocked from browser forms. Unfortunately - I can't think of a work around. Regular list connections have query fields, but those are only for equivalence, so that doesn't do you any good at all....

Thanks for the quick reply. Any way to query the data connection based on the view?

 An owssvr.dll data connection can have a view parameter - but I don't know if those are supported in Office 365. May be worth a try? But if the idea was to dynamically change the view the data connection would use, since owssvr.dll connections are SOAP, that won't be possible using rules.

Hi, Thanks again. I had tried the owssvr.dll prior and you get the same error as using REST in 365. Last question. I see posts on passing query strings to lists customized in Infopath, is there a method for passing query string values to a form based on a form library? Thank you, Jason

Not without code, I'm afraid.

EDITED TO ADD: Actually, if you put the form in a web part page - I think you can.

https://blogs.msdn.microsoft.com/infopath/2010/06/03/how-to-pass-querystring-data-into-an-infopath-form/