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.

Data Service Request Required Parameters

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

Data Service Request Optional Parameters

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.