Skip to Content
0
Jun 12, 2016 at 07:22 AM

Simple Transformation for Sharepoint WSDL GetListItems

315 Views

Hi

I'm able to read from ABAP a SharePoint List by using the SharePoint Webservice. For this I created a Enterprise Webservice. So far so good.

When I use the WebService Method Get_List_Items.with this XML

<n0:GetListItems xmlns:n0="http://schemas.microsoft.com/sharepoint/soap/">
<n0:listName>{67D38E2A-647D-4976-B989-BD8B2E131DDC}</n0:listName>

</n0:GetListItems>



I'm getting also a result:

<?xml version="1.0"?>

<n0:GetListItemsResponse xmlns:n0="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><n0:GetListItemsResult xmlns:z="#RowsetSchema" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"><n0:listitems><rs:data ItemCount="8"><z:row ows_LinkTitle="1337" ows_Plant="10" ows_MetaInfo="1;#" ows__ModerationStatus="0" ows__Level="1" ows_Title="1337" ows_ID="1" ows_UniqueId="1;#{05F8EDB7-D0CA-4024-8125-AC3628394B69}" ows_owshiddenversion="5" ows_FSObjType="1;#0" ows_Created_x0020_Date="1;#2016-02-16 14:20:31" ows_Created="2016-02-16 14:20:31" ows_FileLeafRef="1;#1_.000" ows_PermMask="0x7fffffffffffffff" ows_Modified="2016-05-27 23:18:38" ows_FileRef="1;#Lists/Testlist/1_.000"/></rs:data></n0:listitems></n0:GetListItemsResult></n0:GetListItemsResponse>



In my ABAP I try to read the XML using simple transformation, but don't have a clue how this simple transformation should look like.

Does anybody has an example used with a SharePoint Webservice Method?


Or could anybody tell me how the ST should look like?


Any response is welcome

Thx

Roger