MOThistoryNotebook.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "803e9495-49a0-4f63-80d8-4426955298ae",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import json\n",
    "import pandas as pd\n",
    "import os\n",
    "import pprint\n",
    "import time\n",
    "\n",
    "# Configuration\n",
    "CLIENT_ID =\"wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww\"\n",
    "CLIENT_SECRET =\"wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww\"\n",
    "API_KEY =\"wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww\"\n",
    "AUTHORITY = \"https://login.microsoftonline.com/common\"  # Update as per your tenant\n",
    "SCOPE = [\"https://tapi.dvsa.gov.uk/.default\"]  # Define the API scope\n",
    "TOKEN_CACHE_FILE = \"token_cache.json\"  # Cache file for tokens\n",
    "MOT_HISTORY_URL = \"https://history.mot.api.gov.uk/v1/trade/vehicles/registration/\"\n",
    "TOKEN_URL =\"https://login.microsoftonline.com/wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwc/oauth2/v2.0/token\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "f3e925b2-3d1a-4083-856f-55d30cf1f517",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to fetch MOT history\n",
    "\n",
    "def get_cached_token():\n",
    "    \"\"\"\n",
    "    Retrieve the cached token from a file if it exists and is not expired.\n",
    "    \"\"\"\n",
    "    try:\n",
    "        with open(TOKEN_CACHE_FILE, \"r\") as file:\n",
    "            data = json.load(file)\n",
    "            if data[\"expiry\"] > time.time():\n",
    "                return data[\"access_token\"]\n",
    "    except (FileNotFoundError, KeyError, ValueError):\n",
    "        pass\n",
    "    return None\n",
    "\n",
    "def save_token_to_cache(access_token, expires_in):\n",
    "    \"\"\"\n",
    "    Save the token and its expiry time to a cache file.\n",
    "    \"\"\"\n",
    "    data = {\n",
    "        \"access_token\": access_token,\n",
    "        \"expiry\": time.time() + expires_in - 60,  # Subtract 60 seconds as a buffer from server expiry\n",
    "    }\n",
    "    with open(TOKEN_CACHE_FILE, \"w\") as file:\n",
    "        json.dump(data, file)\n",
    "\n",
    "def get_access_token():\n",
    "    \"\"\"\n",
    "    Retrieve a valid access token, either from the cache or by requesting a new one.\n",
    "    \"\"\"\n",
    "    # Check the cache\n",
    "    token = get_cached_token()\n",
    "    if token:\n",
    "        return token, True\n",
    "\n",
    "    # Request a new token\n",
    "    payload = {\n",
    "        \"grant_type\": \"client_credentials\",\n",
    "        \"client_id\": CLIENT_ID,\n",
    "        \"client_secret\": CLIENT_SECRET,\n",
    "        \"scope\": SCOPE,\n",
    "    }\n",
    "    headers = {\"Content-Type\": \"application/x-www-form-urlencoded\"}\n",
    "    response = requests.post(TOKEN_URL, data=payload, headers=headers)\n",
    "\n",
    "    if response.status_code == 200:\n",
    "        token_data = response.json()\n",
    "        save_token_to_cache(token_data[\"access_token\"], token_data[\"expires_in\"])\n",
    "        return token_data[\"access_token\"], False\n",
    "    else:\n",
    "        raise Exception(f\"Failed to fetch access token: {response.status_code} - {response.text}\")\n",
    "\n",
    "\n",
    "\n",
    "def get_mot_history(access_token,registration):\n",
    "    \"\"\"\n",
    "    Query the MOT history API for a given vehicle registration.\n",
    "    \"\"\"\n",
    "   \n",
    "    headers = {\n",
    "        \"Authorization\": f\"Bearer {access_token}\",\n",
    "        \"x-api-key\": API_KEY,\n",
    "    }\n",
    "    url = MOT_HISTORY_URL + registration\n",
    "\n",
    "    response = requests.get(url, headers=headers)\n",
    "\n",
    "    if response.status_code == 200:\n",
    "        #with open(TEMP_JSON_FILE, \"w\") as file1:\n",
    "        #    json.dump(response.json(), file1)\n",
    "        \n",
    "        return response.json()\n",
    "    else:\n",
    "        raise Exception(\n",
    "            f\"Failed to fetch MOT history: {response.status_code} - {response.text}\"\n",
    "        )\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "9ee0170a-f2ff-40c6-818e-2384309c901b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "used online token\n",
      "EA12HLK\n",
      "----------------------------------------------------------------------\n",
      "{'engineSize': '2143',\n",
      " 'firstUsedDate': '2012-03-30',\n",
      " 'fuelType': 'Diesel',\n",
      " 'hasOutstandingRecall': 'Unknown',\n",
      " 'make': 'MERCEDES-BENZ',\n",
      " 'manufactureDate': '2012-03-30',\n",
      " 'model': 'C',\n",
      " 'motTests': [{'completedDate': '2024-09-24T11:14:43.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [],\n",
      "               'expiryDate': '2025-10-02',\n",
      "               'motTestNumber': '563751125728',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '111594',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2023-09-30T13:42:35.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [],\n",
      "               'expiryDate': '2024-10-02',\n",
      "               'motTestNumber': '526227857792',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '102557',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2023-09-30T08:43:06.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'Offside Front Suspension arm pin or bush '\n",
      "                                    'excessively worn (5.3.4 (a) (i))',\n",
      "                            'type': 'MAJOR'}],\n",
      "               'expiryDate': None,\n",
      "               'motTestNumber': '432613321216',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '102557',\n",
      "               'testResult': 'FAILED'},\n",
      "              {'completedDate': '2022-09-14T15:43:36.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'Nearside Rear Tyre worn close to legal '\n",
      "                                    'limit/worn on edge (5.2.3 (e))',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Front Brake pipe corroded, covered in '\n",
      "                                    'grease or other material (1.1.11 (c))',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Rear Brake pipe corroded, covered in '\n",
      "                                    'grease or other material (1.1.11 (c))',\n",
      "                            'type': 'ADVISORY'}],\n",
      "               'expiryDate': '2023-10-02',\n",
      "               'motTestNumber': '699251688226',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '95055',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2021-09-29T13:21:52.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'Nearside Front Outer Suspension arm ball '\n",
      "                                    'joint dust cover severely deteriorated '\n",
      "                                    '(5.3.4 (b) (i))',\n",
      "                            'type': 'MINOR'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Nearside Front Outer Tyre slightly '\n",
      "                                    'damaged/cracking or perishing (5.2.3 (d) '\n",
      "                                    '(ii))',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Nearside Rear Outer Tyre slightly '\n",
      "                                    'damaged/cracking or perishing (5.2.3 (d) '\n",
      "                                    '(ii))',\n",
      "                            'type': 'ADVISORY'}],\n",
      "               'expiryDate': '2022-10-02',\n",
      "               'motTestNumber': '716165261995',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '87697',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2020-09-25T15:56:35.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'Front Brake disc worn, pitted or scored, '\n",
      "                                    'but not seriously weakened (1.1.14 (a) '\n",
      "                                    '(ii))',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Rear Brake disc worn, pitted or scored, '\n",
      "                                    'but not seriously weakened (1.1.14 (a) '\n",
      "                                    '(ii))',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Offside Front Tyre worn close to legal '\n",
      "                                    'limit/worn on edge (5.2.3 (e))',\n",
      "                            'type': 'ADVISORY'}],\n",
      "               'expiryDate': '2021-10-02',\n",
      "               'motTestNumber': '757050019002',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '78107',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2019-10-03T09:28:38.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'front discs (lip',\n",
      "                            'type': 'ADVISORY'}],\n",
      "               'expiryDate': '2020-10-02',\n",
      "               'motTestNumber': '386048208696',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '71583',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2018-09-17T12:59:16.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [],\n",
      "               'expiryDate': '2019-09-25',\n",
      "               'motTestNumber': '337606558023',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '60063',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2017-09-19T09:24:53.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'Offside Rear Tyre worn close to the legal '\n",
      "                                    'limit (4.1.E.1)',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Brake pad(s) wearing thin All round '\n",
      "                                    '(3.5.1g)',\n",
      "                            'type': 'ADVISORY'}],\n",
      "               'expiryDate': '2018-09-25',\n",
      "               'motTestNumber': '756821795325',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '50532',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2016-09-26T15:46:23.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [],\n",
      "               'expiryDate': '2017-09-25',\n",
      "               'motTestNumber': '818161845000',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '41471',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2016-09-20T09:11:27.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'Offside Front Tyre tread depth below '\n",
      "                                    'requirements of 1.6mm (4.1.E.1)',\n",
      "                            'type': 'FAIL'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Nearside Front Tyre tread depth below '\n",
      "                                    'requirements of 1.6mm (4.1.E.1)',\n",
      "                            'type': 'FAIL'}],\n",
      "               'expiryDate': None,\n",
      "               'motTestNumber': '350419916976',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '41471',\n",
      "               'testResult': 'FAILED'},\n",
      "              {'completedDate': '2016-03-22T10:52:00.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'Both rear tyres getting low. nsr 2mm, osr '\n",
      "                                    '3mm',\n",
      "                            'type': 'ADVISORY'}],\n",
      "               'expiryDate': '2017-03-30',\n",
      "               'motTestNumber': '685101399725',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '36730',\n",
      "               'testResult': 'PASSED'},\n",
      "              {'completedDate': '2015-03-27T13:09:30.000Z',\n",
      "               'dataSource': 'DVSA',\n",
      "               'defects': [{'dangerous': False,\n",
      "                            'text': 'Front brake disc worn, pitted or scored, '\n",
      "                                    'but not seriously weakened (3.5.1i)',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Front Brake pad(s) wearing thin (3.5.1g)',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'Parking brake lever has little reserve '\n",
      "                                    'travel (3.1.6b)',\n",
      "                            'type': 'ADVISORY'},\n",
      "                           {'dangerous': False,\n",
      "                            'text': 'n/s/f inner tyre sidewall damaged',\n",
      "                            'type': 'USER ENTERED'}],\n",
      "               'expiryDate': '2016-03-30',\n",
      "               'motTestNumber': '467966585004',\n",
      "               'odometerResultType': 'READ',\n",
      "               'odometerUnit': 'MI',\n",
      "               'odometerValue': '27264',\n",
      "               'testResult': 'PASSED'}],\n",
      " 'primaryColour': 'White',\n",
      " 'registration': 'EA12HLK',\n",
      " 'registrationDate': '2012-03-30'}\n"
     ]
    }
   ],
   "source": [
    "registration = \"EA12HLK\"\n",
    "r=registration.strip().upper()\n",
    "#input(\"Enter vehicle registration number: \").strip().upper()        \n",
    "        # Get access token\n",
    "access_token, isCached = get_access_token()\n",
    "                # Fetch MOT history\n",
    "mot_history = get_mot_history(access_token, r)\n",
    "\n",
    "\n",
    "\n",
    "if isCached:\n",
    "    stat=\"cached\"\n",
    "else:\n",
    "    stat=\"online\"\n",
    "\n",
    "print(\"used \" + stat + \" token\")\n",
    "print(r)\n",
    "print(\"----------------------------------------------------------------------\")\n",
    "\n",
    "pp = pprint.PrettyPrinter()\n",
    "\n",
    "pp.pprint(mot_history)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "e7aa88a2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "EA12HLK\n"
     ]
    }
   ],
   "source": [
    "print(mot_history['registration'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "b5fae153",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "#type(mot_history)\n",
    "#k=mot_history.keys()\n",
    "#m=mot_history.get(\"motTests\")\n",
    "#print(m)\n",
    "OUTPUTDICTIONARY={}\n",
    "xn=-1\n",
    "for x, y in mot_history.items():  # iterate over the top level dictionary\n",
    "     if type(y)==str:         # ADD TO OUTPUT DICTIONARY IF VALUE IS STRING  \n",
    "      OUTPUTDICTIONARY[x]=y               \n",
    "     if type(y)==list:        # IF VALUE IS LIST, EACH LIST ELEMENT IS A DICT OBJECT SO WE ITERATE AGAIN OVER EACH DICT IN THE LIST\n",
    "      motTestCount=len(y)\n",
    "      for yy in y:\n",
    "          xn=xn+1\n",
    "          motTestCounter=motTestCount-xn\n",
    "          if type(yy)==dict:\n",
    "           an=0\n",
    "           for a, b in yy.items(): # ITERATE OVER DICT\n",
    "              if type(b)==str:\n",
    "                 OUTPUTDICTIONARY[x+str(motTestCounter)+\".\" + a]=b # ADD TO OUTPUT DICTIONARY              \n",
    "              elif type(b)==list:\n",
    "                 for bb in b:\n",
    "                   an=an+1\n",
    "                   if type(bb)==str:\n",
    "                        OUTPUTDICTIONARY[x+str(motTestCounter)+\".\" + a]=b\n",
    "                   elif type(bb)==dict:\n",
    "                      for aa, bbb in bb.items():\n",
    "                           OUTPUTDICTIONARY[x+str(motTestCounter)+\".\" + a+str(an)+\".\" + aa]=bbb\n",
    "                           \n",
    "              \n",
    "fname=mot_history['registration'] + '.xlsx'\n",
    "OUTPUTDATAFRAME = pd.DataFrame.from_dict(OUTPUTDICTIONARY,orient='index')\n",
    "OUTPUTDATAFRAME.to_excel(fname)\n",
    "#print(d)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "c88c65d3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "registration SD10KNS\n",
      "make LAND ROVER\n",
      "model DISCOVERY\n",
      "firstUsedDate 2010-03-30\n",
      "fuelType Diesel\n",
      "primaryColour Silver\n",
      "registrationDate 2010-03-30\n",
      "manufactureDate 2010-03-30\n",
      "engineSize 2993\n",
      "hasOutstandingRecall Unknown\n",
      "motTests [{'motTestNumber': '393037649774', 'completedDate': '2024-08-30T11:27:56.000Z', 'expiryDate': '2025-09-05', 'odometerValue': '82891', 'odometerUnit': 'MI', 'odometerResultType': 'READ', 'testResult': 'PASSED', 'dataSource': 'DVSA', 'defects': []}, {'motTestNumber': '589751055654', 'completedDate': '2023-08-24T10:28:26.000Z', 'expiryDate': '2024-09-05', 'odometerValue': '74944', 'odometerUnit': 'MI', 'odometerResultType': 'READ', 'testResult': 'PASSED', 'dataSource': 'DVSA', 'defects': [{'dangerous': False, 'text': 'under body slightly corroded', 'type': 'ADVISORY'}]}, {'motTestNumber': '739586855345', 'completedDate': '2022-09-06T16:04:29.000Z', 'expiryDate': '2023-09-05', 'odometerValue': '74643', 'odometerUnit': 'MI', 'odometerResultType': 'READ', 'testResult': 'PASSED', 'dataSource': 'DVSA', 'defects': [{'dangerous': False, 'text': 'Nearside Front Inner Drive shaft joint constant velocity boot severely deteriorated (6.1.7 (g) (i))', 'type': 'MINOR'}, {'dangerous': False, 'text': 'underside has surface corrosion', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Front Brake disc worn, pitted or scored, but not seriously weakened both (1.1.14 (a) (ii))', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Front Lower Suspension arm pin or bush worn but not resulting in excessive movement rear bush both sides (5.3.4 (a) (i))', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Rear Upper Suspension arm pin or bush worn but not resulting in excessive movement both sides (5.3.4 (a) (i))', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Rear Tyre worn close to legal limit/worn on edge both (5.2.3 (e))', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Front Tyre worn close to legal limit/worn on edge outer edges worn (5.2.3 (e))', 'type': 'ADVISORY'}]}, {'motTestNumber': '140628392274', 'completedDate': '2022-09-02T12:28:36.000Z', 'expiryDate': None, 'odometerValue': '74642', 'odometerUnit': 'MI', 'odometerResultType': 'READ', 'testResult': 'FAILED', 'dataSource': 'DVSA', 'defects': [{'dangerous': False, 'text': 'Rear Brake pad(s) worn down to wear indicator (1.1.13 (a) (i))', 'type': 'MAJOR'}, {'dangerous': False, 'text': 'Nearside Front Inner Drive shaft joint constant velocity boot severely deteriorated (6.1.7 (g) (i))', 'type': 'MINOR'}, {'dangerous': False, 'text': 'underside has surface corrosion', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Front Brake disc worn, pitted or scored, but not seriously weakened both (1.1.14 (a) (ii))', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Front Lower Suspension arm pin or bush worn but not resulting in excessive movement rear bush both sides (5.3.4 (a) (i))', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Rear Upper Suspension arm pin or bush worn but not resulting in excessive movement both sides (5.3.4 (a) (i))', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Rear Tyre worn close to legal limit/worn on edge both (5.2.3 (e))', 'type': 'ADVISORY'}, {'dangerous': False, 'text': 'Front Tyre worn close to legal limit/worn on edge outer edges worn (5.2.3 (e))', 'type': 'ADVISORY'}]}]\n"
     ]
    }
   ],
   "source": [
    "for x, y in mot_history.items():\n",
    "  print(x,y)\n",
    "\n",
    "for x in thisdict.values():"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "09fb665c",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "for x, obj in mot_history.items():\n",
    "  print(x)\n",
    "\n",
    "  for y in obj:\n",
    "    print(y + ':', obj[y])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ecf63d6a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['SD10KNS', 'LAND ROVER', 'DISCOVERY', '2010-03-30', 'Diesel', 'Silver', '2010-03-30', '2010-03-30', '2993', 'Unknown', '393037649774', '2024-08-30T11:27:56.000Z', '2025-09-05', '82891', 'MI', 'READ', 'PASSED', 'DVSA', '589751055654', '2023-08-24T10:28:26.000Z', '2024-09-05', '74944', 'MI', 'READ', 'PASSED', 'DVSA', False, 'under body slightly corroded', 'ADVISORY', '739586855345', '2022-09-06T16:04:29.000Z', '2023-09-05', '74643', 'MI', 'READ', 'PASSED', 'DVSA', False, 'Nearside Front Inner Drive shaft joint constant velocity boot severely deteriorated (6.1.7 (g) (i))', 'MINOR', False, 'underside has surface corrosion', 'ADVISORY', False, 'Front Brake disc worn, pitted or scored, but not seriously weakened both (1.1.14 (a) (ii))', 'ADVISORY', False, 'Front Lower Suspension arm pin or bush worn but not resulting in excessive movement rear bush both sides (5.3.4 (a) (i))', 'ADVISORY', False, 'Rear Upper Suspension arm pin or bush worn but not resulting in excessive movement both sides (5.3.4 (a) (i))', 'ADVISORY', False, 'Rear Tyre worn close to legal limit/worn on edge both (5.2.3 (e))', 'ADVISORY', False, 'Front Tyre worn close to legal limit/worn on edge outer edges worn (5.2.3 (e))', 'ADVISORY', '140628392274', '2022-09-02T12:28:36.000Z', None, '74642', 'MI', 'READ', 'FAILED', 'DVSA', False, 'Rear Brake pad(s) worn down to wear indicator (1.1.13 (a) (i))', 'MAJOR', False, 'Nearside Front Inner Drive shaft joint constant velocity boot severely deteriorated (6.1.7 (g) (i))', 'MINOR', False, 'underside has surface corrosion', 'ADVISORY', False, 'Front Brake disc worn, pitted or scored, but not seriously weakened both (1.1.14 (a) (ii))', 'ADVISORY', False, 'Front Lower Suspension arm pin or bush worn but not resulting in excessive movement rear bush both sides (5.3.4 (a) (i))', 'ADVISORY', False, 'Rear Upper Suspension arm pin or bush worn but not resulting in excessive movement both sides (5.3.4 (a) (i))', 'ADVISORY', False, 'Rear Tyre worn close to legal limit/worn on edge both (5.2.3 (e))', 'ADVISORY', False, 'Front Tyre worn close to legal limit/worn on edge outer edges worn (5.2.3 (e))', 'ADVISORY']\n"
     ]
    }
   ],
   "source": [
    "# Using recursion to get all values from nested dictionary\n",
    "def approach1Fn(d):\n",
    "    val = []\n",
    "\n",
    "    for v in d.values():\n",
    "        if isinstance(v, dict):\n",
    "            val.extend(approach1Fn(v))\n",
    "\n",
    "        elif isinstance(v, list):\n",
    "            for i in v:\n",
    "                if isinstance(i, dict):\n",
    "                    val.extend(approach1Fn(i))\n",
    "                else:\n",
    "                    val.append(i)\n",
    "        else:\n",
    "            val.append(v)\n",
    "    return val\n",
    "\n",
    "\n",
    "print(approach1Fn(mot_history))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "11280b06",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}