Hi all,
I am trying to get data from SharePoint by using list web service.
I created the datastore and import the GetListItems function.
As seen in the attachment, Data Services set data types of four fields as varchar. These columns are listName, viewName, rowLimit, webID .
But Data Services is just showing blank schemes for the following fields: query, viewFields, queryOptions.
The same problem exists for the resultset. Resultset contains a nested schema: Top schema is GetListItemsResponse and inner schema is GetListItemsResult . However GetListItemsResult does not include any fields, like a varchar field. When I click unnest, just one empty schema is shown in target. There is again no columns in the schema.
To sum up, SAP Data Services can not understand data types of a field in the wsdl, if the fields type is mixed and it includes sequence + any .
<s:complexType mixed=“true”>
<s:sequence>
<s:any/>
</s:sequence>
</s:complexType>
I searched internet and this forum too but can not find a solution.
Could you please help?
Thanks in advance,
Omer
innotek (BOB member since 2017-01-17)