on 10-20-2009 1:43 PM
Hi, I have a need to access a Sharepoint database from SAP. I am using the search.aspx webservice that sharepoint offers, or at least trying to. I set up an abap proxy from the WSDL that sharepoint supplied (which was not the best WSDL). From my ABAP I need to call the sharepoint service and I am having a little difficulty getting a result back.
Here is the ABAP code I have so far:
DATA: gr_query TYPE REF TO zgms_cycletimeco_query_service,
gs_input TYPE zgms_cycletimequery_soap_in,
gs_output TYPE zgms_cycletimequery_soap_out.
DATA: oref TYPE REF TO cx_root,
text TYPE string,
oref2 TYPE REF TO cx_root,
text2 TYPE string.
CREATE OBJECT gr_query.
CONCATENATE 'get_text( ).
ENDTRY.
I am trying to retrieve the record that contains HE2009-0624-084648 with no luck.
The error message I get says no results found.
Does anyone know what I am doing wrong? Do I need to specify the field in sharepoint that contains this data?
Thanks in advance,
René
Hi,
First try to test proxy directly from SE80. to me it seems problem with query xml, perhaps you need to convert it to http (replace "<" tags with http equivalent)
But test with SE80 and let us know result.,
Regards,
Gourav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your reply. I actually tested today in SE80 on the proxy, and the request was formatted as:
<n0:Query xmlns:n0="urn:Microsoft.Search" xmlns:prx="urn:sap.com:proxy:PLD:/1SAI/TAS4ADD6B94366302A825F7:700:2007/10/04">
<n0:queryXml>This is a string 6</n0:queryXml>
</n0:Query>
When I execute it, the reponse is:
- <n0:QueryResponse xmlns:n0="urn:Microsoft.Search" xmlns:prx="urn:sap.com:proxy:PLD:/1SAI/TAS4ADD6B94366302A825F7:700:2007/10/04">
<n0:QueryResult><ResponsePacket xmlns="urn:Microsoft.Search.Response"><Response domain=""><Status>ERROR_BAD_REQUEST</Status><DebugErrorMessage>Data at the root level is invalid. Line 1, position 1.</DebugErrorMessage></Response></ResponsePacket></n0:QueryResult>
</n0:QueryResponse>
I don't really know what the format would be in between the queryXml tags. If anyone knows, please help!
Thanks.
Hi Renee & rest of you experts
I am trying to Consuming a Webservice that comes from Sharepoint
this is the wsdl file:
http://sitet.domain/_vti_bin/spsearch.asmx?wsdl
But it prompt me for a user and password ? - I have tryed to enter my Sharepoint pw without any luck..
How did you manage to access the Webservice - it seams to something setup with the AUTH. on sharepoint or ?
best regards
Lars
User | Count |
---|---|
87 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.