3.1.3 fcc_tpg_table_json_query_params

This table contains the request parameters used by the queries in the fcc_tpg_table_json_query table.

To view the table values, run the following query:

select * from fcc_tpg_table_json_query_param where mapping_id = ‘parent_mapping_id value’;

The following table describes the values as follows:

Table 3-3 fcc_tpg_table_json_query_params Table

Value Name	Description
Mapping ID	Mapping IDs are used in queries to construct a JSON. Each table has a mapping ID assigned to it and is case-sensitive. For example, TEST_ARRAY_ENH1. Mapping IDs are unique for every JSON which is constructed.
Parent Field	Parent of the key that is generated in the JSON. The parent field of the first layer of keys must be kept as a parent in this field.
Parameter Order	Order of the parameter within the WHERE clause of the previous table. The ? values will replace values in the WHERE clause in this order. For example, if the WHERE clause is where ob_cust_seq_id = ? and request_id = ?, the first ? is replaced by the value of the parameter with order 1.
Parameter Name	Name of the query parameter that will be passed through the URL.
Parameter Source	Source of the parameter. REQUEST is the only supported value now.

After the configurations are done, enter the URL for the JSON in the POSTMAN client based on the following format:

http://domain:port/ TabletoJSONService/createtabletojson?mappingId= ” ”