Six Stars

Convert Json data to csv format

Hi All,

 

I have my input as json file and I need to convert the same as csv format. Could you please help me on the same?

Can we use tExtractJSONFields ? 

 

Thanks in advance

6 REPLIES
Moderator

Re: Convert Json data to csv format

Hello,

The tExtractJSONFields component is used to extract the desired data from JSON fields based on the JSONPath or XPath query and tFileInputJson component is used to extract JSON data from a file and transfer the data to a file, a database table, etc.

Could you please elaborate your case with an example with input and expected output values?

 

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Convert Json data to csv format

I will be receiving a Json file which contains details of 40 odd fields. I need to accept the JSON file and convert it to a csv file. The csv file must be uploaded to a particular site.
Ten Stars

Re: Convert Json data to csv format

tFileInputJson component is used to extract JSON data from a Json file.

Manohar B
Six Stars

Re: Convert Json data to csv format

So i should use the tFileInputJson to extract the desired fields from the Json file and in the components section of the same, I must mention JsonPath as Read By and the csv Filename and path should be mentioned in the Filename section right?
Ten Stars

Re: Convert Json data to csv format

Yes

Manohar B
Ten Stars

Re: Convert Json data to csv format

is your issue fixed?

Manohar B