SharePoint – Web Services Data integration (SOAP)

In my previous post I explained you how to consume a Web Service using Autoit and Powershell.

Now we can see how to access the data in SharePoint.

First we need to connect to the Web Service Provider.

1. Open SP Designer and go to Data Sources. And add a new SOAP Service Connection.

image

Fill in the Web Service URL http://www.webservicex.net/uszip.asmx?WSDL

image

2. Next create a new Web Part Page

First go to Site Pages and create a new page 

image

Let’t go for a Web Part Page

image

3. Open it to insert the new SOAP Connection.

image

Once the page is open.

4. Go the Insert menu and Data View option

image

And browse down to the new connection in this case USZip Web Service.

image

5. Insert the connection in the Web Part Zone

image

6. Save it and look at the result.

image

That’s it as simple as that Winking smile

image

No let’s see that we can filter it based on a Query String.

Open the Page you created again in FD, and create :

image

1. First create a Parameter first called “CITY”  and a Query String variable called “CITY”.

image

Default value is an option.

2. Next create a Filter.

Open the Data Source Again and remove the Default value “New York” again

image

Click on the FILTER menu item

image

it should look like this in the end.

image

Save the page and test it using the Query string Parameter “City”

/sites/sandbox/SitePages/Zip%20Soap%20Test.aspx?City=New York

Enjoy !

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: