6 Replies Latest reply on Dec 13, 2016 3:29 PM by obb64

    Parsing JSON file

    Tom_Droz

      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": []

                }

              ]

            }

          ]

        }

      }