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. |
||
|
*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 |
|
|
*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