2.2 Table to JSON Utility

The Table to JSON utility creates a JSON according to the configurations specified by a user. The user can define the JSON structure and the JSON fields to be constructed, and indicate where each field data is available. Once the field values are provided, the utility creates the JSON according to the specified configurations and picks the values against each field defined during configuration.

Note:

The utility can support only two levels of the array in the JSON. To see an example, see Viewing JSON. Examples are also provided in the Oracle Financial Services Know Your Customer Service Guide..

The Table to JSON utility is used in KYC to perform the following tasks:

• Prepare the inputs of the third-party verifications to be provided as a part of the onboarding service. The JSONs can vary based on data such as country, data sources, and customer type. Ready-to-use mappings have been created to use this JSON.
• Prepare the input JSON for the onboarding service. This JSON is then provided as a response for KYC Onboarding.
• Create risk assesments.
• Prepare the input for Customer Screening (CS).
• Prepare the input of the internal watch list.

The Table to JSON utility is used in Enterprise Case Management (ECM) to perform the following tasks:

• Generate the JSON response for the Common Gateway service.
• Generate the JSON response, which will be available in the KYC setup.

Note:

The Table to JSON utility must only be used in conjunction with the Financial Crime and Compliance Management (FCCM) application packs. Usage with any external applications is not allowed.