SharePoint Blogs / SharePoint University
SharePoint Blogs and SharePoint University - all in one place!
Need SharePoint Training? Attend a SharePoint Bootcamp!

Please delete cookies related to sharepointblogs.com and sharepointu.com to resolve login issues!

Showing web service data in a Data View web part
All About SharePoint - S.S. Ahmed - MVP Microsoft SharePoint

Update:

Originally posted: Sat, Feb 24, 2007

Reposted: Aug 26, 2007

Some of the links might not work as this version was retrieved from a web archive. If you find any dead links, kindly send an email to share.point@yahoo.com with the URL of this page. Thank you!

-------------------------

We can use a data view web part to show information retrieved through a web service. All you need is a web service link. Showing web service data in SharePoint sites is very easy if you use SharePoint Designer. I have already published all this information in another post but because this is a totally different topic, I thought I should publish it as a separate post.

For this walk through, I have used a TechnoService web service. You can use any other web service.

1. Open a SharePoint site (Where you want to deploy the web service) in SharePoint designer.

2. Select Manage Data Sources... from  the "Data View" menu. This will open the "Data Source Library" pane on the right side.

3. Expand the "XML Web Services" node and click Connect to a web service.

4. Enter the web service reference in the Service description location. If you installed the web service in the root application then the path will look like this:

http://localhost/_vti_bin/technos.asmx?wsdl

Leave all other options as they are and click the OK button.

5. Select Insert Data View... from the "Data View" menu. This will add a data view web part to the page.

6. Click the link shown in the data view web part. This will open the Data Sources Library if it's not already open.

7. Right click the web service that you added to the "XML Web Services" node in the "Data Sources Library" and click Show Data.

Data returned from your web service will be displayed.

8. Click the Insert Selected Fields as... drop down and select Single Item View.

9. That's it. Save the page and if you want to add some style to the data view web part, right click the data view web part and select Modify > Table AutoFormat. It will show you several options. Select the option of your choice and your data view web part is ready.

You can apply formatting to the output returned by the web service manually as well. Anyway, here is how the data view web part looked in my SharePoint site after applying some styles:

I changed the title and applied auto formatting.


Posted 02-23-2007 8:28 PM by ssa

Comments

Showing web service data in a Data View web part - ssa's blog wrote Showing web service data in a Data View web part - ssa's blog
on 06-18-2007 10:50 AM

Pingback from  Showing web service data in a Data View web part - ssa's blog

TravC wrote re: Showing web service data in a Data View web part
on 11-07-2007 7:53 AM

Any way to modify or update data via web service and sharepoint designer?

I am hitting the Project Server 2007 web services and simply want to modify a % complete for a task. THis could be for any web service, though...

Ram wrote re: Showing web service data in a Data View web part
on 06-30-2008 7:02 AM

Hi, very nice job Ahmed

But my job is slightly different

i m working on a project of an organization that has its own web service.

actually the task is that, web service has a method with 2 or 3 parameters(skill & experience....) and return the corrosponding vacancy.

now i have to use this on a web part that is on share point site....

please help me other i wiil miss my deadline

please provide me necessary support

my email id is ram.sharma@convergenttec.com

Regards

nimi wrote re: Showing web service data in a Data View web part
on 12-12-2008 2:52 AM

Hi,

This seems to be gud enough to start with.

do you have any article which shows how to insert data through a web service in sharepoint....

ssa wrote re: Showing web service data in a Data View web part
on 12-13-2008 1:44 PM

Nimi,

What is your particular requirement. This article demonstrates exactly what you are saying, that is, adding web service data in Sharepoint.

Nilendu Bhattacharya wrote re: Showing web service data in a Data View web part
on 12-17-2008 7:35 AM

I have configured sharepoint as wsrp consumer for JBoss portal.  When I try to click an action on the JSR 168 portlet from the sharepoint page it give error "Page Cannot be found"...Any clues?

Thanks in advance

Vishnuprasd wrote re: Showing web service data in a Data View web part
on 01-15-2009 2:21 AM

Hi

I am new to sharepoint am a coldfusion developer ,

I have created the web service and able to show the optput in the portal . i want to display the WS output in all users personal sharepoint site (mysite which will have individual space in sharepoint)

Can u help me this?

ssa wrote re: Showing web service data in a Data View web part
on 01-17-2009 9:29 AM

Vishnu

You can customize mysite template to include WS data. The following article has some details: blogs.msdn.com/.../customizing-moss-2007-my-sites-within-the-enterprise.aspx

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
Need SharePoint Training? Attend a SharePoint Bootcamp!
Posts (c) their respective authors. Everything else (c) 2009 SharePoint Experts, Inc.