mssqlCall

Description

Directly access or call a mssql Web Service.

Input / Parameters

No	Name	Description	Data Type	Required
1	connector	Name of connector and created in the Services and Global Components page.	String	Yes
2	ent	The Web Service name to be called.	String	Yes
3	function	The function from the Web Service to be executed.	String	Yes
4	data	This contains the main parameter in the function being called.	Object	Yes
5	filter	Filter details to be used in retrieving the data.	Object	No
6	orFilter	Filter details to be used in retrieving the data.	Object	No

Output

Coming soon.

Callback

Coming soon.

Video

Coming soon.

Example

The user wants to call the mssql Web Service.

Step

1. Create MSSQL Connector in Services and define the name, url, port, database, user, password and timeOut. Name: mssql url: mkals4utt4.database.windows.net port: 1433 database: emobiq_demo_1 user: sqladmin password: ******** timeOut: 5000

   
2. Create MSSQL Table in Services and define the Name, connector, listKey and serviceName timeOut. Name: tbl_1 mssql: mssql listKey: data serviceName: user_package

   
3. Fill in the field caption for MssqlDataset Fields and generate datalist. Field Caption: 1,2,3,4,5,6

   

   
4. Call the function "mssqlCall"and define the connector, ent, function and set the function"toObject"to data. connector: mssql ent: user_package function: insert data: toObject

   
5. Define the column and value for object. ( Please refer to the images below, we have our own database:emobiq_demo_1 and inside this database we have 6 column which are id(not need to create due to the id no will auto increment), icnum, name, handphone, address, package.) icnum: 9 name: 9 handphone: 9 address: 9 package: 9 (auto display 1)

   

   
6. Add a console for display the response from console.

   

Result

Links

Coming soon.