Routes for SOAP

[NIkhil]

Hi guys,
 
 I was trying SOAP services in ql.io,  I am having an issue accessing the service via route.

 The problem is - Soap service is accessible from the ql.io console using -

create table soap.trial1
  on select post to 'http://myHost:8080/SoapTest/services/SOAPDemoNewService?wsdl'
            using bodyTemplate 'tables/soap/trial.xml.mu' type 'text/xml'
            resultset 'soapenv:Envelope.soapenv:Body';
           

return select * from soap.trial1
    where num1=11 and num2=11;

but when I write a route:

return select * from soap.trial1
    where num1='{num1}' and num2='{num2}'
    via route '/soap/trail1?num1={num1}&num2={num2}' using method get;  

and run:

http://qliohost:3000:/soap/trail1?num1=50&num2=100'

it gives me this error:
    "headers" : {
        "content-type" : "application/json"
    },
    "body" : {
        "faultstring" : "The endpoint reference (EPR) for the Operation not found is /SoapTest/services/SOAPDemoNewService?wsdl= and the WSA Action = null"
    },
    "emitted" : true
    }


EPR - its an error when the service(wsdl) could not be found.

But the surprising thing is that it works through ql.io console but not through route.
I also have a soap client and service runs without any such errors.
  
 Am I missing something ?

P.S. I am a newbie to SOAP and ql.io

Any help is deeply appreciated.

Thanks,
Niks

[shimonchayim]

Nikhil,

Have you give the right endpoint:  'http://myHost:8080/SoapTest/services/SOAPDemoNewService?wsdl'

Your endpoint is typical for getting the wsdl not invoking a soap operation.

- Cylus

[NIkhil]

Thanks Cylus,

 You were right, the endpoint is not correct, in addition I also have to add SoapAction header in the create table statement and it worked.

Niks

[shimonchayim]

Wonderful!