AnsweredAssumed Answered

Parsing JSON file

Question asked by Tom_Droz on Jan 12, 2016
Latest reply on Dec 13, 2016 by obb64

I have JSON files from the internet that I am pulling in to FM via  "insert URL"  I then need to fill in fields in my solution based on the data.  Any thoughts on the best way to do this?

 

example data:

 

{

  "decode": {

    "vin": "JN1CV6EK3CM420718",

    "year": "2012",

    "make": "Infiniti",

    "series": "G Coupe",

    "trims": [

      {

        "name": "Sport 6MT",

        "items": [

          {

            "group": "Basic",

            "category": "Model Year",

            "value": "2012",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Make",

            "value": "Infiniti",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Series",

            "value": "G Coupe",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Trim Level",

            "value": "Sport 6MT",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Origin",

            "value": "JAPAN",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Body Type",

            "value": "COUPE 2-DR",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Engine Type",

            "value": "3.7L V6 DOHC 24V",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Transmission",

            "value": "6-Speed Manual",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Driveline",

            "value": "RWD",

            "unit": "",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "Fuel Tank",

            "value": "20.00",

            "unit": "gallon",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "MPG (city)",

            "value": "17",

            "unit": "miles/gallon",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "MPG (hwy)",

            "value": "25",

            "unit": "miles/gallon",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Anti-Brake System",

            "value": "4-Wheel ABS",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Steering Type",

            "value": "Rack & Pinion",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Front Brake Type",

            "value": "Disc",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Rear Brake Type",

            "value": "Disc",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Turning Diameter",

            "value": "36.10",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Front Suspension",

            "value": "Independent",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Rear Suspension",

            "value": "Independent",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Front Spring Type",

            "value": "Coil",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Rear Spring Type",

            "value": "Coil",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Tires",

            "value": "225/45R19",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Headroom",

            "value": "37.70",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Headroom",

            "value": "34.50",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Legroom",

            "value": "43.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Legroom",

            "value": "29.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Shoulder Room",

            "value": "53.70",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Shoulder Room",

            "value": "52.70",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Hip Room",

            "value": "53.40",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Hip Room",

            "value": "48.20",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Colors",

            "category": "Interior Trim",

            "value": "",

            "unit": "",

            "options": [

              {

                "value": "Graphite Leather Interior"

              },

              {

                "value": "Stone Leather Interior"

              }

            ]

          },

          {

            "group": "Colors",

            "category": "Exterior Color",

            "value": "",

            "unit": "",

            "options": [

              {

                "value": "Black Obsidian"

              },

              {

                "value": "Blue Slate"

              },

              {

                "value": "Graphite Shadow"

              },

              {

                "value": "Lapis Blue"

              },

              {

                "value": "Liquid Platinum"

              },

              {

                "value": "Moonlight White"

              },

              {

                "value": "Vibrant Red"

              }

            ]

          },

          {

            "group": "Dimensions",

            "category": "Length",

            "value": "183.70",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Width",

            "value": "71.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Height",

            "value": "54.90",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Wheelbase",

            "value": "112.20",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Ground Clearance",

            "value": "6.30",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Track Front",

            "value": "60.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Track Rear",

            "value": "61.40",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Standard Seating",

            "value": "4",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Passenger Volume",

            "value": "90.10",

            "unit": "cu.ft.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Cargo Volume",

            "value": "7.40",

            "unit": "cu.ft.",

            "options": []

          },

          {

            "group": "Weight",

            "category": "Standard Towing",

            "value": "1000",

            "unit": "lbs",

            "options": []

          },

          {

            "group": "Weight",

            "category": "Maximum Towing",

            "value": "1000",

            "unit": "lbs",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Basic (duration)",

            "value": "48",

            "unit": "month",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Basic (distance)",

            "value": "60,000",

            "unit": "mile",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Powertrain (duration)",

            "value": "72",

            "unit": "month",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Powertrain (distance)",

            "value": "70,000",

            "unit": "mile",

            "options": []

          },

          {

            "group": "Pricing",

            "category": "MSRP",

            "value": "$43,800",

            "unit": "USD",

            "options": []

          },

          {

            "group": "Pricing",

            "category": "Destination Charge",

            "value": "$895",

            "unit": "USD",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Power Door Locks",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Vehicle Anti-Theft",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "ABS Brakes",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Electronic Brake Assistance",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Limited Slip Differential",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Traction Control",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Vehicle Stability Control System",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Driver Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Front Side Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Passenger Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Side Head Curtain Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Electronic Parking Aid",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Trunk Anti-Trap Device",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Keyless Entry",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Comfort",

            "category": "Air Conditioning",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Comfort",

            "category": "Individual Climate Controls",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cruise Control",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tachometer",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tilt Steering",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tilt Steering Column",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Leather Steering Wheel",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Steering Wheel Mounted Controls",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Telescopic Steering Column",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Tire Pressure Monitor",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Trip Computer",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Entertainment",

            "category": "Navigation Aid",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Entertainment",

            "category": "Subwoofer",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Driver Multi-Adjustable Power Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Front Heated Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Front Power Lumbar Support",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Front Power Memory Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Leather Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Passenger Multi-Adjustable Power Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Second Row Folding Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cargo Area Tiedowns",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cargo Net",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Power Sunroof",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Manual Sunroof",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Lighting",

            "category": "Automatic Headlights",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Lighting",

            "category": "Fog Lights",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Lighting",

            "category": "High Intensity Discharge Headlights",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Front Air Dam",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Rear Spoiler",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Splash Guards",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Alloy Wheels",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Power Windows",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Heated Exterior Mirror",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Power Adjustable Exterior Mirror",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Interval Wipers",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Rear Window Defogger",

            "value": "Standard",

            "unit": "",

            "options": []

          }

        ]

      },

      {

        "name": "Journey",

        "items": [

          {

            "group": "Basic",

            "category": "Model Year",

            "value": "2012",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Make",

            "value": "Infiniti",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Series",

            "value": "G Coupe",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Trim Level",

            "value": "Journey",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Origin",

            "value": "JAPAN",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Body Type",

            "value": "COUPE 2-DR",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Engine Type",

            "value": "3.7L V6 DOHC 24V",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Transmission",

            "value": "5-Speed Automatic",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Driveline",

            "value": "RWD",

            "unit": "",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "Fuel Tank",

            "value": "20.00",

            "unit": "gallon",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "MPG (city)",

            "value": "19",

            "unit": "miles/gallon",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "MPG (hwy)",

            "value": "27",

            "unit": "miles/gallon",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Anti-Brake System",

            "value": "4-Wheel ABS",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Steering Type",

            "value": "Rack & Pinion",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Front Brake Type",

            "value": "Disc",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Rear Brake Type",

            "value": "Disc",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Turning Diameter",

            "value": "36.10",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Front Suspension",

            "value": "Independent",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Rear Suspension",

            "value": "Independent",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Front Spring Type",

            "value": "Coil",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Rear Spring Type",

            "value": "Coil",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Tires",

            "value": "225/50R18",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Headroom",

            "value": "39.40",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Headroom",

            "value": "34.50",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Legroom",

            "value": "43.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Legroom",

            "value": "29.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Shoulder Room",

            "value": "53.70",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Shoulder Room",

            "value": "52.70",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Hip Room",

            "value": "53.40",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Hip Room",

            "value": "48.20",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Colors",

            "category": "Interior Trim",

            "value": "",

            "unit": "",

            "options": [

              {

                "value": "Graphite Leather Interior"

              },

              {

                "value": "Stone Leather Interior"

              },

              {

                "value": "Wheat Leather Interior"

              }

            ]

          },

          {

            "group": "Colors",

            "category": "Exterior Color",

            "value": "",

            "unit": "",

            "options": [

              {

                "value": "Black Obsidian"

              },

              {

                "value": "Blue Slate"

              },

              {

                "value": "Graphite Shadow"

              },

              {

                "value": "Lapis Blue"

              },

              {

                "value": "Liquid Platinum"

              },

              {

                "value": "Moonlight White"

              },

              {

                "value": "Vibrant Red"

              }

            ]

          },

          {

            "group": "Weight",

            "category": "Curb Weight",

            "value": "3633",

            "unit": "lbs",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Length",

            "value": "183.10",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Width",

            "value": "71.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Height",

            "value": "54.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Wheelbase",

            "value": "112.20",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Ground Clearance",

            "value": "6.30",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Track Front",

            "value": "60.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Track Rear",

            "value": "61.40",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Standard Seating",

            "value": "4",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Passenger Volume",

            "value": "92.40",

            "unit": "cu.ft.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Cargo Volume",

            "value": "7.40",

            "unit": "cu.ft.",

            "options": []

          },

          {

            "group": "Weight",

            "category": "Standard Towing",

            "value": "1000",

            "unit": "lbs",

            "options": []

          },

          {

            "group": "Weight",

            "category": "Maximum Towing",

            "value": "1000",

            "unit": "lbs",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Basic (duration)",

            "value": "48",

            "unit": "month",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Basic (distance)",

            "value": "60,000",

            "unit": "mile",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Powertrain (duration)",

            "value": "72",

            "unit": "month",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Powertrain (distance)",

            "value": "70,000",

            "unit": "mile",

            "options": []

          },

          {

            "group": "Pricing",

            "category": "MSRP",

            "value": "$39,050",

            "unit": "USD",

            "options": []

          },

          {

            "group": "Pricing",

            "category": "Destination Charge",

            "value": "$895",

            "unit": "USD",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Power Door Locks",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Vehicle Anti-Theft",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "ABS Brakes",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Electronic Brake Assistance",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Limited Slip Differential",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Traction Control",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Vehicle Stability Control System",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Driver Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Front Side Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Passenger Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Side Head Curtain Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Electronic Parking Aid",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Trunk Anti-Trap Device",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Keyless Entry",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Comfort",

            "category": "Air Conditioning",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Comfort",

            "category": "Individual Climate Controls",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cruise Control",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tachometer",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tilt Steering",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tilt Steering Column",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Leather Steering Wheel",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Steering Wheel Mounted Controls",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Telescopic Steering Column",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Genuine Wood Trim",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Tire Pressure Monitor",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Trip Computer",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Entertainment",

            "category": "Navigation Aid",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Entertainment",

            "category": "Subwoofer",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Driver Multi-Adjustable Power Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Front Heated Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Front Power Lumbar Support",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Front Power Memory Seat",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Leather Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Passenger Multi-Adjustable Power Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Second Row Folding Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cargo Area Tiedowns",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cargo Net",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Power Sunroof",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Manual Sunroof",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Lighting",

            "category": "Automatic Headlights",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Lighting",

            "category": "Fog Lights",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Lighting",

            "category": "High Intensity Discharge Headlights",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Front Air Dam",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Rear Spoiler",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Splash Guards",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Alloy Wheels",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Power Windows",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Heated Exterior Mirror",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Power Adjustable Exterior Mirror",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Interval Wipers",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Rain Sensing Wipers",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Rear Window Defogger",

            "value": "Standard",

            "unit": "",

            "options": []

          }

        ]

      },

      {

        "name": "Base",

        "items": [

          {

            "group": "Basic",

            "category": "Model Year",

            "value": "2012",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Make",

            "value": "Infiniti",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Series",

            "value": "G Coupe",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Trim Level",

            "value": "Base",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Origin",

            "value": "JAPAN",

            "unit": "",

            "options": []

          },

          {

            "group": "Basic",

            "category": "Body Type",

            "value": "COUPE 2-DR",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Engine Type",

            "value": "3.7L V6 DOHC 24V",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Transmission",

            "value": "5-Speed Automatic",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Driveline",

            "value": "RWD",

            "unit": "",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "Fuel Tank",

            "value": "20.00",

            "unit": "gallon",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "MPG (city)",

            "value": "19",

            "unit": "miles/gallon",

            "options": []

          },

          {

            "group": "Fuel",

            "category": "MPG (hwy)",

            "value": "27",

            "unit": "miles/gallon",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Anti-Brake System",

            "value": "4-Wheel ABS",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Steering Type",

            "value": "Rack & Pinion",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Front Brake Type",

            "value": "Disc",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Rear Brake Type",

            "value": "Disc",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Turning Diameter",

            "value": "36.10",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Front Suspension",

            "value": "Independent",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Rear Suspension",

            "value": "Independent",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Front Spring Type",

            "value": "Coil",

            "unit": "",

            "options": []

          },

          {

            "group": "Suspension",

            "category": "Rear Spring Type",

            "value": "Coil",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Tires",

            "value": "225/50R18",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Headroom",

            "value": "39.40",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Headroom",

            "value": "34.50",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Legroom",

            "value": "43.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Legroom",

            "value": "29.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Shoulder Room",

            "value": "53.70",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Shoulder Room",

            "value": "52.70",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Front Hip Room",

            "value": "53.40",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Rear Hip Room",

            "value": "48.20",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Colors",

            "category": "Interior Trim",

            "value": "",

            "unit": "",

            "options": [

              {

                "value": "Graphite Leather Interior"

              },

              {

                "value": "Stone Leather Interior"

              }

            ]

          },

          {

            "group": "Colors",

            "category": "Exterior Color",

            "value": "",

            "unit": "",

            "options": [

              {

                "value": "Black Obsidian"

              },

              {

                "value": "Blue Slate"

              },

              {

                "value": "Graphite Shadow"

              },

              {

                "value": "Lapis Blue"

              },

              {

                "value": "Liquid Platinum"

              },

              {

                "value": "Moonlight White"

              },

              {

                "value": "Vibrant Red"

              }

            ]

          },

          {

            "group": "Weight",

            "category": "Curb Weight",

            "value": "3633",

            "unit": "lbs",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Length",

            "value": "183.10",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Width",

            "value": "71.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Height",

            "value": "54.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Wheelbase",

            "value": "112.20",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Ground Clearance",

            "value": "6.30",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Track Front",

            "value": "60.80",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Track Rear",

            "value": "61.40",

            "unit": "in.",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Standard Seating",

            "value": "4",

            "unit": "",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Passenger Volume",

            "value": "92.40",

            "unit": "cu.ft.",

            "options": []

          },

          {

            "group": "Dimensions",

            "category": "Cargo Volume",

            "value": "7.40",

            "unit": "cu.ft.",

            "options": []

          },

          {

            "group": "Weight",

            "category": "Standard Towing",

            "value": "1000",

            "unit": "lbs",

            "options": []

          },

          {

            "group": "Weight",

            "category": "Maximum Towing",

            "value": "1000",

            "unit": "lbs",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Basic (duration)",

            "value": "48",

            "unit": "month",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Basic (distance)",

            "value": "60,000",

            "unit": "mile",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Powertrain (duration)",

            "value": "72",

            "unit": "month",

            "options": []

          },

          {

            "group": "Warranty",

            "category": "Powertrain (distance)",

            "value": "70,000",

            "unit": "mile",

            "options": []

          },

          {

            "group": "Pricing",

            "category": "MSRP",

            "value": "$37,600",

            "unit": "USD",

            "options": []

          },

          {

            "group": "Pricing",

            "category": "Destination Charge",

            "value": "$895",

            "unit": "USD",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Power Door Locks",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Vehicle Anti-Theft",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "ABS Brakes",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Braking",

            "category": "Electronic Brake Assistance",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Traction Control",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Drivetrain",

            "category": "Vehicle Stability Control System",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Driver Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Front Side Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Passenger Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Side Head Curtain Airbag",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Trunk Anti-Trap Device",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Safety",

            "category": "Keyless Entry",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Comfort",

            "category": "Air Conditioning",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cruise Control",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tachometer",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tilt Steering",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Tilt Steering Column",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Leather Steering Wheel",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Steering Wheel Mounted Controls",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Telescopic Steering Column",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Tire Pressure Monitor",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Trip Computer",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Driver Multi-Adjustable Power Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Leather Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Passenger Multi-Adjustable Power Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Seating",

            "category": "Second Row Folding Seat",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cargo Area Tiedowns",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Cargo Net",

            "value": "Optional",

            "unit": "",

            "options": []

          },

          {

            "group": "Lighting",

            "category": "Fog Lights",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Lighting",

            "category": "High Intensity Discharge Headlights",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Front Air Dam",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Wheels and Tires",

            "category": "Alloy Wheels",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Power Windows",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Power Adjustable Exterior Mirror",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Interval Wipers",

            "value": "Standard",

            "unit": "",

            "options": []

          },

          {

            "group": "Feature",

            "category": "Rear Window Defogger",

            "value": "Standard",

            "unit": "",

            "options": []

          }

        ]

      }

    ]

  }

}

Outcomes