Overview:
- This document provides instructions to convert JSON data to CSV by using the SDC pipeline.
Configuration:
JSON to CSV converter pipeline looks as below way:
Directory Origin:
- This stage reads the employee JSON file from the input directory and provides the output as an array of JSON.
- The output of this stage looks as below way:
Field Pivoter:
- This stage converts the array of JSON to individual records.
- Here is the output of the stage:
Field Order:
- This stage converts the record root field 'MAP' to List-Map. So, that it is compatible with CSV records.
- If this stage is not used then you will see the below error message in destination:
DELIMITED_GENERATOR_00 - Record 'employee.json::0_1' root field should be List or List-Map instead of 'MAP'
LocalFs Destination:
- This stage places the data as CSV in the destination location.
Input JSON file:
Output CSV file:
