QAS_GETPROMPTTABLEVAL_REST_GET

Use this service operation to return a list of field values for a given prompt table.

Request Message: QAS_GETPROMPTTABLEVALUES_TEMPL

Element Name	Description
PromptTableName	Enter complete prompt record name. It is a required element.
FieldValue	Optional search string for the key field value. If no value is entered, a list of all key values will be returned. Note: Multiple keys are not supported in PS Query. Tables with no keys are not supported in PS Query.
MaxRows	Optionally, enter the maximum number of rows to be returned. MaxRows is a number of length 10 with a decimal position of 0.
json_response	Enter true for JSON response type; enter false for standard XML response. If no value is provided, then the default is standard the XML response.

Example 4-5 Example Request:

https://<servername>:<port>/PSIGW/RESTListeningConnector/<defaultlocal node>/PromptTableValues.v1/PSMSGSETDEFN?fieldvalue=&maxrows=1000

Example 4-6 Example of an URI template

{PromptTableName}?fieldvalue={FieldValue}&maxrows={MaxRows}&json_resp={json_response}

Response Message: QAS_GETPRMPTTBLVALUES_RESP_MSG

Element Name	Description
FieldValue	Field value.

Example Response:

<?xml version="1.0"?>
<QAS_GETPRMPTTBLVAL_RESP_MSG xmlns="http://xmlns.oracle.com/
Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP_MSG.VERSION_1">
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>1</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>2</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>3</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>4</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>5</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>6</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
        Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>7</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>8</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>9</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
    <QAS_GETPRMPTTBLVAL_RESP>
        <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
         Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
            <FieldValue>10</FieldValue>
        </PTQASFIELDWRK>
    </QAS_GETPRMPTTBLVAL_RESP>
</QAS_GETPRMPTTBLVAL_RESP_MSG>

Example response

When the parameter json_response is set to true:

{	"status": "success","data": {	"fieldValue": [	"1","2","3","4","5","6","7","8","9","10"]}}