BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Calling sharepoint list web service from Sap Data Services


 
Search this topic... | Search DI: Realtime and NRDM... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Realtime and NRDM  Previous TopicPrint TopicNext Topic
Author Message
innotek
Forum Member
Forum Member



Joined: 17 Jan 2017

Posts: 5



PostPosted: Sun Aug 25, 2019 8:04 am 
Post subject: Calling sharepoint list web service from Sap Data Services

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
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Realtime and NRDM  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0261 seconds using 17 queries. (SQL 0.0024 Parse 0.0008 Other 0.0229)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo