Telegram – How to solve ERROR – Failed to fetch Excel data. Unable to verify username?

I agree with @user2250152, your code is using client credentials flow that works with permission of Application type. As mentioned in this MS Document, Application type permissions are not supported for updating worksheet

To call /me endpoints, you need to switch to delegated flows like interactive flow or authorization code flow for generating token.

Initially, I registered one Entra ID application and granted Files.ReadWrite permission of Delegated type as below:

In my case, I used interactive flow for which redirect URI should be http://localhost added in Mobile & desktop applications platform along with enabling public client flow option:

I have one Excel file with below sample data in my OneDrive account:

Now, I ran below modified python code that asks user to sign with interactive flow and updates excel successfully with below response:

import logging
import msal
import requests
import json

logging.basicConfig(level=logging.INFO)
logger = logging.getLogger("main")

CLIENT_ID = "appId"
TENANT_ID = "tenantId"
SCOPES = ["https://graph.microsoft.com/.default"]

def get_access_token():
    authority = f"https://login.microsoftonline.com/{TENANT_ID}"
    app = msal.PublicClientApplication(CLIENT_ID, authority=authority)

    result = app.acquire_token_interactive(scopes=SCOPES)

    if "access_token" in result:
        return result['access_token']
    else:
        logger.error(f"Failed to retrieve access token: {result.get('error_description', result.get('error'))}")
        raise Exception("Could not retrieve access token")

def read_excel():
    access_token = get_access_token()
    if not access_token:
        logger.error("Failed to obtain access token. Unable to read Excel.")
        return None
    headers = {
        'Authorization': f'Bearer {access_token}',
        'Accept': 'application/json',
    }
    url = "https://graph.microsoft.com/v1.0/me/drive/items/itemId/workbook/worksheets/Sheet1/range(address='A1:N6')"
    try:
        response = requests.get(url, headers=headers)
        response.raise_for_status()
        return response.json()
    except requests.exceptions.RequestException as e:
        logger.error(f"Error fetching Excel data: {e}")
        return None

def update_excel(range_address, values):
    access_token = get_access_token()
    if not access_token:
        logger.error("Failed to obtain access token. Unable to update Excel.")
        return False
    headers = {
        'Authorization': f'Bearer {access_token}',
        'Content-Type': 'application/json',
    }
    url = f"https://graph.microsoft.com/v1.0/me/drive/items/itemId/workbook/worksheets/Sheet1/range(address='{range_address}')"
    try:
        data = {
            "values": values
        }
        response = requests.patch(url, headers=headers, json=data)
        response.raise_for_status()
        return True
    except requests.exceptions.RequestException as e:
        logger.error(f"Error updating Excel data: {e}")
        return False


if __name__ == "__main__":
    range_address = "A1:N6"
    values = [
    ["Name", "Group Name", "Display name in reports", "Date of Joining", "Employee Number", "Designation", "Function", "Location", "Gender", "Date of Birth", "Father's/Mother's Name", "Address", "Phone No.", "E-mail"],
    ["John Doe", "Employee", "John", "01-Jan-21", 201, "Manager", "HR", "New York", "Male", "01-Jan-90", "Jane Doe", "123, Main Street, New York", 1234567890, "[email protected]"], ........
   ]

    excel_data = read_excel()
    if excel_data:
        logger.info(f"Current Excel data: {json.dumps(excel_data, indent=4)}")

    if update_excel(range_address, values):
        logger.info("Excel data updated successfully.")
    else:
        logger.error("Failed to update Excel data.")

Response:

To confirm that, I checked the same in OneDrive where Excel data updated successfully like this: