Office 365 Excel Services REST connection not working in Browser - InfoPath Dev
in

InfoPath Dev

Office 365 Excel Services REST connection not working in Browser

Last post 04-24-2012 07:56 AM by Hilary Stoupa. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next

  • 04-11-2012 10:38 AM

    • BHerz
    • Not Ranked
    • Joined on 01-04-2012
    • Tampa Florida
    • Posts 8

    Office 365 Excel Services REST connection not working in Browser

    Reply Contact
    Description:

    We have an InfoPath 2010 Browser enabled Form with a REST data connection to an Excel Services Workbook (located in the same site collection). The data connection has been added and approved in a dataconnction library as a udcx file  in the same site collection. The Data connection works as expected when InfoPath is opened in the Client ( Preview mode). But, if try open the InfoPath form in the Browser the connection fails with the error message below. The REST URL works as expected when run directly from the Browswe IE9 in both ATOM and HTML formats.

    "an error occurred quering a data source. "XML data that is required for this form to function correctly cannot be found.  The remote server returned an error: (403) Forbidden "
    An entry has been added to the windows event log of the server. LOG ID: 5566"

    Just want to know if anyone else has been able to excute an Excel Services REST query in an InfoPath Browser form on Office 365.

    Any ideas of resulution would be appreciated.

    Thanks

    Bruce

     

  • 04-12-2012 03:20 PM In reply to

    Re: Office 365 Excel Services REST connection not working in Browser

    Mark as Answer
    Reply Contact

    Can you send a copy of the form and workbook you are using?  We have created an IP form with rest connections to Excel on O365.   Is the data content very large?

  • 04-17-2012 10:24 AM In reply to

    • BHerz
    • Not Ranked
    • Joined on 01-04-2012
    • Tampa Florida
    • Posts 8

    Re: Office 365 Excel Services REST connection not working in Browser

    Mark as Answer
    Reply Contact

    Hi Jim,

    Have you had a chance to look at the files I sent to you?

  • 04-17-2012 10:27 AM In reply to

    • BHerz
    • Not Ranked
    • Joined on 01-04-2012
    • Tampa Florida
    • Posts 8

    Re: Office 365 Excel Services REST connection not working in Browser

    Mark as Answer
    Reply Contact

    Hi Jim,

    Have you had a chance to lool at the files I emailed to you?

  • 04-18-2012 09:09 AM In reply to

    • BHerz
    • Not Ranked
    • Joined on 01-04-2012
    • Tampa Florida
    • Posts 8

    Re: Office 365 Excel Services REST connection not working in Browser

    Mark as Answer
    Reply Contact

    Hi Jim,

    Just in case anyone else in the Forum is having a  issue when using Excel Services REST connections with Office 365

    Daizy Shen with the  Partner Online Technical Community
    Has reporduced asimular issue with Office 365 and InfoPath Excel Services REST connections.
    See message below.

    I will update when provided a resolution from the Office 365 Support team.

    Thanks

    Bruce Herz

    WonPoint

    Hi Bruce,
    Thanks for your reply!
    My previous test did work. To double confirm, I tested again. My form with a REST Connection doesn’t work. Forms without REST connections work. I’ve tested many times this time and all the tests with a REST Connections failed. The error message
    " This form cannot be opened in a Web browser. To open this form, use Microsoft InfoPath".   The error message is not the same as yours

     To move forward, we need to check the logs at the server side to find what’s going on. So as I suggested before, please contact the Office 365 support team to ask for their help to have a check the logs. The contact info can be http://onlinehelp.microsoft.com/en-us/office365-enterprises/ff637572.aspx. Thanks for your understanding!
    If you need any help in bridging, please feel free to let me know.
    Best regards,
    Daizy Shen
    Partner Online Technical Community

  • 04-24-2012 05:02 AM In reply to

    • BHerz
    • Not Ranked
    • Joined on 01-04-2012
    • Tampa Florida
    • Posts 8

    Re: Office 365 Excel Services REST connection not working in Browser

    Mark as Not Answer
    Reply Contact

    Below is a response from the Office  365 Support Engineer Microsoft SharePoint Online as of April 24 2012

    "As of now the REST data connection is not functional with Office365.

    It was funtional before Service update 1 but there have some ongoing issues.

    So for now the REST data connection has been removed.

    There is no timeline of when this will be implemented and considered to be in working condition."
    Filed under:

  • 04-24-2012 07:56 AM In reply to

    Re: Office 365 Excel Services REST connection not working in Browser

    Mark as Answer
    Reply Contact

    Thank you so much for posting this information. This is very good to know.

    Do you know if this is just for Excel REST? Or for all SharePoint REST services in O365?

    Hilary Stoupa
Page 1 of 1 (7 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.