all_bookmarks_df.py

"""
Create a DataFrame with all Raindrop bookmarks
"""

import os
import requests
import pandas as pd
from dotenv import load_dotenv

# 1. Load environment variables from .env
load_dotenv()

# 2. Read configuration
API_TOKEN = os.getenv('RAINDROP_API_TOKEN')

# 3. Verify that everything is configured
if not API_TOKEN:
    raise ValueError("RAINDROP_API_TOKEN not found in .env")

print("Configuration loaded.")

# 4. Set headers for API
headers = {'Authorization': f'Bearer {API_TOKEN}'}

# 5. Retrieve all raindrops
print("Retrieving all raindrops...")

all_raindrops = []
page = 0
per_page = 50  # Max per page

while True:
    response = requests.get(f'https://api.raindrop.io/rest/v1/raindrops/0?page={page}&perpage={per_page}', headers=headers)
    response.raise_for_status()
    data = response.json()
    raindrops = data['items']
    all_raindrops.extend(raindrops)
    
    if len(raindrops) < per_page:
        break  # No more pages
    
    page += 1

print(f"Retrieved {len(all_raindrops)} raindrops.")

# 6. Create DataFrame
df = pd.DataFrame(all_raindrops)

# Select relevant columns, adjust as needed
columns = ['_id', 'title', 'link', 'tags', 'excerpt', 'created', 'lastUpdate']
df = df[columns]

# 7. Save to CSV
df.to_csv('all_bookmarks.csv', index=False, sep=';')

print("DataFrame created and saved to all_bookmarks.csv")