Need help in creating linked datasource using SOAP Service Connection in SharePoint Designer--- SharePoint 2010

Question

Hi,

 

I am currently working on 1 requirement in SharePoint 2010. We have 2 site collections each contain a document library (Say A).

We need to merge document libraries (which reside on 2 different site collection on the same server) and display the documents (not folders) using one dataview webpart.

We created a linked datasource in one site collections accessing the other site collection library using SOAP Service Connection.

 

It is working fine to get the merged items for folders. But we are unable to get the items (files) inside the folders.  When we use the SOAP Service Connection, “Folder Scope” is disabled.

 

We tried to set Folder Scope = “recursive” in the CAML query and also in the SPDatsource , but failed to get the documents from folders.

 

Can anyone please help me ?

 

Thanks in advance.

Answer 1

I don't know how to MAKE it work with SOAP, but I do have suggestions.

1. You shouldn't be using folders to begin with.  Folders went the way of the dodo in 2007, so using them in 2010 now that we have enterprise metadata is really a shame.  Sometimes there are reasons why you have to use them, but I recommend trying to fully-utilize the concept of metadata, ESPECIALLY now that we have the managed metadata service.  You could be using the exact same content types with the exact same columns in both site collections, which seems like it would be perfect for merging data like this.
2. Try using a REST data source instead.  Connect to http://site/_vti_bin/ListData.svc and the list name.

---

SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

Answer 2

Thanks for the reply. We have requirement in such a way that we have to use folders. Is there any other way we can merge the datasources and show items (files) beneath tyhe folders ?

Answer 3

Hi,

I could resolve this issue by creating a view without having folders and consuming through SOAP Service connection. It is working fine, but if the view contains more than 50,000 items, then it is taking lot of time. Now we are actually getting all the items and filtering them using the dataview webpart properties. Is it possible to get the filtered items using SOAP Service connection ? Can we dynamically pass parameters to SOAP Service connection ?

Answer 4

Even if it is an old post, maybe my answer will help some peoples.

It is possible to use Query in parameters SOAP Service connection, something like:

<Query><Where><Eq><FieldRef Name="fieldName" LookupId="TRUE"/><Value Type="Integer"><fieldName /></Value></Eq</Where></Query>

Ovidiu

---

OvidiuG

Answer 5

1. Go to the data source in SharePoint designer  

2.1          Go to General tab:

2.1.1      Name: put the service name

2.1.2      Description :put the description

2.2          Go to source tab and apply below information:

               

                2.2.1      Pass list url:  /_vti_bin/Lists.asmx?WSDL

                2.2.2      Data command to configure : select option in dropdown

                2.2.3      Port : listssoap option in dropdown

                2.2.4      Operation: GetListItems option in dropdown                    

                               

In Parameters :

List name: {ID}come from the list as shows in  below screen                                                                                                                                                                                                                                                                                                                                                            

gueryOptions: put caml query

Like:<QueryOptions><ViewAttributes Scope='Recursive' /><Folder>test1</Folder></QueryOptions>

2.3 apply this above service on site page within dvwp.