Page 1 of 1
Getting data from Sharepoint
Posted: Thu Dec 29, 2011 6:03 pm
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
Posted: Thu Dec 29, 2011 7:06 pm
by chulett
Moved to the SOA forum, split into its own post.
Posted: Sat Dec 31, 2011 12:04 pm
by qt_ky
What version of SharePoint?
Any specific SharePoint web service?
Posted: Sat Dec 31, 2011 7:47 pm
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
Posted: Sun Jan 08, 2012 11:26 pm
by ecclesr
What version of SharePoint? 2010
Thanking you in advance
Posted: Mon Jan 09, 2012 12:07 am
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