3.1.2 fcc_tpg_table_json_query

This table contains the FROM and WHERE clauses of the queries used to construct the JSON. This table has to be updated for each mapping to reflect the FROM and WHERE clauses.

To view the table values, run the following query:

select * from fcc_tpg_table_json_query where mapping_id = ‘parent_mapping_id value’

The following describes the values as follows.

Table 3-2 fcc_tpg_table_json_query Table

Value Name	Description
Mapping ID	This field captures the mapping IDs which are case-sensitive. This mapping ID has to be the same as the previous table mapping ID.
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.
From Clause	FROM clause of the query that provides the data for the JSON. It should be defined at the parent level whenever we need to define a mapping ID.
Where Clause	WHERE clause of the query that provides the data for the JSON. There should only be one record being returned for the OBJECT and ELEMENT types. ARRAYS may have one or more records, and each of those records will become a separate ARRAY element. It should be defined at the parent level, and every time, we need to pass request parameters for the URL and replace the question mark.
Foreign Key	Provides the foreign key for the child array element. Each child array value in the Field has a corresponding Related Mapping ID. You must define the foreign key for that child array. The default is null.