how to convert json data to csv file??

Highlighted
Six Stars

how to convert json data to csv file??

convert the json data to csv file. Data is having columns and inside the columns there is multiple fields. How to separate the fields to new colummsn.

 

Attached the file. Please let me know how to resolve this kind of problem.

"custom":{
"dimensions":[
{
"MessageType":"EventLog"
},
{
"Properties":"{\"user_AuthenticatedId\":\"17ada230-cd74-419a-971d-0a2f5c2a5518\",\"connectionState\":\"Online\",\"userName\":\"Sab Girish Parampoor\",\"pageUrl\":\"iOS - LoginViewController\",\"crmInstanceID\":\"e7ff6042-a8b8-e811-a974-000d3af4aec4\",\"timestamp\":\"2018-11-09 02:40:26 +0000\",\"pageDuration\":\"0\"}"
},
{
"AppBuild":"1.4.06"
},
{
"AppId":"30317700-3947-429b-9b10-887e463bcad6"
},

 

Properties column is having multiple fields. I need to separate fields to new columns.

 

 

 


Accepted Solutions
Employee

Re: how to convert json data to csv file??

@Ait_nn

 

Please refer the below job flow for the solution.

image.pngJob flow

 

 

The details of the components are as below.

image.pngtFileInputJSON

 

image.pngtExtractJSONFields

 

 

Hope I have answered your query :-)

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

 

 

 

 


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

All Replies
Employee

Re: how to convert json data to csv file??

@Ait_nn

 

Please refer the below job flow for the solution.

image.pngJob flow

 

 

The details of the components are as below.

image.pngtFileInputJSON

 

image.pngtExtractJSONFields

 

 

Hope I have answered your query :-)

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

 

 

 

 


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
Six Stars

Re: how to convert json data to csv file??

Actually columns like MessageType,propeties and other columns keeps on changing. its a dynamic columns. I can give the array position number in the path.

 

 

Employee

Re: how to convert json data to csv file??

Hi,

 

    According to the business logic, you will have to make necessary arrangements. That I wold say you to try it by yourself :-)

 

   Community can help you to show the initial path. After that its your role to convert the path to super highway :-)

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
Employee

Re: how to convert json data to csv file??

@Ait_nn

 

     Could you please mark the topic as resolved since your original query has been answered? It is a way of appreciation given to our fellow members for spending their time to resolve your query in between their own busy schedules.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.