How to create a lot of test data fast in JSON or CSV format?

During testing, you need test data, a lot of data. There is one tool that can be very helpful for you. You can use dynamic variables to fill the value for each field. When you save the template you can also use this schema to mock your API. If you have any questions on how to use this tool, post a comment I’ll provide the link with the working solution. https://www.mockaroo.com/

Below are some examples of files that can be created using this application.

JSON format:

[
   {
     "DUFAJN_PL": 1,
     "first_name": "Stanley",
     "last_name": "Yakushkin",
     "email": "syakushkin0@hp.com",
     "gender": "Male",
     "avatar": "http://dummyimage.com/121x105.bmp/cc0000/ffffff"
   },
   {
     "DUFAJN_PL": 2,
     "first_name": "Retha",
     "last_name": "Redfearn",
     "email": "rredfearn1@prnewswire.com",
     "gender": "Female",
     "avatar": "http://dummyimage.com/108x210.jpg/ff4444/ffffff"
   },
   {
     "DUFAJN_PL": 3,
     "first_name": "Quintus",
     "last_name": "Burgher",
     "email": "qburgher2@jiathis.com",
     "gender": "Male",
     "avatar": "http://dummyimage.com/105x215.png/cc0000/ffffff"
   },
   {
     "DUFAJN_PL": 4,
     "first_name": "Anthony",
     "last_name": "de Banke",
     "email": "adebanke3@upenn.edu",
     "gender": "Male",
     "avatar": "http://dummyimage.com/221x145.bmp/ff4444/ffffff"
   },
   {
     "DUFAJN_PL": 5,
     "first_name": "Darn",
     "last_name": "Sutton",
     "email": "dsutton4@sfgate.com",
     "gender": "Male",
     "avatar": "http://dummyimage.com/143x231.jpg/cc0000/ffffff"
   },
   {
     "DUFAJN_PL": 6,
     "first_name": "Leann",
     "last_name": "Shurey",
     "email": "lshurey5@sogou.com",
     "gender": "Female",
     "avatar": "http://dummyimage.com/249x105.png/ff4444/ffffff"
   },
   {
     "DUFAJN_PL": 7,
     "first_name": "Carlota",
     "last_name": "Croan",
     "email": "ccroan6@si.edu",
     "gender": "Female",
     "avatar": "http://dummyimage.com/113x239.jpg/5fa2dd/ffffff"
   },
   {
     "DUFAJN_PL": 8,
     "first_name": "Tuck",
     "last_name": "Rosekilly",
     "email": "trosekilly7@deliciousdays.com",
     "gender": "Male",
     "avatar": "http://dummyimage.com/125x236.png/cc0000/ffffff"
   }
 ]

CSV format:

DUFAJN_PL,first_name,last_name,email,gender,avatar 1,Patrick,Grason,pgrason0@ucoz.ru,Male,http://dummyimage.com/160x169.png/dddddd/000000 2,Heath,Connikie,hconnikie1@myspace.com,Female,http://dummyimage.com/189x143.png/5fa2dd/ffffff 3,Obadiah,Horsburgh,ohorsburgh2@merriam-webster.com,Male,http://dummyimage.com/154x177.jpg/cc0000/ffffff 4,Mill,Goldspink,mgoldspink3@vk.com,Male,http://dummyimage.com/223x194.bmp/5fa2dd/ffffff 5,Ursola,Kiossel,ukiossel4@cbslocal.com,Female,http://dummyimage.com/176x169.png/cc0000/ffffff 6,Edsel,Remnant,eremnant5@cnbc.com,Male,http://dummyimage.com/151x149.png/ff4444/ffffff 7,Lew,Kilbane,lkilbane6@flavors.me,Male,http://dummyimage.com/110x240.png/cc0000/ffffff 8,Sol,Yurenev,syurenev7@issuu.com,Male,http://dummyimage.com/169x235.bmp/5fa2dd/ffffff 

XML format:

<?xml version="1.0" encoding="UTF-8"?>
<dataset>
  <record>
    <DUFAJN_PL>1</DUFAJN_PL>
    <first_name>Zachariah</first_name>
    <last_name>Penhaleurack</last_name>
    <email>zpenhaleurack0@tinyurl.com</email>
    <gender>Male</gender>
    <avatar>http://dummyimage.com/155x249.bmp/ff4444/ffffff</avatar>
  </record>
  <record>
    <DUFAJN_PL>2</DUFAJN_PL>
    <first_name>Genia</first_name>
    <last_name>Howood</last_name>
    <email>ghowood1@ftc.gov</email>
    <gender>Female</gender>
    <avatar>http://dummyimage.com/138x130.png/cc0000/ffffff</avatar>
  </record>
  <record>
    <DUFAJN_PL>3</DUFAJN_PL>
    <first_name>Torry</first_name>
    <last_name>Jowsey</last_name>
    <email>tjowsey2@usatoday.com</email>
    <gender>Male</gender>
    <avatar>http://dummyimage.com/101x214.jpg/5fa2dd/ffffff</avatar>
  </record>
  <record>
    <DUFAJN_PL>4</DUFAJN_PL>
    <first_name>Annadiane</first_name>
    <last_name>Proffer</last_name>
    <email>aproffer3@stanford.edu</email>
    <gender>Female</gender>
    <avatar>http://dummyimage.com/134x133.bmp/ff4444/ffffff</avatar>
  </record>
  <record>
    <DUFAJN_PL>5</DUFAJN_PL>
    <first_name>Carlie</first_name>
    <last_name>Firle</last_name>
    <email>cfirle4@cargocollective.com</email>
    <gender>Male</gender>
    <avatar>http://dummyimage.com/102x240.jpg/dddddd/000000</avatar>
  </record>
  <record>
    <DUFAJN_PL>6</DUFAJN_PL>
    <first_name>Luelle</first_name>
    <last_name>Rogers</last_name>
    <email>lrogers5@edublogs.org</email>
    <gender>Female</gender>
    <avatar>http://dummyimage.com/229x125.png/ff4444/ffffff</avatar>
  </record>
  <record>
    <DUFAJN_PL>7</DUFAJN_PL>
    <first_name>Lanni</first_name>
    <last_name>Kewley</last_name>
    <email>lkewley6@engadget.com</email>
    <gender>Female</gender>
    <avatar>http://dummyimage.com/104x248.bmp/ff4444/ffffff</avatar>
  </record>
  <record>
    <DUFAJN_PL>8</DUFAJN_PL>
    <first_name>Holmes</first_name>
    <last_name>Springham</last_name>
    <email>hspringham7@wordpress.com</email>
    <gender>Male</gender>
    <avatar>http://dummyimage.com/160x243.jpg/5fa2dd/ffffff</avatar>
  </record>
</dataset>

Other supported formats are tab-delimited, SQL, Cassandra CQL, Firebase, Excel, XML, DBUnit XML.