Deleting data with USoft Table Resource

Previous Next

To be able to delete 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 ".

You can delete data without committing.

To delete a record from a table:

1.Compose a URL that identifies the record, for example, a record that specifies the primary key value:        

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 spanning 2 columns:

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

 

2.Select the HTTP verb DELETE.
3.Send the request. In POSTMAN, press the Send button.

 

See Also

Retrieving data with USoft Table Resource

Adding data with USoft Table Resource

Updating data with USoft Table Resource

Calling a Batch Job with USoft Job Resource

Setting up your own REST service