Deleting logs via API using correct row IDs

delete_events = [{"id": row_id, "_object_delete": True} for row_id in ids]
requests.post(
    f"{API_URL}/v1/project_logs/{PROJECT_ID}/insert",
    headers=headers,
    json={"events": delete_events},
)

import requests

API_URL = "https://api.braintrust.dev"  # Replace with your data plane API URL if self-hosted
PROJECT_ID = "<project id>"  # UUID, not the project name
trace_root_span_id = "<root span id of the trace to delete>"
headers = {"Authorization": "Bearer " + "sk-your-api-key"}

# Look up the row IDs for every span in the trace.
# Paginate if your traces have more than 100 spans.
btql_resp = requests.post(
    f"{API_URL}/btql",
    headers=headers,
    json={
        "query": (
            f"select id from project_logs('{PROJECT_ID}') "
            f"where root_span_id = '{trace_root_span_id}' limit 100"
        )
    },
)
span_ids = [row["id"] for row in btql_resp.json().get("data", [])]
print(f"Trace contains {len(span_ids)} spans.")

# Delete each span by its row id.
delete_resp = requests.post(
    f"{API_URL}/v1/project_logs/{PROJECT_ID}/insert",
    headers=headers,
    json={"events": [{"id": span_id, "_object_delete": True} for span_id in span_ids]},
)
deleted_rows = delete_resp.json().get("row_ids", [])
print(f"Deleted {len(deleted_rows)} spans.")

check = requests.post(
    f"{API_URL}/btql",
    headers=headers,
    json={"query": f"select id from project_logs('{PROJECT_ID}') where root_span_id = '{trace_root_span_id}'"},
)
print(check.json().get("data", []))  # Should be empty