Import issues using JSON format

Question

We usually import/update issues in bulk using the import csv format. Now we want to upload a textarea field, which has tabular data of below format:
||Header1||Header2|| so on
|Data1|Data2| so on
While importing in the form of csv, the data got imported but the 
 character did not work. This means the data got imported as below:
||Header1||Header2|| |Data1|Data2| which is then not rendered as table format.

I am trying to import as json, but getting the below error: Checked the json format online, its a valid json. But still the error:
None issues and projects imported.
Failed to create data bean

PFA the JSON format as shared on this link:
https://confluence.atlassian.com/adminjiraserver073/importing-data-from-json-861253756.html

Is there any alternate method to import the customfield with 
 in bulk?

Bill Sheboy · Answer

Hi @Pranita Warik

I saw a similar post about newline character processing and JSON or smart values in REST API calls.  The solution for that one was to use \n in place of just the newline.  Please try that syntax.

Best regards,

Bill

Pranita Warik · Answer

@Trudy P Claspill

Hello,

I exported an issue having the tabular data and used it as a template to import. Still the 
 character gets skipped.

Trudy P Claspill · Answer

I can't speak to your JSON issue, but have you tried exporting to CSV an issues that is already in JIRA that contains a tabular format, and then using that as a template for creating the CSV import data?