To create a new JSON data source, right-click on the Elements Tree and click New > Data source > JSON.
The Tool will display the dialog to create the data source.
The following data are requested in this dialog:
- Name. Name of the new data source.
- Data route. Path to the JSON file that contains the data. This path can be parameterized according to the query made using interpolation variables (see section Paths and Other Values with Interpolation Variables). The section Path Types in Virtual DataPort describes the formats of the available paths and how to use parameters in them. The most common path type in this case is HTTP client.
In the Metadata tab, you can set the folder where the data source will be stored and provide a description.
When editing the data source, you can also change its owner by clicking the button .
Click Save to create the data source.
After creating the data source, click Create base view to begin creating the base view. The Tool will display the “Configure JSON Wrapper” dialog where you can change the “tuple root” of the base view if you only want to access a portion of the JSON document.
We recommend leaving the JSON root check box selected and click Ok.
If the path to the data file includes interpolation variables, there is an intermediate step where you have to provide a value for these variables. See section Paths and Other Values with Interpolation Variables.
After this, the Tool will display the schema of the new base view. At this stage, you can do the following:
- Change the name of the view.
- Change the name of each field by double-clicking it and its type, by using the drop-down list to the right.
- Set the primary key of the new view (see the section Primary Keys of Views).
- In the Metadata tab, you can set the folder where the base view will be stored and provide a description.
- When editing the base view, you can also change its owner by clicking the button .
After this, click Save () to create the base view.
In the Elements Tree, double-click the new base view to display its schema (see section Creating Derived Views). Click Edit to modify the base view.