litellm - 💡(How to fix) Fix [Feature]: include deleted keys and deleted teams to the report using api [1 comments, 1 participants]

Fix Plan

To address the issue of missing deleted keys and teams consumptions in the API response, we will modify the /spend/logs/V2 endpoint to include these details.

Steps to Fix

• Update the database query to include deleted keys and teams
• Modify the API response to include the additional data
• Handle potential errors and edge cases

Example Code

# Updated database query
def get_consumption_logs():
    query = """
        SELECT * FROM consumption_logs
        WHERE team_id IN (SELECT id FROM teams) OR team_id IS NULL
    """
    results = db.execute(query)
    return results

# Modified API response
def spend_logs_v2():
    logs = get_consumption_logs()
    response = []
    for log in logs:
        if log['team_id'] is None:
            log['team_name'] = 'Deleted Team'
        response.append(log)
    return response

Verification

To verify the fix, test the /spend/logs/V2 endpoint with a sample request and check that the response includes the deleted keys and teams consumptions.

Extra Tips

• Ensure that the database query is optimized for performance to avoid impacting the API response time.
• Consider adding pagination or filtering to the API response to handle large datasets.