SharePoint Online - File content extraction [Cognite Official]

Hey @eashwar11 ,  the file extractor allows you to upload files to CDF, and then you can load each file with pandas and upload each page as a RAW table. It’s also possible to write your own service, which will take the files directly and upload them as a RAW. For example, a snippet to upload data from each sheet to a new RAW table:

def upload_xls_file(client, file_path, db_name='Test'):
    """
    Uploads an XLS file as a Pandas dataframe, with each sheet as a new dataframe.

    Uploads it into RAW table.

    Args:
        client (CogniteCLient): a Cognite client instance
        file_path (str): The path to the XLS file,
        db_name (str): the name of the CDF RAW database

    Returns:
        A dictionary where each key is the sheet name and each value is a Pandas dataframe.
    """
    xls_file = pd.ExcelFile(file_path)
    sheet_names = xls_file.sheet_names
    dataframes = {}

    for sheet_name in sheet_names:
        client.raw.tables.create(db_name, sheet_name)
        df = xls_file.parse(sheet_name)
        dataframes[sheet_name] = df
        client.raw.rows.insert_dataframe(db_name, sheet_name, df)

    return dataframes