Restful Services CMS Query

sdk development
1

Has anybody had any success with performing CMS queries using Restful web services? I’ve tried sending the following message as per the documenation :


<attrs
xmlns="http://www.sap.com/rws/bip">
<attr name="query" type="string">"SELECT * FROM CI_INFOOBJECTS WHERE SI_ID=1234"</attr>
</attrs>

I keep getting the following error returned :

“The remote server returned an error: (500) Internal Server Error.”

I’ve turned up logging on the WebApplicationContainer server and I found the following error message next to the query itself :

“(FWM 02103) Unable to parse the following query”.

Just to add the “GET http:///infostore/cmsQuery” returns successfully.

FrustratedScot :uk: (BOB member since 2006-04-27)

2

I haven’t used cmsQuery myself, but the double quotes around the query text are suspicious. Try it without them.

joepeters :us: (BOB member since 2002-08-29)

3

You are an absolute star, that did the trick. I won’t tell you how long I spent on this yesterday.

Cheers

Alistair

FrustratedScot :uk: (BOB member since 2006-04-27)