title: Parsed JSON in multiple columns
body: <p>I'm working on some API info collecting and I've written a program that reads the domains and looks up the API info and after it finds the info it puts the whole JSON text it made into a column in Microsoft SQL server table.</p>
  
  <p>This is how one of the JSON output looks:</p>
  
  <pre><code>    {
    "id": "3e3562a7-b160-4fd8-a190-8ca0a5288794",
    "name": "Garmin",
    "legalName": "Garmin Ltd.",
    "domain": "garmin.com",
    "domainAliases": [
      "garmin.de",
      "garmin.se",
      "garmin.si",
      "garmin.nl",
      "garmin.dk",
      "garmin.it",
      "garmin.fi",
      "garmin.no",
      "garmin.hr",
      "garmin.at",
      "garmin.pl",
      "garmin.cl",
      "garmin.com.au",
      "garmin.co.uk",
      "garmin.be",
      "garminconnect.com",
      "garmin.com.mx",
      "garminservice.de",
      "garmin.es",
      "garminasus.com",
      "garminonline.de",
      "opencaching.com",
      "garmin.com.br",
      "garmin.pt",
      "garminfrance.com",
      "garmin.ro",
      "garmin.com.hr",
      "garmin.com.ar",
      "garmin.ca",
      "inreachdelorme.com"
    ],
    "site": {
      "title": "Garmin International | Home",
      "h1": "NEW VIRB® 360",
      "metaDescription": "Delivering innovative GPS technology across diverse markets, including aviation, marine, fitness, outdoor recreation, tracking and mobile apps.",
      "metaAuthor": "Garmin",
      "phoneNumbers": [
        "+1 913-397-8200"
      ],
      "emailAddresses": [
        "domain.admin@garmin.com",
        "productsupport.privacy@garmin.com",
        "webmaster@garmin.com",
        "garminsecurity@garmin.com",
        "copyright@garmin.com"
      ]
    },
    "category": {
      "sector": "Information Technology",
      "industryGroup": "Software &amp; Services",
      "industry": "Internet Software &amp; Services",
      "subIndustry": "Internet Software &amp; Services",
      "sicCode": "3812",
      "naicsCode": null
    },
    "tags": [
      "Technology",
      "E-commerce",
      "Enterprise",
      "B2B",
      "B2C",
      "Consumer Discretionary",
      "Consumer Electronics"
    ],
    "description": "Delivering innovative GPS technology across diverse markets, including aviation, marine, fitness, outdoor recreation, tracking and mobile apps.",
    "foundedYear": 1989,
    "location": "Olathe, KS 66062, USA",
    "timeZone": "America/Chicago",
    "utcOffset": -5,
    "geo": {
      "streetNumber": null,
      "streetName": null,
      "subPremise": null,
      "city": "Olathe",
      "postalCode": "66062",
      "state": "Kansas",
      "stateCode": "KS",
      "country": "United States",
      "countryCode": "US",
      "lat": 38.8271089,
      "lng": -94.7898731
    },
    "logo": "https://logo.clearbit.com/garmin.com",
    "facebook": {
      "handle": "garmin",
      "likes": 1542748
    },
    "linkedin": {
      "handle": "company/garmin-international"
    },
    "twitter": {
      "handle": "Garmin",
      "id": "15324722",
      "followers": 136976,
      "following": 812,
      "location": "at Garmin HQ just outside KC",
    },
    "crunchbase": {
      "handle": "organization/garmin"
    },
    "emailProvider": false,
    "type": "public",
    "ticker": "GRMN",
    "phone": "+41 52 630 16 00",
    "metrics": {
      "alexaUsRank": 1094,
      "alexaGlobalRank": 1535,
      "googleRank": null,
      "employees": 10000,
      "employeesRange": "1000+",
      "marketCap": 9800000000,
      "raised": null,
      "annualRevenue": 3018665000,
      "fiscalYearEnd": 12
    },
    "indexedAt": "2017-07-06T02:54:05.626Z",
    "tech": [
      "centos",
      "akamai_dns",
      "apache",
      "outlook",
      "microsoft_office_365",
      "google_analytics",
      "microsoft_exchange_online",
      "debian",
      "tealium",
      "youtube",
      "recaptcha"
    ],
    "similarDomains": [
      "cerner.com",
      "delorme.com",
      "fitbit.com",
      "google.com",
      "gpscity.com",
      "lowrance.com",
      "magellangps.com",
      "novatel.com",
      "polar.com",
      "suunto.com",
      "thegpsstore.com",
      "trimble.com"
    ]
  }
  </code></pre>
  
  <p>Picture example:</p>
  
  <p><a href="https://i.stack.imgur.com/4UO5S.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4UO5S.png" alt="enter image description here"></a></p>
  
  <p>So what I need to do now is take only some of the data out like "Company name", "category" (with all sub-category info), "employees", "employeesrange", "marketcap", "annnualrevenue" and "similardomains" (this one should go as a full text column) and sort each one in its own column. I would be very happy for any help or directions I can get.</p>