Products (GET)

12.20 Products (GET)

Below mentioned are the custom fields. These fields will be part of response.

Table 12-18 Products

Element name	Sub element	Data type
CustomUserDefinedStringData	KeyName	String
	KeyValue	String
CustomUserDefinedNumberData	KeyName	String
	KeyValue	Number (Decimal)
CustomUserDefinedDateData	KeyName	String
	KeyValue	Date (YYYY-MM-DDTHH:MM:SS)

Sample XML

<Custom>
    <CustomUserDefinedStringData>
        <KeyName> StringName </KeyName>
        <KeyValue> StringValue </KeyValue>
    </CustomUserDefinedStringData>
    <CustomUserDefinedNumberData>
        <KeyName> NumberName </KeyName>
        <KeyValue> NumberValue </KeyValue>
    </CustomUserDefinedNumberData>
    <CustomUserDefinedDateData>
        <KeyName> DateName </KeyName>
        <KeyValue> DateValue</KeyValue>
    </CustomUserDefinedDateData>
</Custom>

Sample JSON

{
    "Custom": {
        "CustomUserDefinedStringData": {
            "KeyName": "StringName",
            "KeyValue": "StringValue"
        },
        "CustomUserDefinedNumberData": {
            "KeyName": "NumberName",
            "KeyValue": "NumberValue"
        },
        "CustomUserDefinedDateData": {
            "KeyName": "DateName",
            "KeyValue": "DateValue"
        }
    }
}

Below are the package details for products web service

Wrapper Engine package:-

xpdprc_ew_100_01.xpdprc_ew_100_01 (iv_req_rec_t IN xpd_req_rec_t, iv_res_rec_t IN OUT xpd_resp_rec_t);

Main Engine package:-

xpdprc_em_100_01.xpdprc_em_100_01 (iv_req_rec_t IN xpd_req_rec_t, iv_res_rec_t IN OUT xpd_resp_rec_t);

Below are the Exit point package details for xpdprc_em_100_01.xpdprc_em_100_01();

BEFORE:-

xpdprc_ex_100_01.cv_xpdprc_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
    xpdprc_ex_100_01.xpdprc_em_100_01_bfr (iv_req_rec_t, iv_res_rec_t);

REPLACE:-

xpdprc_ex_100_01.cv_xpdprc_rep = cmncon_cl_000_01.CUSTOMIZED THEN
    xpdprc_ex_100_01.xpdprc_em_100_01_rep (iv_req_rec_t, iv_res_rec_t);

AFTER:-

xpdprc_ex_100_01.cv_xpdprc_afr = cmncon_cl_000_01.CUSTOMIZED THEN
    xpdprc_ex_100_01.xpdprc_em_100_01_afr (iv_req_rec_t, iv_res_rec_t);

Extensible parameters are Tab Type object

CREATE OR REPLACE TYPE xws_att_str_rec_t AS OBJECT (
    ATT_NAME     VARCHAR2(30),
    ATT_VALUE    VARCHAR2(4000));
CREATE OR REPLACE TYPE xws_att_num_rec_t AS OBJECT (
    ATT_NAME     VARCHAR2(30),
    ATT_VALUE    NUMBER );
CREATE OR REPLACE TYPE xws_att_date_rec_t AS OBJECT (
    ATT_NAME     VARCHAR2(30),
    ATT_VALUE    DATE );

Parent topic: RESTful Web Services Extensibility