I recently tried to access an Excel spreadsheet range as a Rest web service in Infopath 2010; no luck. Here are the steps I followed:
1. [Successful] Upload Excel spreadsheet with the said ranges onto a Sharepoint document library
2. [Successful] Bind the Excel spreadsheet range (I have one called Regions) in the Sharepoint document library as a Rest web service in Infopath form's listbox control during design time as follows -
3. [Failed] Then I tried to preview the form, but the actual data in the Excel range failed to populate the Infopath listbox control. The error I got was:
"Could not open "http://<localhost>/sites/<site name>/_vti_bin/ExcelRest.aspx/EventBudgets/Lookups.xlsx/Model/Ranges('EventTypes')?$format=atom"
The error I then got from Infopath was a pop-up saying:
The query cannot be run for the following DataObject: Event Types
InfoPath cannot run the specified query.
The file is not a valid XML file.
Not enough storage is available to process this command .
If anyone out there has experienced a similar issue and resolved it, please kindly share your solution approach.
View Complete Post