knotion_sandbox.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Knotion\n",
    "# Ravelry + Notion integration\n",
    "\n",
    "import requests\n",
    "import json\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 353,
   "metadata": {},
   "outputs": [],
   "source": [
    "config_path = \"config.json\"\n",
    "with open(config_path, 'r') as configfile:\n",
    "    config = json.load(configfile)\n",
    "\n",
    "KNOTION_TOKEN = config['auth']['KNOTION_TOKEN']\n",
    "DATABASE_ID = config['auth']['DATABASE_ID']\n",
    "\n",
    "RAVELRY_BASIC_AUTH_USERNAME = config['auth']['RAVELRY_BASIC_AUTH_USERNAME']\n",
    "RAVELRY_BASIC_AUTH_KEY = config['auth']['RAVELRY_BASIC_AUTH_KEY']\n",
    "RAVELRY_USERNAME = config['auth']['RAVELRY_USERNAME']"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Notion API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 361,
   "metadata": {},
   "outputs": [],
   "source": [
    "class NotionDB:\n",
    "    def __init__(self,DATABASE_ID,KNOTION_TOKEN):        \n",
    "        self.DATABASE_ID = DATABASE_ID\n",
    "        self.KNOTION_TOKEN = KNOTION_TOKEN\n",
    "\n",
    "        headers = {\n",
    "            \"Authorization\": \"Bearer \" + KNOTION_TOKEN,\n",
    "            \"accept\": \"application/json\",\n",
    "            \"Notion-Version\": \"2022-06-28\",\n",
    "            \"content-type\": \"application/json\",\n",
    "\n",
    "        }\n",
    "\n",
    "        self.headers = headers\n",
    "\n",
    "        def queryNotionDatabase(DATABASE_ID,KNOTION_TOKEN, headers):\n",
    "            readURL = f'https://api.notion.com/v1/databases/{DATABASE_ID}/query'\n",
    "            return requests.request(\"POST\", readUrl, headers=headers)\n",
    "\n",
    "        def readNotionDatabase( DATABASE_ID,KNOTION_TOKEN,headers):\n",
    "            readURL = f'https://api.notion.com/v1/databases/{DATABASE_ID}'\n",
    "            return requests.request(\"GET\", readURL, headers=headers)\n",
    "\n",
    "\n",
    "        self.db = queryNotionDatabase(DATABASE_ID,KNOTION_TOKEN,headers)\n",
    "        self.meta = readNotionDatabase(DATABASE_ID,KNOTION_TOKEN,headers)\n",
    "\n",
    "    def to_pandas(self):\n",
    "        r_json = notion.db.json()\n",
    "        self.df = pd.DataFrame(pd.json_normalize(r_json['results']))\n",
    "        return self.df\n",
    "\n",
    "    def check_notion(self):\n",
    "        # check if knotion db is already set up (has the correct properties)\n",
    "        if not hasattr(self, 'properties'):\n",
    "            self.get_properties()\n",
    "        prop_current = notion.properties\n",
    "        prop_missing = {}\n",
    "        for k in config['properties'].keys():\n",
    "            if k in notion.properties.keys():\n",
    "                if  notion.properties[k]['type'] != config['properties'][k]['type']:\n",
    "                    prop_missing[k] = config['properties'][k]\n",
    "                    prop_missing[k]['description'] = \"type\"\n",
    "            else:\n",
    "                prop_missing[k] = config['properties'][k]\n",
    "                prop_missing[k]['description'] = \"property\"\n",
    "        return prop_missing\n",
    "\n",
    "    def setup_notion(self):\n",
    "        # set up knotion Notion Database\n",
    "        print(self.db)\n",
    "\n",
    "    def get_properties(self, output=None):\n",
    "        prop = self.meta.json()['properties']\n",
    "        if output == \"json\":\n",
    "            self.properties = prop\n",
    "            return prop\n",
    "        else:\n",
    "            prop_dict = {}\n",
    "            for prop_name in prop.keys():\n",
    "                prop_dict[prop_name] = {'type':prop[prop_name]['type']}\n",
    "            self.properties = prop_dict\n",
    "            return prop_dict\n",
    "\n",
    "    def add_new_property(self,properties):\n",
    "        url = f\"https://api.notion.com/v1/databases/{DATABASE_ID}/\"\n",
    "        payload = {\n",
    "                \"properties\": properties\n",
    "            }\n",
    "\n",
    "        return requests.patch(url, data=json.dumps(payload), headers=self.headers)\n",
    "\n",
    "    def setup_add_property_payload():\n",
    "        prop_missing = self.check_notion()\n",
    "        properties = {}\n",
    "\n",
    "        for k in prop_missing.keys():\n",
    "            if prop_missing[k]['description'] == 'property':\n",
    "                properties[k] = {'type': prop_missing[k][\"type\"], prop_missing[k][\"type\"] :{}}\n",
    "\n",
    "        return properties\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 367,
   "metadata": {},
   "outputs": [],
   "source": [
    "notion = NotionDB(DATABASE_ID,KNOTION_TOKEN)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 368,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{}"
      ]
     },
     "execution_count": 368,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prop_missing = notion.check_notion()\n",
    "properties = {}\n",
    "\n",
    "for k in prop_missing.keys():\n",
    "    if prop_missing[k]['description'] == 'property':\n",
    "        properties[k] = {'type': prop_missing[k][\"type\"], prop_missing[k][\"type\"] :{}}\n",
    "properties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 365,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 365,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "notion.add_new_property(properties)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 377,
   "metadata": {},
   "outputs": [],
   "source": [
    "properties = {\n",
    "    \"appID\": {\n",
    "                \"rich_text\": [\n",
    "                    {\n",
    "                        \"text\": {\n",
    "                            \"content\": \"Amazing\"\n",
    "                        }\n",
    "                    }\n",
    "                ]\n",
    "            },\n",
    "    \"Yarn Name\": {\n",
    "                \"title\": [\n",
    "                    {\n",
    "                        \"text\": {\n",
    "                            \"content\": \"New DK Yarn\"\n",
    "                        }\n",
    "                    }\n",
    "                ]\n",
    "            },\n",
    "    \"Tags\": {\n",
    "                \"multi_select\": [\n",
    "                    {\n",
    "                        \"name\": \"Dk\"\n",
    "                    }\n",
    "                ]\n",
    "            }\n",
    "    \n",
    "  }"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 374,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'appID': {'rich_text': [{'text': {'content': 'Amazing'}}]},\n",
       " 'Yarn Name': {'title': [{'text': {'content': 'New DK Yarn'}}]},\n",
       " 'Tags': {'multi_select': [{'name': {'Dk'}}]}}"
      ]
     },
     "execution_count": 374,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "properties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 378,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "200\n",
      "{\"object\":\"page\",\"id\":\"d3aedcca-733b-4df5-8f9e-2fac3c7e3c3f\",\"created_time\":\"2023-01-29T22:36:00.000Z\",\"last_edited_time\":\"2023-01-29T22:36:00.000Z\",\"created_by\":{\"object\":\"user\",\"id\":\"eed2cf11-82bd-4aed-8d4a-7e51a8e9fb21\"},\"last_edited_by\":{\"object\":\"user\",\"id\":\"eed2cf11-82bd-4aed-8d4a-7e51a8e9fb21\"},\"cover\":null,\"icon\":null,\"parent\":{\"type\":\"database_id\",\"database_id\":\"fbf11eb2-46d2-4d6a-89a7-53e48a0b2bcf\"},\"archived\":false,\"properties\":{\"Another Property\":{\"id\":\"NE%7B%3C\",\"type\":\"rich_text\",\"rich_text\":[]},\"MultiAdd TEST 2\":{\"id\":\"NRl%3E\",\"type\":\"status\",\"status\":null},\"Another TEST Property\":{\"id\":\"R%5B%60s\",\"type\":\"rich_text\",\"rich_text\":[]},\"Yarn Company\":{\"id\":\"YhJ~\",\"type\":\"rich_text\",\"rich_text\":[]},\"new text\":{\"id\":\"_vS%60\",\"type\":\"number\",\"number\":null},\"New Property\":{\"id\":\"%60gFF\",\"type\":\"rich_text\",\"rich_text\":[]},\"new text - rich\":{\"id\":\"aaLW\",\"type\":\"rich_text\",\"rich_text\":[]},\"new property\":{\"id\":\"b%3BI%5C\",\"type\":\"number\",\"number\":null},\"MultiAdd Test 1\":{\"id\":\"eco%3C\",\"type\":\"rich_text\",\"rich_text\":[]},\"Status\":{\"id\":\"fFc%3B\",\"type\":\"status\",\"status\":{\"id\":\"70ec4523-b788-487c-82ad-a2ee57fe9086\",\"name\":\"Not started\",\"color\":\"default\"}},\"new property again\":{\"id\":\"j%5Dod\",\"type\":\"number\",\"number\":null},\"Tags\":{\"id\":\"o%5BcS\",\"type\":\"multi_select\",\"multi_select\":[{\"id\":\"370882c6-1537-46df-9ed9-0bba76fa1bf2\",\"name\":\"Dk\",\"color\":\"brown\"}]},\"STATUS Property\":{\"id\":\"rhtg\",\"type\":\"status\",\"status\":null},\"appID\":{\"id\":\"y%3DLb\",\"type\":\"rich_text\",\"rich_text\":[{\"type\":\"text\",\"text\":{\"content\":\"Amazing\",\"link\":null},\"annotations\":{\"bold\":false,\"italic\":false,\"strikethrough\":false,\"underline\":false,\"code\":false,\"color\":\"default\"},\"plain_text\":\"Amazing\",\"href\":null}]},\"Select\":{\"id\":\"%7D%7DP%3E\",\"type\":\"select\",\"select\":null},\"Yarn Name\":{\"id\":\"title\",\"type\":\"title\",\"title\":[{\"type\":\"text\",\"text\":{\"content\":\"New DK Yarn\",\"link\":null},\"annotations\":{\"bold\":false,\"italic\":false,\"strikethrough\":false,\"underline\":false,\"code\":false,\"color\":\"default\"},\"plain_text\":\"New DK Yarn\",\"href\":null}]}},\"url\":\"https://www.notion.so/New-DK-Yarn-d3aedcca733b4df58f9e2fac3c7e3c3f\"}\n"
     ]
    }
   ],
   "source": [
    "url = 'https://api.notion.com/v1/pages'\n",
    "\n",
    "payload = {\n",
    "    \"parent\": { \"database_id\": DATABASE_ID},\n",
    "    \"properties\": properties\n",
    "}\n",
    "\n",
    "res = requests.request(\"POST\", url, data=json.dumps(payload), headers=headers)\n",
    "\n",
    "print(res.status_code)\n",
    "print(res.text)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ravelry API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "class RavelryDB:\n",
    "    def __init__(self,RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY,RAVELRY_USERNAME):\n",
    "        def readRavelryProjectDatabase(RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY,RAVELRY_USERNAME):\n",
    "            base_url = 'https://api.ravelry.com'\n",
    "            return requests.get(base_url+f'/projects/{RAVELRY_USERNAME}/list.json?include=collections', auth = (RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY))\n",
    "\n",
    "        def readRavelryStashDatabase(RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY,RAVELRY_USERNAME):\n",
    "            base_url = 'https://api.ravelry.com'\n",
    "            return requests.get(base_url+f'/people/{RAVELRY_USERNAME}/stash/list.json?include=collections', auth = (RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY))\n",
    "\n",
    "        self.RAVELRY_BASIC_AUTH_USERNAME = RAVELRY_BASIC_AUTH_USERNAME\n",
    "        self.RAVELRY_BASIC_AUTH_KEY = RAVELRY_BASIC_AUTH_KEY\n",
    "        self.RAVELRY_USERNAME = RAVELRY_USERNAME\n",
    "        self.projects   = readRavelryProjectDatabase(RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY,RAVELRY_USERNAME)\n",
    "        self.stash = readRavelryStashDatabase(RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY,RAVELRY_USERNAME)\n",
    "        self.to_pandas()\n",
    "\n",
    "    def to_pandas(self):\n",
    "        r_json = self.projects.json()\n",
    "        self.project_df = pd.DataFrame(pd.json_normalize(r_json['projects']))\n",
    "        r_json = self.stash.json()\n",
    "        self.stash_df = pd.DataFrame(pd.json_normalize(r_json['stash']))\n",
    "        return self.project_df, self.stash_df\n",
    "\n",
    "    # PROJECT Functions\n",
    "    def get_project_ids(self):\n",
    "        if not hasattr(self, 'project_df'):\n",
    "            self.to_pandas()\n",
    "        return [id for id in self.project_df.id]\n",
    "    \n",
    "    def get_project_names(self):\n",
    "        if not hasattr(self, 'project_df'):\n",
    "            self.to_pandas()\n",
    "        return [id for id in self.project_df.name]\n",
    "\n",
    "    def get_project_full_single(self,id):\n",
    "        PROJECT_ID = id #self.project_df.id[id]\n",
    "        base_url = 'https://api.ravelry.com'\n",
    "        project_r = requests.get(base_url+f'/projects/{RAVELRY_USERNAME}/{PROJECT_ID}.json', auth = (RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY))\n",
    "        r_json = project_r.json()\n",
    "        return pd.DataFrame(pd.json_normalize(r_json))\n",
    "\n",
    "    def get_project_full(self):\n",
    "        project_df_list = [self.get_project_full_single(PROJECT_ID) for PROJECT_ID in self.get_project_ids()]\n",
    "        self.project_df_full = pd.concat(project_df_list)\n",
    "        return self.project_df_full.head()\n",
    "\n",
    "    # STASH functions\n",
    "    def get_stash_ids(self):\n",
    "        if not hasattr(self, 'stash_df'):\n",
    "            self.to_pandas()\n",
    "        return [id for id in self.stash_df.id]\n",
    "        \n",
    "    def get_stash_names(self):\n",
    "        if not hasattr(self, 'stash_df'):\n",
    "            self.to_pandas()\n",
    "        return [id for id in self.stash_df.name]\n",
    "\n",
    "    def get_stash_full_single(self,id):\n",
    "        STASH_ID = id\n",
    "        base_url = 'https://api.ravelry.com'\n",
    "        project_r = requests.get(base_url+f'/people/{RAVELRY_USERNAME}/stash/{STASH_ID}.json', auth = (RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY))\n",
    "        r_json = project_r.json()\n",
    "        return pd.DataFrame(pd.json_normalize(r_json))\n",
    "    \n",
    "    def get_stash_full(self):\n",
    "        stash_df_list = [self.get_stash_full_single(STASH_ID) for STASH_ID in self.get_stash_ids()]\n",
    "        self.stash_df_full = pd.concat(stash_df_list)\n",
    "        return self.stash_df_full.head()\n",
    "\n",
    "    def parse_stash_pack(self,id):\n",
    "        if not hasattr(self, 'stash_df_full'):\n",
    "            self.get_stash_full()\n",
    "        return pd.DataFrame(ravelry.stash_df_full['stash.packs'][ravelry.stash_df_full['stash.id']==id].values[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 337,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<__main__.RavelryDB at 0x1f65896ae00>"
      ]
     },
     "execution_count": 337,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ravelry = RavelryDB(RAVELRY_BASIC_AUTH_USERNAME,RAVELRY_BASIC_AUTH_KEY,RAVELRY_USERNAME)\n",
    "ravelry"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 338,
   "metadata": {},
   "outputs": [],
   "source": [
    "id = ravelry.get_stash_ids()[24]\n",
    "pack = ravelry.parse_stash_pack(id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "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>id</th>\n",
       "      <th>primary_pack_id</th>\n",
       "      <th>project_id</th>\n",
       "      <th>skeins</th>\n",
       "      <th>stash_id</th>\n",
       "      <th>total_grams</th>\n",
       "      <th>total_meters</th>\n",
       "      <th>total_ounces</th>\n",
       "      <th>total_yards</th>\n",
       "      <th>yarn_id</th>\n",
       "      <th>...</th>\n",
       "      <th>color_family_id</th>\n",
       "      <th>grams_per_skein</th>\n",
       "      <th>yards_per_skein</th>\n",
       "      <th>meters_per_skein</th>\n",
       "      <th>ounces_per_skein</th>\n",
       "      <th>prefer_metric_weight</th>\n",
       "      <th>prefer_metric_length</th>\n",
       "      <th>shop_id</th>\n",
       "      <th>thread_size</th>\n",
       "      <th>color_attributes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>103733928</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.00</td>\n",
       "      <td>24826729</td>\n",
       "      <td>200.0</td>\n",
       "      <td>640.1</td>\n",
       "      <td>7.05</td>\n",
       "      <td>700.0</td>\n",
       "      <td>192638</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>100.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>3.53</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>103733929</td>\n",
       "      <td>103733928.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.82</td>\n",
       "      <td>24826729</td>\n",
       "      <td>200.0</td>\n",
       "      <td>582.9</td>\n",
       "      <td>7.05</td>\n",
       "      <td>637.5</td>\n",
       "      <td>192638</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>108910918</td>\n",
       "      <td>103733928.0</td>\n",
       "      <td>30795153.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24826729</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>192638</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>100.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>3.53</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>104640040</td>\n",
       "      <td>103733928.0</td>\n",
       "      <td>29684683.0</td>\n",
       "      <td>0.18</td>\n",
       "      <td>24826729</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.5</td>\n",
       "      <td>192638</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>100.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>3.53</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          id  primary_pack_id  project_id  skeins  stash_id  total_grams  \\\n",
       "0  103733928              NaN         NaN    2.00  24826729        200.0   \n",
       "1  103733929      103733928.0         NaN    1.82  24826729        200.0   \n",
       "2  108910918      103733928.0  30795153.0     NaN  24826729          NaN   \n",
       "3  104640040      103733928.0  29684683.0    0.18  24826729          NaN   \n",
       "\n",
       "   total_meters  total_ounces  total_yards  yarn_id  ... color_family_id  \\\n",
       "0         640.1          7.05        700.0   192638  ...            None   \n",
       "1         582.9          7.05        637.5   192638  ...            None   \n",
       "2           NaN           NaN          NaN   192638  ...            None   \n",
       "3          57.2           NaN         62.5   192638  ...            None   \n",
       "\n",
       "  grams_per_skein yards_per_skein meters_per_skein ounces_per_skein  \\\n",
       "0           100.0           350.0            320.0             3.53   \n",
       "1             NaN             NaN              NaN              NaN   \n",
       "2           100.0           350.0            320.0             3.53   \n",
       "3           100.0           350.0            320.0             3.53   \n",
       "\n",
       "  prefer_metric_weight  prefer_metric_length  shop_id  thread_size  \\\n",
       "0                 True                 False     None         None   \n",
       "1                 True                 False     None         None   \n",
       "2                 True                 False     None         None   \n",
       "3                 True                 False     None         None   \n",
       "\n",
       "   color_attributes  \n",
       "0                []  \n",
       "1                []  \n",
       "2                []  \n",
       "3                []  \n",
       "\n",
       "[4 rows x 25 columns]"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pack"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 342,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Another Property': {'id': 'NE%7B%3C',\n",
       "  'name': 'Another Property',\n",
       "  'type': 'rich_text',\n",
       "  'rich_text': {}},\n",
       " 'MultiAdd TEST 2': {'id': 'NRl%3E',\n",
       "  'name': 'MultiAdd TEST 2',\n",
       "  'type': 'status',\n",
       "  'status': {'options': [], 'groups': []}},\n",
       " 'Another TEST Property': {'id': 'R%5B%60s',\n",
       "  'name': 'Another TEST Property',\n",
       "  'type': 'rich_text',\n",
       "  'rich_text': {}},\n",
       " 'new text': {'id': '_vS%60',\n",
       "  'name': 'new text',\n",
       "  'type': 'number',\n",
       "  'number': {'format': 'number'}},\n",
       " 'New Property': {'id': '%60gFF',\n",
       "  'name': 'New Property',\n",
       "  'type': 'rich_text',\n",
       "  'rich_text': {}},\n",
       " 'new text - rich': {'id': 'aaLW',\n",
       "  'name': 'new text - rich',\n",
       "  'type': 'rich_text',\n",
       "  'rich_text': {}},\n",
       " 'new property': {'id': 'b%3BI%5C',\n",
       "  'name': 'new property',\n",
       "  'type': 'number',\n",
       "  'number': {'format': 'number'}},\n",
       " 'MultiAdd Test 1': {'id': 'eco%3C',\n",
       "  'name': 'MultiAdd Test 1',\n",
       "  'type': 'rich_text',\n",
       "  'rich_text': {}},\n",
       " 'Status': {'id': 'fFc%3B',\n",
       "  'name': 'Status',\n",
       "  'type': 'status',\n",
       "  'status': {'options': [{'id': '70ec4523-b788-487c-82ad-a2ee57fe9086',\n",
       "     'name': 'Not started',\n",
       "     'color': 'default'},\n",
       "    {'id': 'd7bc64f1-7598-4db9-8548-bb3bace62eec',\n",
       "     'name': 'In progress',\n",
       "     'color': 'blue'},\n",
       "    {'id': 'b8fdc98e-4890-4dbf-b093-c327d9d4e274',\n",
       "     'name': 'Done',\n",
       "     'color': 'green'}],\n",
       "   'groups': [{'id': '1299867f-4a90-4c90-9be2-546c83b9062e',\n",
       "     'name': 'To-do',\n",
       "     'color': 'gray',\n",
       "     'option_ids': ['70ec4523-b788-487c-82ad-a2ee57fe9086']},\n",
       "    {'id': 'b438d22c-c706-4de3-bdcc-24ebd93808d8',\n",
       "     'name': 'In progress',\n",
       "     'color': 'blue',\n",
       "     'option_ids': ['d7bc64f1-7598-4db9-8548-bb3bace62eec']},\n",
       "    {'id': 'f4e90c1a-5759-4818-b2c9-5d13c74d261a',\n",
       "     'name': 'Complete',\n",
       "     'color': 'green',\n",
       "     'option_ids': ['b8fdc98e-4890-4dbf-b093-c327d9d4e274']}]}},\n",
       " 'new property again': {'id': 'j%5Dod',\n",
       "  'name': 'new property again',\n",
       "  'type': 'number',\n",
       "  'number': {'format': 'number'}},\n",
       " 'Tags': {'id': 'o%5BcS',\n",
       "  'name': 'Tags',\n",
       "  'type': 'multi_select',\n",
       "  'multi_select': {'options': [{'id': '370882c6-1537-46df-9ed9-0bba76fa1bf2',\n",
       "     'name': 'Dk',\n",
       "     'color': 'brown'},\n",
       "    {'id': '5e8f8740-92c7-4471-91f0-c15e6130fa85',\n",
       "     'name': 'Aran',\n",
       "     'color': 'brown'}]}},\n",
       " 'STATUS Property': {'id': 'rhtg',\n",
       "  'name': 'STATUS Property',\n",
       "  'type': 'status',\n",
       "  'status': {'options': [], 'groups': []}},\n",
       " 'appID': {'id': 'y%3DLb',\n",
       "  'name': 'appID',\n",
       "  'type': 'rich_text',\n",
       "  'rich_text': {}},\n",
       " 'Project Name': {'id': 'title',\n",
       "  'name': 'Project Name',\n",
       "  'type': 'title',\n",
       "  'title': {}}}"
      ]
     },
     "execution_count": 342,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "notion.meta.json()['properties']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "knotion",
   "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.10.8"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "8db305af926b17e0256fbf86a75ec4c075b04ce5c54af2f264ac4f4c4134a7e3"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}