Hi Mayank,
I imagine that JSON inside a CSV might be fraught with challenges. We do not support JSON generally at the moment but it is something we are investigating for inclusion onto the roadmap.
I would look at ways of pre-processing the JSON to get into a supported format. Of course, it is worth testing to see if the CSV idea works.
Regards,
Gary