Retrieving data with USoft Table Resource

Previous Next

To be able to retrieve 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 want to retrieve data through a REST service based on "USoft Table Resource". Click what you want to do:

Get information on tables and columns from which you can retrieve

Retrieve all data in a table

Retrieve records that contain a specific value

Retrieve records with values higher, lower or different than a specific value

Retrieve only values that match a pattern

Retrieve only specific columns

Sort the result by a specific column

Rename a column in the output

 

 

collapseTo retrieve all the data in a table:
collapseTo retrieve only records that contain a specific value:
collapseTo retrieve only records with values higher, lower or different than a specific value:
collapseTo retrieve only values that match a pattern:
collapseTo retrieve only specific columns:
collapseTo sort the result by a specific column:
collapseTo rename a column in the output:

 

 

See Also

Getting Table and Column Information with USoft Table Resource

Adding data with USoft Table Resource

Updating data with USoft Table Resource

Deleting data with USoft Table Resource

Calling a Batch Job with USoft Job Resource

Setting up your own REST service