Understanding the Data Service
The AIS Server provides an endpoint called "dataservice" for data query or count requests over tables or business views.
Data service calls are made using the DataRequest object. If you use the data service, you must include the "dataservice" capability in the required or used capabilities list.
Parameter |
Description |
Values |
---|---|---|
targetName |
The name of the table or view to count or query. |
Example values: F0101 or V4210A |
targetType |
The object type to count or query: table or business view. |
DataRequest.TARGET_TABLE DataRequest.TARGET_VIEW |
dataServiceType |
The type of operation to be performed: count or query (represented by the value BROWSE). |
DataRequest.TYPE_COUNT DataRequest.TYPE_BROWSE |
Parameter |
Description |
Values |
---|---|---|
findOnEntry |
This parameter determines if the service performs an automatic find. |
FormRequest.TRUE FormRequest.FALSE |
returnControlIDs |
The columns of the table or business view to be returned in a query response (pipe delimited). |
Example values: F0101.AN8|F0101.PA8|F0101.ALPH |
query |
A query object which is built using column IDs for the control IDs. |
|
OrderBy (Available starting with EnterpriseOne Tools 9.2.0.5 and API 1.4.0) |
For calls to an EnterpriseOne Find/Browse form, you can include an order by clause, using the column names (F0101.AN8) and ascending or descending order. Results are sorted by the requested columns, in the order they were added. |