Updating data with USoft Table Resource

To be able to update data through a REST service based on "USoft Table Resource" functionality, you first need to:

•Define a predefined USoft REST service based on "USoft Table Resource",

•Associate it with a server and a connection,

•Publish it, and

•Set up a test environment.

These tasks are explained in help topic " Predefined REST services ".

To update a value in a table:

1.	Compose a URL that identifies the record:

http://<host-name>:<port-number>/<service-uri>/<connection-name>/<table-name>;<primary-key>=<value>[;<primary-key>=<value>]

For example:

http://localhost:8090/myservice/myconnection/RESERVATION;reservation_id=1337

or, with a primary key that spans 2 columns:

http://localhost:8090/myservice/myconnection/TOUR;destination=HOLLAND;tour_type=TULIPS

2.	Select the HTTP verb PUT.

3.	Specify a Header with name Content-Type and value text/xml. In POSTMAN, to add a header, you can press the Headers button.

4.	To update the value in Column_A to Value_P, specify the following XML fragment. In POSTMAN, press the "raw" button to get a text editor field where you can paste this XML:

<table-name Column_A="Value_P"/>

For example:

5.	Send the request. In POSTMAN, press the Send button.