5.31.6 GET

The GET command is used to get data from the DataSource object.

If a PROPERTY value does not exist an empty string is returned.

Syntax:

Command

Keyword

Value

Developer notes for Command/Keyword/Value

GET

OBJECT

*DATASOURCE

Mandatory. The OBJECT (*DATASOURCE) returns the data source name in the response message field.

*FIELD

The OBJECT (*FIELD) is used to update field values from the data source. If no NAME keyword is present, then a list of field names from the list argument are used. If the NAME (*ALL) keyword is used then all the fields in the data source are used. A single field name can also be used to select one field.
The field name is the program field name not the data source field name.

*TABLE

The OBJECT (*TABLE) requires the NAME keyword to specify which data source table will be used to fill the list object argument. The map object is used to map column names to field names and if the resolved field exists in the list object its value is updated.

NAME

value

Mandatory for *FIELD and *TABLE
The NAME keyword is the name of the table or field in the data source.
The field name is the program field name not the data source field name.

*ALL

All the fields from the data source.

PROPERTY

value

Optional. HTTP protocol property.

 

Example

 

GET OBJECT (*DATASOURCE)
GET OBJECT (*TABLE) NAME (SKILLS)
GET OBJECT (*FIELD) – use program field names from list argument
GET OBJECT (*FIELD) NAME (EMPNO) – single program field name
GET OBJECT (*FIELD) NAME (*ALL) – use all data source fields