December 2011 - Posts - Hilary Stoupa
in

InfoPath Dev

Hilary Stoupa

December 2011 - Posts

  • Sandbox, Service Accounts, qRules, Code & DBXL

    Forms injected with qRules or that have custom code can be published as sandboxed in SharePoint 2010, if your SharePoint install has sandbox enabled.

    However, we are seeing that forms that have a loading event (either from the injected qRules DLL or in the custom code) appear to run under the service account when they first open. This means that a web service returning Active Directory info (like DBXL) may not return the expected results, if any, if the data connection is set to execute when the form loads.

    Setting a rule to execute the data connection when the qRules finishedLoading node is set to true (after qRules finishes initializing) also appears to be running under the service account.

    Executing the data connection after the form is completely open appears to run under the actual user account - rules could be set to run on the change of another field if GetMyInfo data is needed.

    This also means that a SharePoint web service, like UpdateListItems, will use the same service account. So a sandboxed qRules form that is using the SubmitToSharePointList command will show submitted list items as having been created or modified by the service account.

    To work around this, you can continue to admin approve your qRules templates. Admin approved forms make web service calls with the credentials of the logged in user.

  • SharePoint OData and InfoPath

    If you are using SharePoint and InfoPath 2010, you may already have SharePoint's OData services at your disposal. And while with 2010 we now have query fields for list and library data connections, you can go far beyond basic equivalency in your queries with the OData URI conventions. I've got a video up on Channel 9 you can use to get started leveraging this fantastic tool you may not even be aware you have!

  • Using Excel Services REST API in InfoPath

    InfoPath 2010 has the ability to return data from REST web services - and Excel Services in SharePoint 2010 has a REST API. I've got a video up on Channel 9  that talks about different ways to leverage Excel in InfoPath, including dynamic charts using data from your form!
Copyright © 2003-2017 Qdabra Software. All rights reserved.
View our Terms of Use.