22-25 April 2026

Ingesting API data with Python Notebooks

Proposed session for SQLBits 2026

TL; DR

Learn how to explore REST APIs, read documentation, authenticate, and prototype API calls using external tools. Build Python functions and notebooks to load REST API data into Microsoft Fabric efficiently.

Session Details

Do you want to load data into Microsoft Fabric from REST APIs? REST APIs are everywhere. They are a great way to get data from one system to another, but they can be difficult to work with if you don't know where to start.

In this session, you will learn how to use external tools to explore a REST API. You will learn how to find the information you need in the API documentation, and how to use that information to create a Python function that loads the data into Microsoft Fabric.

Along the way you may learn a thing or two about structuring your development with variables, functions, methods and classes.

After attending this session you will be able to find and use API documentation, authenticate with an API, and prototype API calls. You will also have knowledge about the use of Python notebooks to load data from REST APIs into Microsoft Fabric.

Topics:
- REST API
- API Documentation
- API Authentication
- Prototyping with external tools
- Python Notebooks

3 things you'll get out of this session

- Understand how to read and navigate REST API documentation - Learn to authenticate with and prototype REST API calls - Build Python notebooks to load REST API data into Microsoft Fabric

Speakers

Mathias Halkjaer

fluxbi.com