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
Getting data from Sharepoint
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
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
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
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