ONEDRIVE_CSV

=ONEDRIVE_CSV(file_path)

=ONEDRIVE_CSV("/Apps/Boardflare Python for Excel/data.csv")

import requests
import csv
import io
 
def onedrive_csv(file_path):
    """
    Retrieves a CSV file from the user's Microsoft OneDrive App Folder using the Microsoft Graph API and a global variable `graphToken` for authentication. Returns the CSV contents as a 2D list, suitable for use in Excel.
 
    Args:
        file_path: The path to the CSV file in the user's OneDrive App Folder (e.g., '/Apps/Boardflare Python for Excel/your-file.csv').
 
    Returns:
        2D list representing the CSV file's contents, or an error message as a string.
 
    This example function is provided as-is without any representation of accuracy.
    """
    token = globals().get("graphToken", None)
    if not token:
        return "Microsoft Graph token is not set. Please click login button next to OneDrive in Functions tab."
    if not file_path or not isinstance(file_path, str):
        return "A valid file_path string must be provided."
    url = f"https://graph.microsoft.com/v1.0/me/drive/root:{file_path}:/content"
    headers = {
        "Authorization": f"Bearer {token}",
        "Accept": "text/csv"
    }
    try:
        response = requests.get(url, headers=headers)
        if response.status_code != 200:
            return f"Failed to retrieve file: {response.status_code} {response.text}"
        csv_content = response.content.decode('utf-8')
        reader = csv.reader(io.StringIO(csv_content))
        table = [row for row in reader]
        return table
    except Exception as e:
        return f"Error: {str(e)}"