3.1.1 fcc_tpg_table_json_mapping

This table allows you to configure the JSON constructed by the utility and is the first table that needs to be configured. Use this table to perform the following tasks:

• Configure the structure of the JSON
• Indicate whether the value of the JSON is from a column in the table or a user input
• Configure the value of the JSON field
• Configure the data type of the field or array of the JSON. To view the table values, run the following query:

select * from fcc_tpg_table_json_mapping where mapping_id ='parent_mapping_id value';

The following table describes the values as follows.

Table 3-1 fcc_tpg_table_json_mapping 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.
Key	A unique key is assigned for every mapping ID which is generated.
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. For the second layer of keys, the parent field is the field in the first layer of keys.
Field	This field captures the exact label of the field name generated in the JSON.
Field Type	This field captures the field type. The types can be ELEMENT, OBJECT, or ARRAY
Field Data Type	This field captures the field data type of the JSON. The default is STRING. Other acceptable values are STRING, NUMBER, and BOOLEAN.
Array Data Type	This field captures the array data type. The default is OBJECT (JSON object). Other acceptable values are OBJECT, STRING, NUMBER, and BOOLEAN.
Data Source	The data source has to be either TABLE or REQUEST. The data source is TABLE if the value comes from a table or expression. The data source is REQUEST if the value comes from the request parameters. For information on the request parameters, see the Oracle Financial Services Know Your Customer Service Guide. Oracle Financial Services Know Your Customer Service Guide
Table Name	This field captures the name of each table that contains the JSON field values. This has to be only in the schema where the web services are deployed. If the field’s value is not available in a table, then this will be blank. If the value is static, then this value can be provided in the Expression column. The table name must have the physical table name as defined in the database.
Column Name	This field captures the physical name of the column corresponding to the table, which contains the field values of the JSON.
Expression	SQL expression that generates the field value. It overrides the Table Name and Column Name fields. It must be as is from the SQL query that generates the value. For example, in the case of SELECT SampleValue FROM DUAL, the expression field would be SampleValue. In the case of SELECT UPPER(TABLE_NAME.COLUMN_NAME) from CUST, the expression field would be UPPER(TABLE_NAME.COLUMN_NAME).
Key Source	Provide the key source value as REQUEST to make a particular JSON field value dynamic. This means that the key is substituted by the value of the request parameters in the URL.
Related Mapping ID	Provides the mapping ID for the child array element inside the parent array. Each child array value in Field has a corresponding Related Mapping ID. The default of Related Mapping ID is null.
Primary Key	Provides the primary key for the parent array element. For each parent array value in Parent Field, there is a corresponding Mapping ID. The default is null.