Getting data from Sharepoint

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
ecclesr
Premium Member
Premium Member
Posts: 260
Joined: Sat Apr 05, 2003 7:12 pm
Location: Australia

Getting data from Sharepoint

Post by ecclesr »

Have any DSXchange member had experience getting data from Sharepoint

If you have can you share your knowledge of the webmethod used and the values/parameters used for the webmethod.

I am especially interest in the values/parameters required for the DataStage Webservices client stage

Thanking you all in advance
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Moved to the SOA forum, split into its own post.
-craig

"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

What version of SharePoint?

Any specific SharePoint web service?
Choose a job you love, and you will never have to work a day in your life. - Confucius
ecclesr
Premium Member
Premium Member
Posts: 260
Joined: Sat Apr 05, 2003 7:12 pm
Location: Australia

Post by ecclesr »

What version of SharePoint? - Currently not at work - but assume it is a recent version

Any specific SharePoint web service? - webmethod GetListItems

My DataStage Webservice client stage is using the metadata for this method

I am unsure what the values of the fields should be on the webservices client stage input page for this particular query based Webmethod - can you provide examples of values for each field - then I will know the correct syntax

The Query fields are the most confusing

The web client stage I did get working was a non query Webmethod so the field values were text

This query Webmethod is more complex - and I have no example of the what the input values should be

This problems is strictly input values for Webservice client stage where the webmethod GetListItems

Thanking you in advance
ecclesr
Premium Member
Premium Member
Posts: 260
Joined: Sat Apr 05, 2003 7:12 pm
Location: Australia

Post by ecclesr »

What version of SharePoint? 2010

Thanking you in advance
ecclesr
Premium Member
Premium Member
Posts: 260
Joined: Sat Apr 05, 2003 7:12 pm
Location: Australia

Post by ecclesr »

The Input arguments that I am using are

listName {37f98f03-1245-4e5e-84b2-a1eb7e69c1f5}
viewName null
query null
viewFields null
rowLimit null
queryOptions null
webID null

The Web Service client Error message I get is

Web_Services_Client_4,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.xml.DerivationParser$NameExpectedException: Rule [2] "/ns1:GetListItems/ns1:query/*", invalid token; element or attribute name expected.

Does someone have an example of values for the Input arguments

Thanking you in advance
Post Reply