webMethods, OneData, and Terracotta  10.2 | Managing Master Data with webMethods OneData | Developing for webMethods OneData | API Functions and Web Services in OneData | Generic API Functions | getData
 
getData
The structure of the input XML is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<ONEDATA_REQUEST>
<REPOSITORYID></REPOSITORYID>
<CLIENTID></ CLIENTID>
<PROJECTID></ PROJECTID>
<SCHEMAID></SCHEMAID>
<USERID></USERID>
<PASSWORD></PASSWORD>
<SELECTALLCOLUMNS></SELECTALLCOLUMNS>
<SELECTCOLUMNLIST>
<COLUMN>
<NAME></NAME>
</COLUMN>
</SELECTCOLUMNLIST>
<FILTERLIST>
<CONDITION>
<NAME></NAME>
<VALUE></VALUE>
<OPERATOR></OPERATOR>
</CONDITION>
</FILTERLIST>
</ONEDATA_REQUEST>
Input XML Parameters
REPOSITORYID
Optional. ID of the repository in which the entity or the table resides. If you do not provide the ID, the ID of the first repository from the list of available repositories is used by default. This parameter is case sensitive.
ENTITYNAME
Optional. Logical name of the object in OneData. (Required if TABLENAME is not provided.)
TABLENAME
Optional. Physical table name in the database. (Required if ENTITYNAME is not provided.)
CLIENTID
Optional. Client ID if more than one client is defined in the metadata.
PROJECTID
Optional. Project ID if more than one project is defined for the client in the metadata.
SCHEMAID
Optional. Whether the data is retrieved from the work area or the release area where there is a dual schema landscape.
USERID
PASSWORD
Optional. ID/ service layer security password of the user calling this web service. Required if service layer security is enabled.
SELECTALLCOLUMNS
Optional. Whether to include all the columns in the output. Setting the value to:
*true. Includes all columns.
*false. Includes only those columns specified inside COLUMN tag.
SELECTCOLUMNLIST
COLUMN
NAME
Optional. Columns to list in the output when SELECTALLCOLUMNS is set to false. Output includes only those columns specified in the COLUMN tag. Each COLUMN tag must have one NAME tag indicating the name of the column.
FILTERLIST
CONDITION
NAME
VALUE
OPERATOR
Optional. FILTERLIST narrows the output based on the CONDITION. Each CONDITION must contain NAME (Column Name), VALUE (Column Value), OPERATOR (IN, NOT IN, <, >, <=, >=, =). Multiple CONDITION tags will result in ANDing between them. If IN or NOT IN is used as OPERATOR, there can be multiple VALUE tags within CONDITION tag, each one containing one value to be used in the IN or NOT IN clause.

Copyright © 2011-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release