SharePoint Designer 2010 has a new design. The familiar toolbar is replaced with the ribbon, which was introduced with Office 2007, and sometimes the usual options can be found at unusual places…
Data Connection Types
Linked Data Source-allows you to connect data sources from different locations and show it in one Data View.
Database Connection – allows you to connect to databases.
SOAP Service Connection – allows you to connect to SOAP service connections (e.g. Web Service).
REST Service Connection – allows you to connect to REST service connections (e.g. RSS).
XML File connection- allows you to connect to any XML file of your choosing.
Linked Data Source Settings
Database Connection Settings
REST Service Connection Settings
So how can we create a new Data Source that is connected to a SharePoint Web Service using SharePoint Designer 2010?
First of all we need to open our SharePoint Site in SharePoint Designer:
Enter the “Data Sources” section and click on “SOAP Service Connection”.
From here we can just set the Web Service connection like in SharePoint Designer 2007.
Good news! We still have MOSS Web Services working in SharePoint 2010.
Just to remind you, here is the list of available MOSS Web Services:
| Friendly Name | Location | Description |
| Alerts | /_vti_bin/alerts.asmx | Provides methods for working with alerts for list items in a SharePoint site. |
| Area Web Service | /_vti_bin/areaservice.asmx | Provides an area interface for remote clients. |
| Authentication Web Service | /_vti_bin/Authentication.asmx | Provides ability for Web services to operate in conjunction with forms authentication. |
| BDC Fields Resolver Web Service | /_vti_bin/bdcfieldsresolver.asmx | BDC Fields Resolver Web Service for Clients |
| BDC Web Service | /_vti_bin/businessdatacatalog.asmx | Business Data Catalog Metadata Web Service |
| CMS Content Area Toolbox Info Web Service | /_vti_bin/contentAreaToolboxService.asmx | This Web service is designed for the SharePoint Designer client to use. |
| Copy Web Service | /_vti_bin/Copy.asmx | Provides methods for copying items between locations in the SharePoint environment. |
| List Data Retrieval Web Service | /_vti_bin/DspSts.asmx | Provides a method for performing queries against lists in Windows SharePoint Services. |
| Document Workspace Web Service | /_vti_bin/DWS.asmx | Provides methods for managing Document Workspace sites and the data they contain. |
| Excel Services Web Service | /_vti_bin/ExcelService.asmx | Provides methods to call the Excel Services remotely or work as a callback for Web Parts. |
| Forms Web Service | /_vti_bin/Forms.asmx | Provides methods for returning forms used in the user interface when working with the contents of a list. |
| Forms Services Proxy Web Service | /_vti_bin/FormsServiceProxy.asmx | Provides methods for Forms Services to proxy requests to remote data sources from Web based forms. |
| Forms Services Web Service | /_vti_bin/FormsServices.asmx | Provides methods to call Forms Services remotely or to work as a callback for Web based forms. |
| Imaging Web Service | /_vti_bin/Imaging.asmx | Provides methods that enable you to create and manage picture libraries. |
| Lists Web Service | /_vti_bin/Lists.asmx | Provides methods for working with lists and list data. |
| Meetings Web Service | /_vti_bin/Meetings.asmx | Provides methods that enable you to create and manage Meeting Workspace sites. |
| Official File Web Service | /_vti_bin/officialfile.asmx | Provides methods for sending files to a records repository. |
| People Web Service | /_vti_bin/People.asmx | Provides methods for working with security groups. |
| Permissions Web Service | /_vti_bin/Permissions.asmx | Provides methods for working with the permissions for a site or list. |
| Published Links Web Service | /_vti_bin/publishedlinksservice.asmx | Office clients and other applications can obtain the list of published links on the server that are targeted to the current user. |
| Publishing Service Web Service | /_vti_bin/PublishingService.asmx | Provides methods to remotely work with the publishing service. |
| Search Web Service | /_vti_bin/search.asmx | Allows access to Enterprise Search results from client applications and Web applications outside of the context of a SharePoint site. |
| SharePoint Directory Management Web Service | /_vti_bin/sharepointemailws.asmx | Provides methods for remotely managing distribution groups. |
| Site Data Web Service | /_vti_bin/SiteData.asmx | Provides methods that return metadata or list data from sites or lists in Windows SharePoint Services. |
| Sites Web Service | /_vti_bin/sites.asmx | Provides methods for returning information about the site templates for a site collection. |
| Slide Library Web Service | /_vti_bin/SlideLibrary.asmx | Provides methods for slide library callbacks or remote publishing of slides. |
| Spell Check Web Service | /_vti_bin/SpellCheck.asmx | Provides methods for spell checking callbacks. |
| Search Crawl Web Service | /_vti_bin/spscrawl.asmx | Provides methods for remote Microsoft Office SharePoint Server 2007 farms to crawl a local farm. |
| Search Web Service | /_vti_bin/spsearch.asmx | Provides methods for remotely performing searches within a Windows SharePoint Services deployment. |
| Users and Groups Web Service | /_vti_bin/UserGroup.asmx | Provides methods for working with users, site groups, and cross-site groups. |
| User Profile Change Web Service | /_vti_bin/userprofilechangeservice.asmx | Provides methods to query the user profiles change log remotely. |
| User Profile Web Service | /_vti_bin/userprofileservice.asmx | Provides a user profile interface for remote clients. |
| Versions Web Service | /_vti_bin/versions.asmx | Provides methods for working with file versions. |
| Views Web Service | /_vti_bin/Views.asmx | Provides methods for working with views of lists. |
| Web Part Pages Web Service | /_vti_bin/webpartpages.asmx | Provides the methods to send information to and retrieve information from Web services. |
| Webs Web Service | /_vti_bin/Webs.asmx | Provides methods for working with sites and subsites. |
| Workflow Web Service | /_vti_bin/workflow.asmx | Provides methods to work with workflows. |
Source : SharePoint Products and Technologies Customization Policy
I manage to get it working @ my end. But I some how not able to use “windows authentication” option.
I have to provide username and password.
If I select “windows authentication” then i end up getting unspecified error.
Any idea?
Maybe this post will help you:
http://powerpivotgeek.com/2010/02/08/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated/
implantacion erp…
[...]Working with Data Sources and Web Services connections in SharePoint Designer 2010 « SPoint blog[...]…
Thank you!
Web Design Guide…
[...]Working with Data Sources and Web Services connections in SharePoint Designer 2010 « SPoint blog[...]…
Thanks for the comprehensive list! Very helpful to know what’s availble!
One Question: Do you know of any good resources for how to use the query parameter when trying to create a SOAP Service Connection?
Hi Earnie,
There is a greate article about this :
Yvan’s Blog
Informative. Thank you sir.
also looking for how to use the WCF services in SP 2010 and what is he diff between WCF services and WebServices in SP 2010
Hi Jezzy,
Generaly speaking the difference between WCF and .Net Web Services is only in the development level. WCF has many new possibilities for developers and implements abilities like improved authentication and more. For the end user’s usage of both web services is the same. In SharePoint Designer you can use REST service connection to connect to WCF or .NET web service and it will work mostly the same.
Sometimes you can have issues with connecting to WCF Web Service. In these cases check out this article:
http://support.microsoft.com/kb/2513432
Have a nice day.