Analytics Teams call via api

Question

Analytics Teams call via api

Giuseppe Minervino 0


url = "https://api.interfaces.records.teams.microsoft.com/Teams.VoiceAnalytics/getanalytics"

headers = {
    "Authorization": f"Bearer {access_token}",
    "Content-Type": "application/json"
}
params = {
    'startDate': "2025-01-01",  #start_date,  # Data di inizio
    'endDate': "2025-01-31",      # Data di fine
    #'metrics': 'PSTNTotalMinutes,TotalCallCount',  # Misure da includere
    #'dimensions': 'DocumentId,ConferenceId,DialogId,UserStartTimeUTC,EndTime,Duration,AutoAttendantChainStartTime,AutoAttendantIdentity,AutoAttendantDirectorySearchMethod,AutoAttendantTransferAction,AutoAttendantCallResult,AutoAttendantCallFlow,AutoAttendantCallerActionCounts,AutoAttendantChainDurationInSecs,AutoAttendantChainIndex,AutoAttendantCount,PSTNConnectivityType'  # Dimensioni da includere
    #'metrics': ",".join(Measurements.keys()),  # Chiavi originali delle metriche,
    #'dimensions': ",".join(Dimensions.keys())  # Chiavi originali delle dimensioni
}

I run this call after getting the token with scope

scopes = ["https://graph.microsoft.com/.default"]

but it always comes back to me "HTTPError: 403 Client Error: Forbidden for url: https://api.interfaces.records.teams.microsoft.com/Teams.VoiceAnalytics/getanalytics"

Why ?

1 answer

Your answer

Answer 1

Vasil Michev 119.5K MVP Volunteer Moderator

The scope needs to match the resource, you cannot just reuse the Graph's scopes. And given that this is an undocumented/unsupported endpoint, you're pretty much on your own here.

Hint: you can try with https://api.interfaces.records.teams.microsoft.com/.default

Anonymous

2025-01-27T01:50:04.1866667+00:00

Hi @Giuseppe Minervino

If the reply is helpful to you, please try to mark it as an answer to help others who encounter the same issue and read this thread. Thank you for your understanding and patience!
Giuseppe Minervino 0 Reputation points

2025-01-28T16:46:54.3033333+00:00

.....

Giuseppe Minervino 0

Result: 404 Client Error: Not Found for url: https://api.interfaces.records.teams.microsoft.com/Teams.VoiceAnalytics/getanalytics

 token_url = f"https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token"
    
    data = {
        "client_id": client_id,
        "client_secret": client_secret,
        "scope": scope,
        "grant_type": "client_credentials"
    }

    try:
        response = requests.post(token_url, data=data)
        response.raise_for_status()
        return response.json().get("access_token")
    except requests.exceptions.RequestException as e:
        print("Error:", response.json())
        raise e


tenant_id = "xxxxx...."  
client_id = "xxxx...."  
client_secret = "xxxx..."  
scope = "https://api.interfaces.records.teams.microsoft.com/.default"  

token = get_token(tenant_id, client_id, client_secret, scope)
print("Token:", token)

I'm making a call from a fabric notebook where powerbi has the authorized app and grant that should be enough. But despite the scope you suggested it did not give

Any other ideas ?

def generate_query(report_level, date_filter, common_query_params):
    """
    
    :param report_level: "Per Call" o "Per Day".
    :param date_filter: Oggetto datetime che specifica la data del filtro.
    :param common_query_params: Stringa comune con parametri aggiuntivi della query.
    :return: Stringa JSON formattata correttamente.
    """ 
    date_str = date_filter.strftime("%Y-%m-%d")
    
    if report_level == "Per Call":
        query = {
            "Filters": [
                {"DataModelName": "Date", "Value": date_str, "Operand": 5},
                {"DataModelName": "HasAA", "Value": "True", "Operand": 0}
            ],
            "Dimensions": [
                {"DataModelName": "DocumentId"},
                {"DataModelName": "ConferenceId"},
                {"DataModelName": "DialogId"},
                {"DataModelName": "UserStartTimeUTC"},
                {"DataModelName": "EndTime"},
                {"DataModelName": "Duration"},
                {"DataModelName": "AutoAttendantChainStartTime"},
                {"DataModelName": "AutoAttendantIdentity"},
                {"DataModelName": "AutoAttendantDirectorySearchMethod"},
                {"DataModelName": "AutoAttendantTransferAction"},
                {"DataModelName": "AutoAttendantCallResult"},
                {"DataModelName": "AutoAttendantCallFlow"},
                {"DataModelName": "AutoAttendantCallerActionCounts"},
                {"DataModelName": "AutoAttendantChainDurationInSecs"},
                {"DataModelName": "AutoAttendantChainIndex"},
                {"DataModelName": "AutoAttendantCount"},
                {"DataModelName": "PSTNConnectivityType"}
            ],
            "Measurements": [
                {"DataModelName": "PSTNTotalMinutes"},
                {"DataModelName": "TotalCallCount"}
            ]
        }
    else:  # Per Day
        query = {
            "Filters": [
                {"DataModelName": "Date", "Value": date_str, "Operand": 5},
                {"DataModelName": "HasAA", "Value": "True", "Operand": 0}
            ],
            "Dimensions": [
                {"DataModelName": "Date"},
                {"DataModelName": "AutoAttendantIdentity"},
                {"DataModelName": "AutoAttendantDirectorySearchMethod"},
                {"DataModelName": "AutoAttendantTransferAction"},
                {"DataModelName": "AutoAttendantCallResult"},
                {"DataModelName": "AutoAttendantCallFlow"},
                {"DataModelName": "AutoAttendantCallerActionCounts"},
                {"DataModelName": "PSTNConnectivityType"}
            ],
            "Measurements": [
                {"DataModelName": "AvgAutoAttendantChainDurationSeconds"},
                {"DataModelName": "AvgCallDuration"},
                {"DataModelName": "PSTNTotalMinutes"},
                {"DataModelName": "TotalCallCount"}
            ]
        }
    
    query_string = json.dumps(query) + common_query_params
    return query_string


url = "https://api.interfaces.records.teams.microsoft.com/Teams.VoiceAnalytics/getanalytics"
headers = {
    'Authorization': f"Bearer {token}",
    'Content-Type': 'application/json'
}
timeout = 300  # Timeout di 5 minuti (300 secondi)
manual_status_handling = [403, 500]  # Status HTTP gestiti manualmente

# Parametri della query
date_filter = datetime.datetime.now() - datetime.timedelta(days=1)  # Data di ieri
report_level = "Per Call"  # O "Per Day"
common_query_params = ""  # Aggiungi parametri comuni qui

# Genera la query
query = generate_query(report_level, date_filter, common_query_params)

# Esecuzione della richiesta
try:
    response = requests.post(
        url,
        headers=headers,
        data=query,
        timeout=timeout
    )
    
    # Gestione manuale degli status
    if response.status_code in manual_status_handling:
        print(f"Errore: Status code {response.status_code}")
    else:
        response.raise_for_status()  # Genera eccezione per errori HTTP non gestiti manualmente
    
    # Risultato
    print("Risposta API:")
    print(response.json())

except requests.exceptions.RequestException as e:
    print(f"Errore nella richiesta: {e}")

Share via

Analytics Teams call via api

1 answer

Your answer