General

Re: REST Connection to Excel in Infopath

micknisbet — Tue, 22 May 2012 15:58:41 GMT

No, a very small return.

I have got it working now, looks like I was passing the date&time when it was only looking for the date. I have sent a substring and now it's working.

Re: REST Connection to Excel in Infopath

Hilary Stoupa — Tue, 22 May 2012 14:34:55 GMT

InfoPath leverages IE settings for some things, which is why I asked - unfortunately, that's the only time I've seen this error - with https and IE8. Your REST query isn't returning a huge amount of data, is it?

Re: REST Connection to Excel in Infopath

micknisbet — Tue, 22 May 2012 08:31:28 GMT

Hello, thanks for replying. It's an http connection. I'm not using IE at the moment, it's just using the preview in Infopath. When I type the address into IE, it works and returns the correct value.

Re: REST Connection to Excel in Infopath

Hilary Stoupa — Mon, 21 May 2012 15:54:07 GMT

Is your URL http or https? What version if IE are you using? I've seen this with https and IE 8.

REST Connection to Excel in Infopath

micknisbet — Mon, 21 May 2012 14:08:53 GMT

I'm having trouble setting up a REST connection from an Infopath 2010 form trying to connect to an Excel 2010 document which is stored in a Sharepoint Document Library. I have followed the guide here: http://www.avanadeblog.com/sharepoin...path-2010.html

I have successfully added the connection, which completed with no errors. When I try to use the connection however, I get the following error:
"The query cannot be run for the following DataObject: REST Connection
InfoPath cannot run the specified query. The file is not a valid XML file.
Not enough storage is available to process this command."

Any ideas?