Post by tharun reddy Post by Franzw Post by tharun reddy Post by email@example.com Post by tharun reddy
how to parse the json data to csv file in TDI
Use the File Connector with the CSV Parser.
But there is one array on json how to parse and get that values
Go to Eddie's blog and take a crsh course on XML/JSON - for your specific problem this is probably here you can start (but recommendation is to go through all 6 parts - and probably read the whole lot :-)) : http://www.tdiingoutloud.com/2016/11/json-and-xml-tutorial-part-4-json.html
there is no array on json data what u share the link
this is the data what i have
If you want to parse a JSON object to an Entry (e.g. for writing out to a file or other target) use the Entry classes's static fromJSON() and toJSON() methods (notice the capitalization that differentiates these fromt he built-in functions). So if you have a JSON string in a variable called jsonStr you can turn this into any Entry like this:
myEntry = com.ibm.di.entry.Entry.fromJSON(jsonStr);
There are more examples in my blog post series.