JSON Create Template

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.