EDAMAM API - Initial setup, registration, sending a POST request and testing invalid input.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# API requiring registration - POST request"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Registering to the API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# We will use a nutritional analysis API\n",
    "# It requires registration (we need an API key to validate ourselves)\n",
    "# Many APIs require this kind of registration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# You can sign-up for the Developer (Free) edition here: \n",
    "#        https://developer.edamam.com/edamam-nutrition-api\n",
    "\n",
    "# API documentation: \n",
    "#        https://developer.edamam.com/edamam-docs-nutrition-api"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Initial Setup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# loading the packages\n",
    "import requests\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Store the ID and Key in variables\n",
    "\n",
    "APP_ID = \"a48f7959\"\n",
    "APP_KEY = \"e174c1803b9f3f53b1532e5fb4448f0c\"\n",
    "\n",
    "# Note: Those are not real ID and Key,\n",
    "# Replace the string with your own ones that you recieved upon registration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Setting up the request URL\n",
    "api_endpoint = \"https://api.edamam.com/api/nutrition-details\"\n",
    "\n",
    "url = api_endpoint + \"?app_id=\" + APP_ID + \"&app_key=\" + APP_KEY"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Sending a POST request"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Defining the header (as stated in the documentation)\n",
    "headers = {\n",
    "    'Content-type': 'application/json'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Defining the payload of the request (the data we actually want processed)\n",
    "recipe = {\n",
    "    'title': 'Cappuccino',\n",
    "    'ingr': ['18g ground espresso (or 1 espresso pod)', '150ml milk']\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "200"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Submitting a POST request\n",
    "r = requests.post(url, headers = headers, json = recipe)\n",
    "r.status_code"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inspecting the response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"uri\": \"http://www.edamam.com/ontologies/edamam.owl#recipe_d2a8368fa908407a9c100a52b3ebe4ba\",\n",
      "    \"yield\": 2.0,\n",
      "    \"calories\": 95,\n",
      "    \"totalWeight\": 172.69915386093172,\n",
      "    \"dietLabels\": [],\n",
      "    \"healthLabels\": [\n",
      "        \"SUGAR_CONSCIOUS\",\n",
      "        \"VEGETARIAN\",\n",
      "        \"PEANUT_FREE\",\n",
      "        \"TREE_NUT_FREE\",\n",
      "        \"ALCOHOL_FREE\",\n",
      "        \"SULPHITE_FREE\"\n",
      "    ],\n",
      "    \"cautions\": [\n",
      "        \"SULFITES\"\n",
      "    ],\n",
      "    \"totalNutrients\": {\n",
      "        \"ENERC_KCAL\": {\n",
      "            \"label\": \"Energy\",\n",
      "            \"quantity\": 95.98648385516834,\n",
      "            \"unit\": \"kcal\"\n",
      "        },\n",
      "        \"FAT\": {\n",
      "            \"label\": \"Fat\",\n",
      "            \"quantity\": 5.060122500480281,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FASAT\": {\n",
      "            \"label\": \"Saturated\",\n",
      "            \"quantity\": 2.9016992195063764,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FATRN\": {\n",
      "            \"label\": \"Trans\",\n",
      "            \"quantity\": 0.0,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FAMS\": {\n",
      "            \"label\": \"Monounsaturated\",\n",
      "            \"quantity\": 1.2561571293507656,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FAPU\": {\n",
      "            \"label\": \"Polyunsaturated\",\n",
      "            \"quantity\": 0.31822335002881685,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"CHOCDF\": {\n",
      "            \"label\": \"Carbs\",\n",
      "            \"quantity\": 7.726159385324722,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FIBTG\": {\n",
      "            \"label\": \"Fiber\",\n",
      "            \"quantity\": 0.0,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"SUGAR\": {\n",
      "            \"label\": \"Sugars\",\n",
      "            \"quantity\": 7.812307269977051,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"PROCNT\": {\n",
      "            \"label\": \"Protein\",\n",
      "            \"quantity\": 4.894623346619349,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"CHOLE\": {\n",
      "            \"label\": \"Cholesterol\",\n",
      "            \"quantity\": 15.469915386093172,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"NA\": {\n",
      "            \"label\": \"Sodium\",\n",
      "            \"quantity\": 69.04063616020063,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"CA\": {\n",
      "            \"label\": \"Calcium\",\n",
      "            \"quantity\": 175.17004386285285,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"MG\": {\n",
      "            \"label\": \"Magnesium\",\n",
      "            \"quantity\": 29.86991538609317,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"K\": {\n",
      "            \"label\": \"Potassium\",\n",
      "            \"quantity\": 224.90288309642986,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"FE\": {\n",
      "            \"label\": \"Iron\",\n",
      "            \"quantity\": 0.06980974615827952,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"ZN\": {\n",
      "            \"label\": \"Zinc\",\n",
      "            \"quantity\": 0.5813868692854474,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"P\": {\n",
      "            \"label\": \"Phosphorus\",\n",
      "            \"quantity\": 131.20728924318263,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"VITA_RAE\": {\n",
      "            \"label\": \"Vitamin A\",\n",
      "            \"quantity\": 71.1616107760286,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"VITC\": {\n",
      "            \"label\": \"Vitamin C\",\n",
      "            \"quantity\": 0.036,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"THIA\": {\n",
      "            \"label\": \"Thiamin (B1)\",\n",
      "            \"quantity\": 0.07134161077602859,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"RIBF\": {\n",
      "            \"label\": \"Riboflavin (B2)\",\n",
      "            \"quantity\": 0.2933015700249746,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"NIA\": {\n",
      "            \"label\": \"Niacin (B3)\",\n",
      "            \"quantity\": 1.0749422469362293,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"VITB6A\": {\n",
      "            \"label\": \"Vitamin B6\",\n",
      "            \"quantity\": 0.056051695389935416,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"FOLDFE\": {\n",
      "            \"label\": \"Folate equivalent (total)\",\n",
      "            \"quantity\": 7.914957693046586,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"FOLFD\": {\n",
      "            \"label\": \"Folate (food)\",\n",
      "            \"quantity\": 7.914957693046586,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"FOLAC\": {\n",
      "            \"label\": \"Folic acid\",\n",
      "            \"quantity\": 0.0,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"VITB12\": {\n",
      "            \"label\": \"Vitamin B12\",\n",
      "            \"quantity\": 0.6961461923741927,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"VITD\": {\n",
      "            \"label\": \"Vitamin D\",\n",
      "            \"quantity\": 78.89656846907518,\n",
      "            \"unit\": \"IU\"\n",
      "        },\n",
      "        \"TOCPHA\": {\n",
      "            \"label\": \"Vitamin E\",\n",
      "            \"quantity\": 0.1100894077026522,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"VITK1\": {\n",
      "            \"label\": \"Vitamin K\",\n",
      "            \"quantity\": 0.48209746158279515,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"WATER\": {\n",
      "            \"label\": \"Water\",\n",
      "            \"quantity\": 153.94036429763912,\n",
      "            \"unit\": \"g\"\n",
      "        }\n",
      "    },\n",
      "    \"totalDaily\": {\n",
      "        \"ENERC_KCAL\": {\n",
      "            \"label\": \"Energy\",\n",
      "            \"quantity\": 4.799324192758418,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FAT\": {\n",
      "            \"label\": \"Fat\",\n",
      "            \"quantity\": 7.78480384689274,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FASAT\": {\n",
      "            \"label\": \"Saturated\",\n",
      "            \"quantity\": 14.508496097531884,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"CHOCDF\": {\n",
      "            \"label\": \"Carbs\",\n",
      "            \"quantity\": 2.5753864617749076,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FIBTG\": {\n",
      "            \"label\": \"Fiber\",\n",
      "            \"quantity\": 0.0,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"PROCNT\": {\n",
      "            \"label\": \"Protein\",\n",
      "            \"quantity\": 9.789246693238699,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"CHOLE\": {\n",
      "            \"label\": \"Cholesterol\",\n",
      "            \"quantity\": 5.156638462031057,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"NA\": {\n",
      "            \"label\": \"Sodium\",\n",
      "            \"quantity\": 2.8766931733416934,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"CA\": {\n",
      "            \"label\": \"Calcium\",\n",
      "            \"quantity\": 17.517004386285283,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"MG\": {\n",
      "            \"label\": \"Magnesium\",\n",
      "            \"quantity\": 7.11188461573647,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"K\": {\n",
      "            \"label\": \"Potassium\",\n",
      "            \"quantity\": 4.785167725455954,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FE\": {\n",
      "            \"label\": \"Iron\",\n",
      "            \"quantity\": 0.3878319231015529,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"ZN\": {\n",
      "            \"label\": \"Zinc\",\n",
      "            \"quantity\": 5.285335175322249,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"P\": {\n",
      "            \"label\": \"Phosphorus\",\n",
      "            \"quantity\": 18.743898463311805,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITA_RAE\": {\n",
      "            \"label\": \"Vitamin A\",\n",
      "            \"quantity\": 7.906845641780954,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITC\": {\n",
      "            \"label\": \"Vitamin C\",\n",
      "            \"quantity\": 0.039999999999999994,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"THIA\": {\n",
      "            \"label\": \"Thiamin (B1)\",\n",
      "            \"quantity\": 5.945134231335716,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"RIBF\": {\n",
      "            \"label\": \"Riboflavin (B2)\",\n",
      "            \"quantity\": 22.561659232690353,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"NIA\": {\n",
      "            \"label\": \"Niacin (B3)\",\n",
      "            \"quantity\": 6.718389043351433,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITB6A\": {\n",
      "            \"label\": \"Vitamin B6\",\n",
      "            \"quantity\": 4.311668876148878,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FOLDFE\": {\n",
      "            \"label\": \"Folate equivalent (total)\",\n",
      "            \"quantity\": 1.9787394232616464,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITB12\": {\n",
      "            \"label\": \"Vitamin B12\",\n",
      "            \"quantity\": 29.0060913489247,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITD\": {\n",
      "            \"label\": \"Vitamin D\",\n",
      "            \"quantity\": 525.9771231271678,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"TOCPHA\": {\n",
      "            \"label\": \"Vitamin E\",\n",
      "            \"quantity\": 0.733929384684348,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITK1\": {\n",
      "            \"label\": \"Vitamin K\",\n",
      "            \"quantity\": 0.4017478846523293,\n",
      "            \"unit\": \"%\"\n",
      "        }\n",
      "    },\n",
      "    \"totalNutrientsKCal\": {\n",
      "        \"ENERC_KCAL\": {\n",
      "            \"label\": \"Energy\",\n",
      "            \"quantity\": 97,\n",
      "            \"unit\": \"kcal\"\n",
      "        },\n",
      "        \"PROCNT_KCAL\": {\n",
      "            \"label\": \"Calories from protein\",\n",
      "            \"quantity\": 20,\n",
      "            \"unit\": \"kcal\"\n",
      "        },\n",
      "        \"FAT_KCAL\": {\n",
      "            \"label\": \"Calories from fat\",\n",
      "            \"quantity\": 46,\n",
      "            \"unit\": \"kcal\"\n",
      "        },\n",
      "        \"CHOCDF_KCAL\": {\n",
      "            \"label\": \"Calories from carbohydrates\",\n",
      "            \"quantity\": 31,\n",
      "            \"unit\": \"kcal\"\n",
      "        }\n",
      "    }\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "capp_info = r.json()\n",
    "print(json.dumps(capp_info, indent = 4))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['uri', 'yield', 'calories', 'totalWeight', 'dietLabels', 'healthLabels', 'cautions', 'totalNutrients', 'totalDaily', 'totalNutrientsKCal'])"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#There is a lot of info contained in this JSON\n",
    "capp_info.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"ENERC_KCAL\": {\n",
      "        \"label\": \"Energy\",\n",
      "        \"quantity\": 95.98648385516834,\n",
      "        \"unit\": \"kcal\"\n",
      "    },\n",
      "    \"FAT\": {\n",
      "        \"label\": \"Fat\",\n",
      "        \"quantity\": 5.060122500480281,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FASAT\": {\n",
      "        \"label\": \"Saturated\",\n",
      "        \"quantity\": 2.9016992195063764,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FATRN\": {\n",
      "        \"label\": \"Trans\",\n",
      "        \"quantity\": 0.0,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FAMS\": {\n",
      "        \"label\": \"Monounsaturated\",\n",
      "        \"quantity\": 1.2561571293507656,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FAPU\": {\n",
      "        \"label\": \"Polyunsaturated\",\n",
      "        \"quantity\": 0.31822335002881685,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"CHOCDF\": {\n",
      "        \"label\": \"Carbs\",\n",
      "        \"quantity\": 7.726159385324722,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FIBTG\": {\n",
      "        \"label\": \"Fiber\",\n",
      "        \"quantity\": 0.0,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"SUGAR\": {\n",
      "        \"label\": \"Sugars\",\n",
      "        \"quantity\": 7.812307269977051,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"PROCNT\": {\n",
      "        \"label\": \"Protein\",\n",
      "        \"quantity\": 4.894623346619349,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"CHOLE\": {\n",
      "        \"label\": \"Cholesterol\",\n",
      "        \"quantity\": 15.469915386093172,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"NA\": {\n",
      "        \"label\": \"Sodium\",\n",
      "        \"quantity\": 69.04063616020063,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"CA\": {\n",
      "        \"label\": \"Calcium\",\n",
      "        \"quantity\": 175.17004386285285,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"MG\": {\n",
      "        \"label\": \"Magnesium\",\n",
      "        \"quantity\": 29.86991538609317,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"K\": {\n",
      "        \"label\": \"Potassium\",\n",
      "        \"quantity\": 224.90288309642986,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"FE\": {\n",
      "        \"label\": \"Iron\",\n",
      "        \"quantity\": 0.06980974615827952,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"ZN\": {\n",
      "        \"label\": \"Zinc\",\n",
      "        \"quantity\": 0.5813868692854474,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"P\": {\n",
      "        \"label\": \"Phosphorus\",\n",
      "        \"quantity\": 131.20728924318263,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"VITA_RAE\": {\n",
      "        \"label\": \"Vitamin A\",\n",
      "        \"quantity\": 71.1616107760286,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"VITC\": {\n",
      "        \"label\": \"Vitamin C\",\n",
      "        \"quantity\": 0.036,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"THIA\": {\n",
      "        \"label\": \"Thiamin (B1)\",\n",
      "        \"quantity\": 0.07134161077602859,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"RIBF\": {\n",
      "        \"label\": \"Riboflavin (B2)\",\n",
      "        \"quantity\": 0.2933015700249746,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"NIA\": {\n",
      "        \"label\": \"Niacin (B3)\",\n",
      "        \"quantity\": 1.0749422469362293,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"VITB6A\": {\n",
      "        \"label\": \"Vitamin B6\",\n",
      "        \"quantity\": 0.056051695389935416,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"FOLDFE\": {\n",
      "        \"label\": \"Folate equivalent (total)\",\n",
      "        \"quantity\": 7.914957693046586,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"FOLFD\": {\n",
      "        \"label\": \"Folate (food)\",\n",
      "        \"quantity\": 7.914957693046586,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"FOLAC\": {\n",
      "        \"label\": \"Folic acid\",\n",
      "        \"quantity\": 0.0,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"VITB12\": {\n",
      "        \"label\": \"Vitamin B12\",\n",
      "        \"quantity\": 0.6961461923741927,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"VITD\": {\n",
      "        \"label\": \"Vitamin D\",\n",
      "        \"quantity\": 78.89656846907518,\n",
      "        \"unit\": \"IU\"\n",
      "    },\n",
      "    \"TOCPHA\": {\n",
      "        \"label\": \"Vitamin E\",\n",
      "        \"quantity\": 0.1100894077026522,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"VITK1\": {\n",
      "        \"label\": \"Vitamin K\",\n",
      "        \"quantity\": 0.48209746158279515,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"WATER\": {\n",
      "        \"label\": \"Water\",\n",
      "        \"quantity\": 153.94036429763912,\n",
      "        \"unit\": \"g\"\n",
      "    }\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "#Let's check the 'totalNutrients' key\n",
    "print(json.dumps(capp_info['totalNutrients'], indent = 4))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'label': 'Sugars', 'quantity': 7.812307269977051, 'unit': 'g'}"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Taking the sugar content\n",
    "capp_info['totalNutrients']['SUGAR']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7.812307269977051"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Or going even deeper\n",
    "capp_info['totalNutrients']['SUGAR']['quantity']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Structuring and exporting data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ENERC_KCAL</th>\n",
       "      <th>FAT</th>\n",
       "      <th>FASAT</th>\n",
       "      <th>FATRN</th>\n",
       "      <th>FAMS</th>\n",
       "      <th>FAPU</th>\n",
       "      <th>CHOCDF</th>\n",
       "      <th>FIBTG</th>\n",
       "      <th>SUGAR</th>\n",
       "      <th>PROCNT</th>\n",
       "      <th>...</th>\n",
       "      <th>NIA</th>\n",
       "      <th>VITB6A</th>\n",
       "      <th>FOLDFE</th>\n",
       "      <th>FOLFD</th>\n",
       "      <th>FOLAC</th>\n",
       "      <th>VITB12</th>\n",
       "      <th>VITD</th>\n",
       "      <th>TOCPHA</th>\n",
       "      <th>VITK1</th>\n",
       "      <th>WATER</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>label</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Fat</td>\n",
       "      <td>Saturated</td>\n",
       "      <td>Trans</td>\n",
       "      <td>Monounsaturated</td>\n",
       "      <td>Polyunsaturated</td>\n",
       "      <td>Carbs</td>\n",
       "      <td>Fiber</td>\n",
       "      <td>Sugars</td>\n",
       "      <td>Protein</td>\n",
       "      <td>...</td>\n",
       "      <td>Niacin (B3)</td>\n",
       "      <td>Vitamin B6</td>\n",
       "      <td>Folate equivalent (total)</td>\n",
       "      <td>Folate (food)</td>\n",
       "      <td>Folic acid</td>\n",
       "      <td>Vitamin B12</td>\n",
       "      <td>Vitamin D</td>\n",
       "      <td>Vitamin E</td>\n",
       "      <td>Vitamin K</td>\n",
       "      <td>Water</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>quantity</td>\n",
       "      <td>95.9865</td>\n",
       "      <td>5.06012</td>\n",
       "      <td>2.9017</td>\n",
       "      <td>0</td>\n",
       "      <td>1.25616</td>\n",
       "      <td>0.318223</td>\n",
       "      <td>7.72616</td>\n",
       "      <td>0</td>\n",
       "      <td>7.81231</td>\n",
       "      <td>4.89462</td>\n",
       "      <td>...</td>\n",
       "      <td>1.07494</td>\n",
       "      <td>0.0560517</td>\n",
       "      <td>7.91496</td>\n",
       "      <td>7.91496</td>\n",
       "      <td>0</td>\n",
       "      <td>0.696146</td>\n",
       "      <td>78.8966</td>\n",
       "      <td>0.110089</td>\n",
       "      <td>0.482097</td>\n",
       "      <td>153.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>unit</td>\n",
       "      <td>kcal</td>\n",
       "      <td>g</td>\n",
       "      <td>g</td>\n",
       "      <td>g</td>\n",
       "      <td>g</td>\n",
       "      <td>g</td>\n",
       "      <td>g</td>\n",
       "      <td>g</td>\n",
       "      <td>g</td>\n",
       "      <td>g</td>\n",
       "      <td>...</td>\n",
       "      <td>mg</td>\n",
       "      <td>mg</td>\n",
       "      <td>µg</td>\n",
       "      <td>µg</td>\n",
       "      <td>µg</td>\n",
       "      <td>µg</td>\n",
       "      <td>IU</td>\n",
       "      <td>mg</td>\n",
       "      <td>µg</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         ENERC_KCAL      FAT      FASAT  FATRN             FAMS  \\\n",
       "label        Energy      Fat  Saturated  Trans  Monounsaturated   \n",
       "quantity    95.9865  5.06012     2.9017      0          1.25616   \n",
       "unit           kcal        g          g      g                g   \n",
       "\n",
       "                     FAPU   CHOCDF  FIBTG    SUGAR   PROCNT  ...          NIA  \\\n",
       "label     Polyunsaturated    Carbs  Fiber   Sugars  Protein  ...  Niacin (B3)   \n",
       "quantity         0.318223  7.72616      0  7.81231  4.89462  ...      1.07494   \n",
       "unit                    g        g      g        g        g  ...           mg   \n",
       "\n",
       "              VITB6A                     FOLDFE          FOLFD       FOLAC  \\\n",
       "label     Vitamin B6  Folate equivalent (total)  Folate (food)  Folic acid   \n",
       "quantity   0.0560517                    7.91496        7.91496           0   \n",
       "unit              mg                         µg             µg          µg   \n",
       "\n",
       "               VITB12       VITD     TOCPHA      VITK1   WATER  \n",
       "label     Vitamin B12  Vitamin D  Vitamin E  Vitamin K   Water  \n",
       "quantity     0.696146    78.8966   0.110089   0.482097  153.94  \n",
       "unit               µg         IU         mg         µg       g  \n",
       "\n",
       "[3 rows x 32 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Again, we can use a dataframe to more clearly represent the data\n",
    "import pandas as pd\n",
    "pd.DataFrame(capp_info['totalNutrients'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>label</th>\n",
       "      <th>quantity</th>\n",
       "      <th>unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>ENERC_KCAL</td>\n",
       "      <td>Energy</td>\n",
       "      <td>95.9865</td>\n",
       "      <td>kcal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FAT</td>\n",
       "      <td>Fat</td>\n",
       "      <td>5.06012</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FASAT</td>\n",
       "      <td>Saturated</td>\n",
       "      <td>2.9017</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FATRN</td>\n",
       "      <td>Trans</td>\n",
       "      <td>0</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FAMS</td>\n",
       "      <td>Monounsaturated</td>\n",
       "      <td>1.25616</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FAPU</td>\n",
       "      <td>Polyunsaturated</td>\n",
       "      <td>0.318223</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>CHOCDF</td>\n",
       "      <td>Carbs</td>\n",
       "      <td>7.72616</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FIBTG</td>\n",
       "      <td>Fiber</td>\n",
       "      <td>0</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SUGAR</td>\n",
       "      <td>Sugars</td>\n",
       "      <td>7.81231</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PROCNT</td>\n",
       "      <td>Protein</td>\n",
       "      <td>4.89462</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>CHOLE</td>\n",
       "      <td>Cholesterol</td>\n",
       "      <td>15.4699</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>NA</td>\n",
       "      <td>Sodium</td>\n",
       "      <td>69.0406</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>CA</td>\n",
       "      <td>Calcium</td>\n",
       "      <td>175.17</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>MG</td>\n",
       "      <td>Magnesium</td>\n",
       "      <td>29.8699</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K</td>\n",
       "      <td>Potassium</td>\n",
       "      <td>224.903</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FE</td>\n",
       "      <td>Iron</td>\n",
       "      <td>0.0698097</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>ZN</td>\n",
       "      <td>Zinc</td>\n",
       "      <td>0.581387</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>P</td>\n",
       "      <td>Phosphorus</td>\n",
       "      <td>131.207</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>VITA_RAE</td>\n",
       "      <td>Vitamin A</td>\n",
       "      <td>71.1616</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>VITC</td>\n",
       "      <td>Vitamin C</td>\n",
       "      <td>0.036</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>THIA</td>\n",
       "      <td>Thiamin (B1)</td>\n",
       "      <td>0.0713416</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>RIBF</td>\n",
       "      <td>Riboflavin (B2)</td>\n",
       "      <td>0.293302</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>NIA</td>\n",
       "      <td>Niacin (B3)</td>\n",
       "      <td>1.07494</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>VITB6A</td>\n",
       "      <td>Vitamin B6</td>\n",
       "      <td>0.0560517</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FOLDFE</td>\n",
       "      <td>Folate equivalent (total)</td>\n",
       "      <td>7.91496</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FOLFD</td>\n",
       "      <td>Folate (food)</td>\n",
       "      <td>7.91496</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FOLAC</td>\n",
       "      <td>Folic acid</td>\n",
       "      <td>0</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>VITB12</td>\n",
       "      <td>Vitamin B12</td>\n",
       "      <td>0.696146</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>VITD</td>\n",
       "      <td>Vitamin D</td>\n",
       "      <td>78.8966</td>\n",
       "      <td>IU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>TOCPHA</td>\n",
       "      <td>Vitamin E</td>\n",
       "      <td>0.110089</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>VITK1</td>\n",
       "      <td>Vitamin K</td>\n",
       "      <td>0.482097</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>WATER</td>\n",
       "      <td>Water</td>\n",
       "      <td>153.94</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                label   quantity  unit\n",
       "ENERC_KCAL                     Energy    95.9865  kcal\n",
       "FAT                               Fat    5.06012     g\n",
       "FASAT                       Saturated     2.9017     g\n",
       "FATRN                           Trans          0     g\n",
       "FAMS                  Monounsaturated    1.25616     g\n",
       "FAPU                  Polyunsaturated   0.318223     g\n",
       "CHOCDF                          Carbs    7.72616     g\n",
       "FIBTG                           Fiber          0     g\n",
       "SUGAR                          Sugars    7.81231     g\n",
       "PROCNT                        Protein    4.89462     g\n",
       "CHOLE                     Cholesterol    15.4699    mg\n",
       "NA                             Sodium    69.0406    mg\n",
       "CA                            Calcium     175.17    mg\n",
       "MG                          Magnesium    29.8699    mg\n",
       "K                           Potassium    224.903    mg\n",
       "FE                               Iron  0.0698097    mg\n",
       "ZN                               Zinc   0.581387    mg\n",
       "P                          Phosphorus    131.207    mg\n",
       "VITA_RAE                    Vitamin A    71.1616    µg\n",
       "VITC                        Vitamin C      0.036    mg\n",
       "THIA                     Thiamin (B1)  0.0713416    mg\n",
       "RIBF                  Riboflavin (B2)   0.293302    mg\n",
       "NIA                       Niacin (B3)    1.07494    mg\n",
       "VITB6A                     Vitamin B6  0.0560517    mg\n",
       "FOLDFE      Folate equivalent (total)    7.91496    µg\n",
       "FOLFD                   Folate (food)    7.91496    µg\n",
       "FOLAC                      Folic acid          0    µg\n",
       "VITB12                    Vitamin B12   0.696146    µg\n",
       "VITD                        Vitamin D    78.8966    IU\n",
       "TOCPHA                      Vitamin E   0.110089    mg\n",
       "VITK1                       Vitamin K   0.482097    µg\n",
       "WATER                           Water     153.94     g"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The vertical orientation seems more easier to read\n",
    "# We achieve that by rotating the dataframe with .transpose()\n",
    "capp_nutrients = pd.DataFrame(capp_info[\"totalNutrients\"]).transpose()\n",
    "capp_nutrients"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Exporting the nutrition values to a CSV file\n",
    "capp_nutrients.to_csv('Cappuccino_nutrients.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Testing invalid input\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Sending a request not containing the ingredients parameter\n",
    "cake = requests.post(url, headers = headers, json = {'title': 'Cheesecake'})\n",
    "cake.ok"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "555"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#This is not an official HTTP status code. But the one defined in the documentation of the API\n",
    "cake.status_code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'error': 'low_quality'}"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cake.json()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}