Component Overview JSON Create Template

Flow Location

C:\VIPTDM\ParseXMLJSon\json_to_template

Submit through Executor Form

No

Use as part of models and TDA

Yes

Used in Solutions

Template

Operation – JSON Create Template 1 – Initial scan

Parse JSon to get a control file.

Parameters

Parameter

Description

Internal

parJSonFilePath

The path to the input Json.Example input:"C:\VIPTDM\ParseXMLJSon\json_to_template\POSTPet.json"

N

parCSvPathControl

This is the control filePath that controls where files are output . The user may specify a folder where the output control csv is "parCSvPathControl /control_[input filename].csv" or just specify the full csv filePath for output using this parameter.
Example input:
"C:\VIPTDM\ParseXMLJSon\json_to_template\"
or
"C:\VIPTDM\ParseXMLJSon\json_to_template\control_POSTPet.csv"

y

parMode

"parse" because we are doing the initial scan.


Table 1: Parameters for JSON Create Template 1 – Initial Scan solution.

Output Data

A control file looks like this:

Figure 1: Control file

How to use the Component for creation of Control File

Firstly the parameters must be populated as shown in Table 1 . Then a user can run the process from VipExecutor/TemplateManagement/JSON Create Template – 1 – Initial Scan. The user also  needs to provide the JSON example file. This is shown in Figure 2.

Figure 2: UI for the example file entry.
 
After execution, the Control file is returned like in Figure 1 and is also created in the parCSvPathControl file path.

Operation – JSON Create Template 2 – Create Template

Use Json input file with Control file to get a Template file from the original Json.

Parameters

Parameter

Description

Internal

parJSonFilePath

The path to the JSON.Example input:"C:\VIPTDM\ParseXMLJSon\json_to_template\POSTPet.json"

N

parVariationType

Do we want to take data values with csv or use parameters
Example input: "csv" or "parms"

y

parCSvPathControl

This is the control filePath that control files are read from/to. The user must specify the full csv file path to read from.
Example input:
"C:\VIPTDM\ParseXMLJSon\json_to_template\control_POSTPet.csv"

y

parTemplateFilePath

This is the filepath where the template is output. The user must populate this with a folder and the created template will have the path folder/[input filename].template.

y

Table 2: Parameters for JSON Create Template 2 solution.

Output Data

The output data is a  template file like this:

Figure 3 : Example template

How to Use the component for creation of template

Firstly, the parameters must be populated as shown in Table 2 . Then a user can run the process from VipExecutor/TemplateManagement/JSON Create Template – 2. The user needs to provide the JSON example file and control csv file shown in Figure 4.

Figure 4: UI for the example file entry.

After execution, a template file like the one in Figure 3 is returned and also created in parTemplateFilePath.