Create Web Service with Input Parameters

[iniciam]

Hi, i have problem publishing the data on my virtual tables through the web service.

The web service will have 2 inputs parameters (ID and Country) that will be pass through to the virtual procedure getPersonDetails(ID, Country).

This getPersonDetails virtual procedure will then select * from Person where NRIC = ID and Country_code = Country, and return 1 record to the web service and web service return it to the app calling the getPersonDetails method.

I cannot find any howto guide to do this. FYI i have no problem in creating web service without any input parameters. But i cannot find guide to create web service with input parameters.

I read from http://community.jboss.org/wiki/CreatingAndDeployingAnUpdateableTeiidWebServiceWar that you need to create a .xsd file if you want input parameters. Is there any easier way without creating any xsd file ?

Thank you for the help.

[tejones]

iniciam,

The input schema is used for the request in the WSDL, so it is required. However, if you are exposing a relational table, you can right-click on the table and select Modeling->Create Web Service. This will generate the xsd for you. The primary key is used as the input value, so if ID/Country  is the key to the table you are exposing, then those will be the used as input to the web service operation.

Here is a link to the guide that will walk you through the steps: http://docs.jboss.org/teiid/designer/7.4/user-guide/en-US/html/newmodels-chapter.html#web-service-view-from-relational-section

Please let me know if you have more questions.

Thanks,

Ted

[iniciam]

Hi Ted, yes i did that actually.

I right click and create web service:

But the result is not as what i expected (it's different from the guide you gave):

WSTView_Input.xsd is not created. I tried many time but the _Input.xsd never created.

Is this a bug ?

[tejones]

I suspect that your table that you are generating a web service for does not have a primary key defined. That is needed for WSTView_Input.xsd to be generated. Is that the case?

[iniciam]

Yes, it's correct. Now the input xsd is generated.

Thanks.