title: Turn JSON large files into tab delimited flat file
body: <p>I currently have a vendor that provides API json format files and they need to be converted into a flat file so I can load them into SQL server. Below is a row (1 of over 700K+ rows) from the JSON file.  </p>
  
  <p>I will need to import all the files from a directory on my C:\Users\Lumen\Documents\APIfiles_fromvendor\test.json.</p>
  
  <p>Any help will be appreciated as I am learning at the moment.</p>
  
  <p>Below is the sample:</p>
  
  <pre><code> {
     "vendornameoutput":[
        {
           "stores":{
              "offers":[
                 {
                    "avgRating":0.0,
                    "userRatings":0,
                    "fulfilledBy":"",
                    "availability":"IN_STOCK",
                    "listPrice":128.88,
                    "maxRating":0,
                    "salePrice":128.88,
                    "upcs":[
  
                    ],
                    "imageUrl":"http://d2dddpb.JPG",
                    "shippingText":"This item ships free!",
                    "mpns":[
                       "723fdads32"
                    ],
                    "seller":"",
                    "cartPrice":false,
                    "addOnItem":false,
                    "productUrl":"http://www.zoyyyyr.com",
                    "salesRank":0,
                    "usedOffers":0,
                    "priceHistoryAvailable":true,
                    "lastRecordedAt":1441326319301,
                    "buyBoxWinner":false,
                    "newOffers":0,
                    "sku":"212120G319514518571",
                    "refurbishedOffers":0,
                    "additionalImageUrls":[
  
                    ]
                 },
                 {
                    "avgRating":0.0,
                    "userRatings":0,
                    "fulfilledBy":"",
                    "availability":"IN_STOCK",
                    "listPrice":128.88,
                    "maxRating":0,
                    "salePrice":128.88,
                    "upcs":[
  
                    ],
                    "imageUrl":"http://d2pbmlo3fAS01.JPG",
                    "shippingText":"This item ships free!",
                    "mpns":[
                       "72fsdfg5332"
                    ],
                    "seller":"",
                    "cartPrice":false,
                    "addOnItem":false,
                    "productUrl":"http://www.zddodadfaryyyo.com/i/G3198dfasa571/?category=9668",
                    "salesRank":0,
                    "usedOffers":0,
                    "priceHistoryAvailable":true,
                    "lastRecordedAt":1429844879892,
                    "buyBoxWinner":false,
                    "newOffers":0,
                    "sku":"ddadG3dasd198ddds571",
                    "refurbishedOffers":0,
                    "additionalImageUrls":[
  
                    ]
                 }
              ],
              "storeId":2656,
              "storeName":"testsite",
              "title":"Pump Gun Only, For Use With 1ED22 Oiler"
           },
           "mpns":[
              "72ddd332"
           ],
           "imageUrl":"http://d2ulldddda/Z_HJFvfo5oy.JPG",
           "categoryName":"Hand Tools",
           "brandName":"Ridgid",
           "categoryIdPath":"10167 &gt; 16031 &gt; 16032",
           "categoryNamePath":"Tools &amp; Home Improvement &gt; Power &amp; Hand Tools &gt; Hand Tools",
           "brandId":19970,
           "title":"Pump Gun Only, For Use With 1EDffsad22 Oiler",
           "categoryId":16032,
           "upcs":[
  
           ],
           "currency":"USD",
           "mpid":"0fb1f23c94c3bc7928ee72f9880a2174",
           "countryCode":"US",
           "lastRecordedAt":1442922991002,
           "storesCount":6,
           "offersCount":10,
           "maxSalePrice":280.75,
           "minSalePrice":128.88
        }
     ]
  }
  </code></pre>