csv_to_json.py

"""
Convert CSV to JSON using DocForge API.
Usage: python csv_to_json.py
"""

import requests
import json

API_URL = "https://docforge-api.vercel.app/api/csv-to-json"

csv_data = """name,email,role,department,start_date
Alice Chen,alice@example.com,Senior Engineer,Engineering,2023-01-15
Bob Johnson,bob@example.com,Product Manager,Product,2022-06-01
Carol Williams,carol@example.com,Designer,Design,2023-03-20
Dave Brown,dave@example.com,Data Scientist,Engineering,2022-11-08
Eve Davis,eve@example.com,Marketing Lead,Marketing,2023-07-12"""


def convert():
    response = requests.post(API_URL, json={"csv": csv_data})

    if response.status_code != 200:
        print(f"Error: {response.status_code}")
        return

    result = response.json()

    print(f"Rows: {result['meta']['rowCount']}")
    print(f"Columns: {', '.join(result['meta']['headers'])}")
    print()
    print(json.dumps(result["data"], indent=2))

    # Filter example
    engineers = [r for r in result["data"] if r["department"] == "Engineering"]
    print(f"\nEngineering team ({len(engineers)} people):")
    for eng in engineers:
        print(f"  - {eng['name']} ({eng['role']})")


if __name__ == "__main__":
    convert()