Skip to main content
Question

Convert nested JSON into csv


How can I convert a nested json into a csv file? Could you show with exact settings for the stages?

5 replies

mikelsr
StreamSets Employee
  • StreamSets Employee
  • 5 replies
  • May 31, 2022

Hi @ana00159,

 

I’ve combined the answers provided by @Marty Norris in this thread and @AkshayJadhav in this other thread into a complete pipeline that generates a JSON object and writes to a CSV file. The pipeline may need to be adapted to your specific use-case, but it might serve as an example. You can find the pipeline attached to this message.

 

Best regards,

 

 


  • Author
  • Discovered Fame
  • 11 replies
  • June 1, 2022

Thank you @mikelsr. I will take a look at the pipeline attached and keep you updated.


  • Author
  • Discovered Fame
  • 11 replies
  • June 1, 2022

I am getting below error when trying to import the job. The selected pipeline file doesn't contain library definitions. Please export the pipeline using "Export for SCH" instead of "Export" in your Data Collector.


mikelsr
StreamSets Employee
  • StreamSets Employee
  • 5 replies
  • June 1, 2022

Hi @ana00159 ,

 

I didn’t export the pipeline properly, my bad. I have checked that the one attached to this message works, but I’ll keep an eye in case you have any issues.

 

Best regards,


  • Author
  • Discovered Fame
  • 11 replies
  • June 1, 2022

Thank you @mikelsr. Able to import the job.


Reply