Web Services

Re: REST query works in IE, but fails in Infopath

Hilary Stoupa — Thu, 14 Nov 2013 18:12:44 GMT

Love the file name.

So, at the bottom of the design checker is a "Verify on server" checkbox as well as a "Change settings... " link. Click on Change settings and enter the URL of your server that runs InfoPath Forms Services into the Server validation field. Click Ok. Then click the verify on server checkbox and try refreshing the design checker w/ the refresh button.

Re: REST query works in IE, but fails in Infopath

Unatco99 — Thu, 14 Nov 2013 18:05:59 GMT

Then this one, can't figure out how to get more than one image in a post

Re: REST query works in IE, but fails in Infopath

Unatco99 — Thu, 14 Nov 2013 17:50:04 GMT

First this error

Re: REST query works in IE, but fails in Infopath

Hilary Stoupa — Thu, 14 Nov 2013 17:35:29 GMT

Your screenshots do not display. Try attaching under the Options tab in a reply.

Re: REST query works in IE, but fails in Infopath

Unatco99 — Thu, 14 Nov 2013 17:24:55 GMT

So I'm trying to publish my form to a document library as a template 1. Is that the correct thing to do if I want it to be able to be filled out in a browser? 2. When publishing I get an error that says it was published, but can only be filled out using InfopathFiller as it contains features not usable in a browser, and to check the Design Checker.

But when I check the design checker all I see is an error that says "Could not verify the form template on the server."

So I can't fill it out in a browser because I can't publish it, but I can't publish it because it can't verify it's on the server...

Seems like a circular argument to me....

Re: REST query works in IE, but fails in Infopath

Hilary Stoupa — Thu, 14 Nov 2013 17:23:07 GMT

If you are using SharePoint 2010 and IP 2010, which you must be to be using REST, you do not have to return all the list items on load. Set up your list connection, and when you walk through the data connection, don't query on load. Then, in the form, you can set some query fields in the SharePoint list data source and execute the query to just return your results that match those query specifications. You won't be able to limit the number of items returned however - like I said, SharePoint List connections are good for simple equivalency. You can find some info here: http://blogs.msdn.com/b/infopath/archive/2010/05/06/sharepoint-list-data-connections-in-infopath-2010.aspx

Re: REST query works in IE, but fails in Infopath

Unatco99 — Thu, 14 Nov 2013 17:03:42 GMT

If I need to return say 60 - 100 results from a list of 2000, Rest is better than using a Sharepoint List data connection right? Or in particular I have a list of 12000 entries, I'm not able to limit the list to less than 2000 requests by using the list query am I?

We are on O365, using the Infopath Preview I can get to the document, but I haven't been able to get a document able to be published yet to try it in a browser, so I guess we'll see.

Re: REST query works in IE, but fails in Infopath

Hilary Stoupa — Thu, 14 Nov 2013 16:45:48 GMT

Don't feel dumb - learning new things is a process.

Does equals work in your query string? I don't see it in the URI Conventions: http://www.odata.org/documentation/odata-v2-documentation/uri-conventions/#45_Filter_System_Query_Option_filter

If you have simple equivalence conditions, I'd probably use a SharePoint List data connection and the query fields - just for the sake of simplicity. But if you have more complex conditions than simple equivalence, REST is your only option.

Both should work in the browser - but your mileage may vary with REST if you are using Office365. I can't remember if we can use REST from IP in O365. If your server is on-prem, you should be fine.

Re: REST query works in IE, but fails in Infopath

Unatco99 — Thu, 14 Nov 2013 16:37:00 GMT

Ok, related, but not while I'm waiting for the query to run it was taking forever!

What's the difference between &$filter=FT eq '62' and &$filter=FT equals '62'?

And what's the fastest way to query data from a list, with a connection file loaded in a sharepoint connection library, or with a REST query? And do either of those have restrictions if the form is intended to be filled out using a browser?

And THANK YOU for the help that worked, I feel pretty dumb not including the quotes. :S

Re: REST query works in IE, but fails in Infopath

Hilary Stoupa — Thu, 14 Nov 2013 16:20:26 GMT

InfoPath is not going to add quotes for you. You will have to add them.

concat("https://site/_vti_bin/listdata.svc/LstFieldRepInfo()?$select=FT,RepSuperName&$filter=FT eq '", string(.), "'")

Re: REST query works in IE, but fails in Infopath

Unatco99 — Thu, 14 Nov 2013 16:03:27 GMT

Ok, I think that will work, except, the FT's are all numbers, 29, 36, 620, 300, etc. When I run the query on IE I get an error that "Operator 'eq' incompatible with operand types 'System.String' and 'System.Int32' at position", however both the dropdown list and the Sharepoint List have those fields set for string, so apparently something is converting the FT to an Integer and IE has an issue with that. How do I force the FT say 35 to get passed as a string, or for the sharepoint list to read the value in it as a string, whichever one is insisting on auto changing the value to an Int?

I tried setting the filter up and setting the dlFieldRep as ...

concat("https://site/_vti_bin/listdata.svc/LstFieldRepInfo()?$select=FT,RepSuperName&$filter=FT eq ", string(.)) - This is for a different list, but the values are the same as the initial list. If I enter in IE...

https://site/_vti_bin/listdata.svc/LstFieldRepInfo()?$select=FT,RepSuperName&$filter=FT eq '35' - IE complies with returning a single value, however when I see the query run in infopath the 35 is not in single quote, leading me to believe it's not actually converting the value to string. Right?

Re: REST query works in IE, but fails in Infopath

Unatco99 — Thu, 14 Nov 2013 15:16:31 GMT

Thank you!

Gonna give it a whirl now and I'll let you know!

Re: REST query works in IE, but fails in Infopath

Hilary Stoupa — Thu, 14 Nov 2013 15:13:35 GMT

So, you need to add a rule that sets your URL. Have you done that? If not, you need to decide what change in your form should cause this query to happen. You'll add a rule with the action set a REST URL - and in that rule's dialog, click the fx button for the value.

Your formula will look something like this:

concat("https://Site/_vti_bin/listdata.svc/LstProInfoCur()?$select=Div,Name,Addr,City,St,Zip,Phone,FT&$filter=Div eq", dlDiv)

You'll pick the dlDiv field using the button that says "Insert field or group".

If you need some help with this, you can attach your form (or a sample that has your REST connection in it) under the options tab and I'm happy to give you a hand.

Re: REST query works in IE, but fails in Infopath

Unatco99 — Thu, 14 Nov 2013 15:03:06 GMT

Hi! No I'm not. I think I missed that part of the non-existant instruction class I got offered by the company! ;)

I've seen some blogs and posts about doing this, but I have found it very confusing to follow what the concat does, and how it should be constructed to get what I want. I kinda need it in dummy terms and everything I've read seems to assume a pre-existing familiarity with the concat function, which I don't have.

How can I format my query using concat to filter what I need?

Re: REST query works in IE, but fails in Infopath

Hilary Stoupa — Thu, 14 Nov 2013 14:36:57 GMT

Hey there - so when you set the REST URL in your form, are you using a concat formula to include the value of dlDiv?