Create Web service Using SQL Query Method

Webservice is a way to communicate between external applications. There is 3 way to expose methods through webservices.

·         SQL Query

·         M3 API

·         M3 Display Program

         Open MWS Designer

 Right Click Web Service Repositories -> New Web Service call ItemDT_Blog -> Next

Select SQL Query From Drop Down

 Give Web Service Name as “Items” -> Finish

Here We are writing a webservice using SQL Query method this case we need to give  SQL Query inside SQL Statement Box.

 We have to define input parameters for the SQL Query

Parameters->New

Like wise we need to define other input parameter as well.

After that we need to define the output parameters in the SQL

Click Output ->Add Result Set-> Give Result Set Name as “ItemResultSet”

    Click New

Like above create all three output variables and save

Right Click ItemDT_Blog-> Deploy

 Now we Deploy the Webservice to Server.

End Point

Right Click ItemDT_Blog->Copy End Point