.. DO NOT EDIT.
.. THIS FILE WAS AUTOMATICALLY GENERATED BY SPHINX-GALLERY.
.. TO MAKE CHANGES, EDIT THE SOURCE PYTHON FILE:
.. "auto_examples/load_tests_cloud.py"
.. LINE NUMBERS ARE GIVEN BELOW.

.. only:: html

    .. note::
        :class: sphx-glr-download-link-note

        You can download :ref:`below <sphx_glr_download_auto_examples_load_tests_cloud.py>`
        the full example code. and run it online in `Codespaces <https://codespaces.new/spark-cleantech-l3/sda-copy?quickstart=1>`__

        .. image:: https://github.com/codespaces/badge.svg
            :target: https://codespaces.new/spark-cleantech-l3/sda-copy?quickstart=1

---

.. rst-class:: sphx-glr-example-title

.. _sphx_glr_auto_examples_load_tests_cloud.py:


Load Multiple Experiment Test data from the Cloud.
=================================================

This example shows :py:func:`sda.api.load.load_tests` with ``source="cloud"``:
the workbook is fetched from SharePoint on demand (cached locally after the first
download).

**Prerequisites**

- Microsoft Graph authentication (interactive browser sign-in on first use, or
  ``AZURE_*`` environment variables in CI).
- Test ``T3*`` must exist in your configured SharePoint layout (see project
  docs and ``~/sda.json`` for local sync paths vs. graph discovery).

To ignore the cache and re-download from SharePoint, pass
``force_refresh=True``.

.. GENERATED FROM PYTHON SOURCE LINES 21-24

.. code-block:: Python


    from sda.api import load_tests


.. GENERATED FROM PYTHON SOURCE LINES 25-31

.. code-block:: Python

    print("=== Loading all T3* from SharePoint (Microsoft Graph) ===")
    df = load_tests("T3*", source="cloud")

    print(f"Data shape: {df.shape}")
    print(f"Columns: {list(df.columns)}")
    print(df.head())


.. _sphx_glr_download_auto_examples_load_tests_cloud.py:

.. only:: html

  .. container:: sphx-glr-footer sphx-glr-footer-example

    .. container:: sphx-glr-download sphx-glr-download-jupyter

      :download:`Download Jupyter notebook: load_tests_cloud.ipynb <load_tests_cloud.ipynb>`

    .. container:: sphx-glr-download sphx-glr-download-python

      :download:`Download Python source code: load_tests_cloud.py <load_tests_cloud.py>`

    .. container:: sphx-glr-download sphx-glr-download-zip

      :download:`Download zipped: load_tests_cloud.zip <load_tests_cloud.zip>`