Procedure - Cloud - 8.0

JSON

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > File components (Integration) > JSON components
Data Quality and Preparation > Third-party systems > File components (Integration) > JSON components
Design and Development > Third-party systems > File components (Integration) > JSON components

Procedure

  1. Drop a tRowGenerator and a tFileOutputJSON component onto the workspace from the Palette.
  2. Link the components using a Row > Main connection.
  3. Double-click tRowGenerator to define its Basic Settings properties in the Component view.
  4. Click [...] next to Edit Schema to display the corresponding dialog box and define the schema.
  5. Click [+] to add the number of columns desired.
  6. Under Columns type in the column names.
  7. Under Type, select the data type from the list.
  8. Click OK to close the dialog box.
  9. Click [+] next to RowGenerator Editor to open the corresponding dialog box.
  10. Under Functions, select pre-defined functions for the columns, if required, or select [...] to set customized function parameters in the Function parameters tab.
  11. Enter the number of rows to be generated in the corresponding field.
  12. Click OK to close the dialog box.
  13. Click tFileOutputJSON to set its Basic Settings properties in the Component view.
  14. Click [...] to browse to where you want the output JSON file to be generated and enter the file name.
  15. Enter a name for the data block to be generated in the corresponding field, between double quotation marks.
  16. Select Built-In as the Schema type.
  17. Click Sync Columns to retrieve the schema from the preceding component.
  18. Press F6 to run the Job.

Results

The data from the input schema is written in a JSON structured data block in the output file.