60 likes | 182 Vues
This guide explores submitting data to SharePoint lists using InfoPath, highlighting the use of the data connection wizard. It discusses the pros and cons of this approach, including its easy-to-use wizard and zero-code requirement, as well as challenges like difficulty in migration and limitations on linking. Alternatives such as using the List Service, custom web services, and third-party tools are also examined. Learn to utilize CAML queries to efficiently assemble and manage your list item data seamlessly.
E N D
Submitting to Lists List services for use in InfoPath
Submitting to SharePoint • Traditionally, we employ the data connection wizard
Standard Connections Pros Cons • Easy to use wizard • Simple to publish • Zero code • Easy learning curve • Difficult to move to a new system • Limitations in what can be linked • No inherent support for some SharePoint data storage • Did I mention difficult to move?
Alternatives? Generally, this means getting into some code Using the list service at /_vti_bin/lists.asmx Employing our own web service Building a work-around with a 3rd party tool (ie a web service someone else has written)
Using the List Service • Add Lists • Add/Update list content • Check in/out files • Delete attachments or list items • Get list and view • Get collection of list attachments • Get list items themselves • Update the values/settings of fields in list items • Submit data from one form to multiple libraries and lists simultaneously
CAML Query • The core string is assembled with controlling variables below: • The rest of the command/data string is assembled with code further along By using a CAML Query, we construct a set of data that contains our list item data. These can be thought of as the “rows” in the list.