getting data from Sharepoint lists

Hi,

I'm trying to get data from WSS lists by web services. I think there are two ways:

- using SSIS standard components (Web Service Task) and
- creating a custom source adapter.

My problem with the Web Service Task is, that the WSS method GetListItems has some non-standard parameters (see part from wsdl-file below). Thus, after selecting the method in the editor an clicking on "Ok", I get the error message "The selected Web method contains unsupported arguments". I think the problem is the missing type-attribute.

<s:element name="GetListItems">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="listName" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="viewName" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="query">
<s:complexType mixed="true">
<s:sequence>
<s:any />
</s:sequence>
</s:complexType>
</s:element>
...

My question: Is there a way to extend the Task to handle such parameters



Answer this question

getting data from Sharepoint lists

  • duggant

    No there isn't. But you can consume Web Services of this nature in SSIS using the script task/component. Donald Farmer's book shows you how.

    -Jamie



  • getting data from Sharepoint lists