InfoPath Dev

What I was wondering is what happens if you try the URL with the filter in the browser. Did you try that? Didn't you already create a data connection in InfoPath to the REST service?

I am getting this error. But am able to retrieve XML data from the URL

Hi Nesin, I know it's a tricky one. I figured out that if you copy and paste the URL you want to use directly from the browser you will get something like the one you posted. What you need to do is to copy the URL as the location for the Library / List has been set. Not really sure how your Sharepoint site is designed but I can guess that ...

I Used this formula concat("https://[server]/_vti_bin/ListData.svc/Equipment_federal?$filter=substringof('", DESCR, "',my:EquipmentSearch) eq true") and its working fine and the URL also fetching XML data when I opened in a browser(https://[server]/_vti_bin/ListData.svc/Equipment_federal). The form fetching data with ...

 Hi, I saw the above question asked in 2010 and the help that was given proved to be helpful.  Hillary was patient and helped.   I am trying to update an existing record in a sharepoint list, when an InfoPath form is submitted.    On the InfoPath form, I have a drop down list with ...

Test the URL your Change Rest URL rule should be creating - take the same formula you are using there and add it to the form in a calculated value, so you can see what the URL is. Try the URL in your browser's address bar. If the filter does not work, try making modifications to the URL until you have the syntax right. Sometimes IE will return ...

I have changed the fields in the formula first I Used DESCR and then EquipmentSearch. Now I am not getting any error but the filter is not working. I have added Change REST URL and Query Data to the submit button.

Here I attached my form Thanks,

Attach your form under the options tab in a reply and I'll try to give you a hand later today.

Error: Expected value type: , concat("https://share.uh.edu/dor/OCG/_vti_bin/ListData.svc/Equipment_federal?$filter= substringof('", my:EquipmentSearch, "', tolower(xdXDocument:GetDOM("-->Equipment_federal