MYSQL-SMP3.0:IntegrationGatewaywithMySQLDatasource(Part3)（图文）

Test the OData service

1. Log on to SMP 3.0 Admin: https://smpserver:port/Admin

2. Create a new security profile with name as &＃39; sap &＃39; (exact name as namespace) under Settings>Security profiles>New

3. Log on to SMP3 gateway cockpit https://smpserver:port/gateway/cockpit

4. Go to destinations tab, Create a new destination

5. Move to Services tab, click on deployed service employee_MYSQLDB.

• Click on &＃39;Add Destination &＃39;, select MYSQLDB from the drop-down.

• Save and close.
  

6. Once done, open the service document,

http://smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1

7. Open service metadata document

• OData defines a metadata format based on the Entity Data Model in XML (edmx).

• To access a service&＃39;s metadata document use the $metadata command.

• The returned document is the service&＃39;s edmx metadata + backend metadata

smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1/$metadata

8. To get the details for the Entity &＃39;employee&＃39;

smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee

To fetch only first row of the table,

smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee(1001)

OData operations : RetrieveEntity (READ)

To retrieve details of a specific entity,use HTTP GET verb to execute the same.

• Open Advanced REST client

REQUEST:

• URL: jk:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee

• Use HTTP GET verb to execute this operation.

• Pass below header values

RESPONSE :

• 200 OK status message

• X-CSRF-TOKEN value e.g. 1B4687085D8F59B1CA21382DF17D535A

OData Operations – InsertEntity (CREATE)

• The InsertEntity operation creates an entity.

REQUEST :

• URL: jk:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee

• Use HTTP POST verb to execute the InsertEntity operation.

• Pass below header values

• Pass this xml text into the BODY

1006SACHINSHARMACHANDIGARHINDIA

RESPONSE :

• This operation creates an entity.

• Successful execution of the operation returns HTTP 201 status code along with the Location of the newly created entity will be returned.

To verify, you can check with smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee(1006) OR directly in the MySQL database.

OData Operations – UpdatetEntity (UPDATE)

• The UpdateEntity operation updates an entity.

REQUEST

• URL: jk:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee(1003)

• Use HTTP PUT verb to execute the this operation.

• Pass below header values

• Pass this xml text into the BODY

xml version="1.0" encoding="UTF-8"?>

1003CHIPROGSAN FRANSUSA

RESPONSE :

• If the update is successful, the server responds with 204 status code .

• As the response code text " No Content " signifies, no data is returned in the Response Body.

OData Operations – DeleteEntity (DELETE)

• The DeleteEntity operation deletes an entity.

REQUEST

• URL: jk:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee(1006)

• Use HTTP DELETE verb to execute this operation.

• Pass below header values

RESPONSE :

• If the delete is successful, the server responds with 204 status code.

• As the response code text " No Content " signifies, no data is returned in the Response Body.

NextPart 4

以上就是MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)（图文）的内容，更多相关内容请关注PHP中文网（www.php1.cn）！